"Chase" <[EMAIL PROTECTED]> wrote: > okay, wait.... sorry.... wrong question. > > here's the deal. i want this trigger to fire -- and insert valid guids > into a table -- even outside the context of my app. > > using sqlite3_create_function(), i can create a sort of temporary > function that only works from with my app (or other running instances > of my app), but i want it to fire even if someone opens the database > file in some other 3rd-party editor and inserts/updates/deletes the > table with the trigger. > > well... it DOES fire, but when it does, it won't know what newuuid() means. > > so i guess my question should be.... how to i **INSTALL/EMBED** my > custom function **into** the database file. >
Can you use hex(randomblob(20))? Or do you really need a UUID in the RFC 4122 format? If all you need is a universally unique identifier then hex(randomblob(20)) is going to be better than anything that uuid_generate() will give you. You cannot install/embed a custom function into a database file. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
