Announcement

Collapse
No announcement yet.

How to default a value for an insert

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to default a value for an insert

    Hello All,

    I am *new* to scriptcase. I am still trying the product out, but I think I really like it.
    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
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Captura.JPG

      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.
      /Giuseppe

      Professional Scriptcase Services
      Some Customers opinions

      Comment

      Working...
      X