?

Log in

No account? Create an account
Success - Peter Sheil [entries|archive|friends|userinfo]
Peter Sheil

[ website | Peter's Home Page ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

Success [Feb. 14th, 2002|08:51 am]
Peter Sheil
[Current Mood |accomplishedaccomplished]

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.

Ahh
LinkReply