PostgreSQL Serial column

Scriptcase 9 General
#1

Hi All,

I am sure I am misting something easy, but how do you define a PostgreSQL SERIAL column in ScriptCase?
I have it setup properly in the database as I can perform inserts from the SQL editor, excluding the column, and it automatically inserts a value.
Any ideas where I am going wrong?

Thanks.

#2

Hi All,

I think I figured this out:
For a SERIAL data type in PostgreSQL:
Form Settings => Edit Fields =>

New, Update, Read-Only, Required, PK should all be checked

DB Value (insert) = Auto Increment (automatic), sequence name

DB Value (update) = No setting

Then:
Form Settings => Fields => {Field_Name}

Set “Label Field” to True or Checked.

Part of my problem was thinking that I needed to be using the “Calculated by database”, since that is exactly what the database is doing.

I have dug around in the help manual and I haven’t found where it talks about the different scenarios where you use each of the values in “DB Value (insert/update)”
I could have easily missed it in the help document can someone please point me to that spot?
Or…
Is there a forum thread that explains each of the options?

Thanks.