Announcement

Collapse
No announcement yet.

how to make ID (auto increment) appear before save / commit

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

  • how to make ID (auto increment) appear before save / commit

    how to make ID (auto increment) appear before save / commit?

  • #2
    Explain better what do you want to achieve, id is already auto incremented by your db when commit occurs.

    Comment


    • #3
      Hi Clauu,

      You right what id is auto incremented BY DB when commit occurs. But I want it to appear on the form before commit (add button).

      Comment


      • #4
        Then you'll have to add a new field visible ony in insert mode and in a event like onload set that field with the latest id from db or use the grid lookup

        Comment


        • #5
          If you are using an auto increment field you simply cannot. If you use a simple integer you can do a select max(myid) from mytable to get the highest available key and add 1 to it. You can do this in the onload event.

          I strongly recommend *not* using this technique if more than one user can access your application. Suppose two people want to add a record. As long as the new number is not inserted both will get the same key. ONe can save, the other will get a duplicate key error.
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            Makes sense. Thanks Albert.

            Comment

            Working...
            X