Viewing 15 posts - 14,566 through 14,580 (of 18,923 total)
What are you doing exactly that will need more than 1400 levels???
August 10, 2005 at 7:24 am
The whole question is here "when trigger fires". Not a bad guess at all
.
August 10, 2005 at 7:20 am
Also one other thing, if you have a user defined datatype you will get 2 rows for those columns... unless you didn't build the query exactly as I did back...
August 10, 2005 at 7:17 am
You're right it's possible. Did you try my trick???
August 10, 2005 at 7:05 am
Actually even if you have no row, you should have a PK... unless you don't want to have an actual table
.
August 10, 2005 at 7:03 am
That's why I like to be the only programmer in the place
.
August 10, 2005 at 6:56 am
You'd have to code everything with dynamic sql on the server anyways to do this. It might be easier to do it client side. Unless someone has some mapping trick...
August 10, 2005 at 6:54 am
A table is still a table, and it has to have some sort of unique key that uniquely identifies the data. Do you have an exemple of such a...
August 10, 2005 at 6:47 am
What happens if you copy the parameters to local variables and use those in the query?
August 10, 2005 at 6:37 am
This would seem like a lousy workaround,
from the "main" sp :
insert into #temptable (col1, col2)
exec dbo.SubSP params
Now you have a copy of the recordset in a temp table. ...
August 10, 2005 at 6:25 am
As far as I know access need at least a unique constraint to work. There are many problems related to that and you apparently discovered another one. BTW why...
August 10, 2005 at 2:13 am
Yup, I made it for insert/updates in case you have inserts with that flags on... but this is not necessary if that flag can only be updated.
August 9, 2005 at 1:03 pm
Welcome to the club... the not enough coffee club
.
August 9, 2005 at 11:21 am
Viewing 15 posts - 14,566 through 14,580 (of 18,923 total)