>Hi, Michelle.
>
>I use INSERT INTO, and ran into this issue early on. I have a stored procedure for generating my key ids. And I set it as the default value at the table level, just for "in-case", but otherwise I just call the stored procedure in my INSERT INTO call if I need the id. Otherwise, I just ignore it. Since I use optimistic row buffering (as a general rule), I don't run into any problems.
How do you call a stored procedure outside of the database?
Why wouldn't you need to insert an ID? I can't envision a situation where I'd want some of my records to have IDs and some not...
I don't get this problem if I insert directly to the table, not the view, but then the grid isn't focused on the right spot, so that won't work. I guess I'll have to try and do an insert into.
Thanks,
-Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only