>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