How to default a value for an insert

Scriptcase 8 Discussion
#1

Hello All,

I am new to scriptcase. I am still trying the product out, but I think I really like it. :slight_smile:
I have a code table that has the following fields (not literally the column names, but you get the idea):

code
description
create_user
create_timestamp
update_user
update_timestamp

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?

Thanks,

Craig Boyd

#2

You can specify on field settings. I will share a screen when in front of a Pc

#3

This is the configuration you want.

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.

Captura.JPG