Announcement

Collapse
No announcement yet.

Solved: Postgres auto increment

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

  • Solved: Postgres auto increment

    I am working on my first SC project (test) and I am unable to figure out how to get the auto increm. working in postgres. I setup an editable grid and set the PK in "Value in database (insert)" to auto increment (automatic). The grid on insert locks up. The field is incremented by a seq. generator in the database. Any suggestions.

  • #2
    Re: Postgres auto increment

    [quote author=bobschnell link=topic=1954.msg6202#msg6202 date=1285994258]The field is incremented by a seq. generator in the database.[/quote]

    Set it to "Database Defined". From the documentation:

    The field value is assigned by the database . The field is not used in the process of updating. For example: will be updated through a trigger.
    HTH
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #3
      solved: Postgres auto increment

      That worked. In the database value of the field: insert - database defined.
      Thanks

      Comment

      Working...
      X