||[Feb. 14th, 2002|08:51 am]
Yesterday evening I managed to get some code working - I've been trying to get this to work for almost a week and the feeling of achievement is so good!
For those interested in the technicalities it was getting what should have been an identity column in a table to actually work that way in a system we are writing. I had to write an insert trigger in the database [easy] and then get the code to execute the correct SQL to call the trigger without putting a null value in the key field. The code is in GuptaSQL and we have an existing system we are updating which creates all the SQL for each table INSERT/UPDATE/SELECT/DELETE automatically depending upon the setting of various undocumented flags.