Peter Sheil (petersheil) wrote,
Peter Sheil

  • Mood:


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.

  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.