autoinc on regular int

[joeharth]

Hello, I am testing Dadabik with sybase and so far seems to work fine after many many tweaks. I turned off the identity fields and convert them to numberic. Now i am try to set it up so when i do an insert it generates it the next integer. is there a way to do this? some how do a select max(id)+1 from table and put that value in the field? I saw the default value field but I am not sure if I can put sql in it.
Thanks.

 

[DebbieS]

Don't know if I've understood your question correctly, but in my tables, I set my id fields to auto-increment in MySQL and it increments each new record's ID by one on entry.

 

[joeharth]

Thank for the reply. Yes dadabik work great with mysql but for other DBs, it gets tricky. I was thinking I could set up a default value of select max(*)+ 1 or something like that . I testing out Dadabik with sybase and so far a few big glitches but it is almost funtional.