Chase <[EMAIL PROTECTED]> wrote:
here's the create table line:
CREATE TABLE foobar (id uniqueidentifier, foo text, bar text, PRIMARY
KEY (id));
that works great, but i have not been able so far to generate a fresh
guid to insert into the table.
in ms-sql, you'd use newid(), for example:
insert into foobar values (newid(), "Aaa", "Bbb");
There's nothing built into SQLite for this, but you can always create a
custom function named "newid" that would do the same.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
