If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I only display "code & description" on the form, but "create_user & create_timestamp" are required (NOT NULL).
How do I go about altering the update SQL so that those variables are passed for the insert?

Comment

First column is for inserts, second for updates.
You define datetime of insertion, and datetime for update.
For user, in this case, I write [usr_login]. It's a global var if you use security service bundled with SC. If you use your own handwriten security, or whatever, you can specify the var you need to be evaluated.