I'm not outside of the database. It's open because the table is open.
>How do you call a stored procedure outside of the database?
>
Right. All the records have ids eventually. Except when I screw up *g*. Since I use surrogate keys, I don't usually care about them. The ID gets generated when the _table_ is updated. When I'm connecting parent and child records I call the id function in the insert because the buffered table won't have a value otherwise. (I'm mostly not using views.)
>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...
>
Since you're using a grid, I'm guessing you use table buffering...optimistic or pessimistic, right? Are you keys surrogate (sorry if I missed that part).
>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.
Hope I'm not confusing you :-)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement