[poulh]

I'm making an application that uses a realbasic database. i want to have an ID field that auto increments. can i do this with a realDB? if not, does anyone know of a work around?

Thanks in advance

[Mike McCue]

*Disclaimer: I don't know jack about realdb, or realbasic, I don't know if it uses normal sql or not... use at your own risk*

A quick work around for your application could be to control it at the app level... in your database create an int field that is just going to be for your sudo auto-increment number.

At the beginning of your application (on startup) do a select from the database grabbing the max number from that column (something like SELECT MAX(COUNTER) FROM MYTABLE, where COUNTER is your int field described above), put that value into a variable, say COUNTER_HOLDER...

So you should have something that slightly resembles this in action:

int COUNTER_HOLDER
COUNTER_HOLDER = SELECT MAX(COUNTER) FROM MYTABLE

this will take the highest number in the database, and store it in COUNTER_HOLDER. Then when you insert rows into the database, you would increment COUNTER_HOLDER (using COUNTER_HOLDER = COUNTER_HOLDER + 1, or COUNTER_HOLDER++, however you do it..) then use that new number on the insert... Make sure to account for failed inserts by decrementing COUNTER_HOLDER on a failure.

easy enough, huh?

Mike