That's what I've done now as well while waiting to hear back if there
was some way of getting at the "free" rowID field. But I made mine of
type Integer. Why are you using VarChar for yours? That seems
counter-intuitive.
On 5/12/06, Trausti Thor Johannsson <[EMAIL PROTECTED]> wrote:
Well, as I do it, I always create my tables in code, so I always
create a table like this :
db is a realsqldatabase object, loaded and ready to go
db.sqlexecute ("create table mytable (id integer primary key,
somefield varchar.....)")
and there you have id which automatically increments after every
insert (as long as you don't put a value in there like
db.sqlexecute ("insert into mytable (somefield) values ("taada")")
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
