> -----Original Message----- > From: Chase [mailto:[EMAIL PROTECTED] > Sent: Monday, August 06, 2007 2:43 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] how to create C functions and refer to them in sql > > > 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. > > - chase
As I understand it: you can't do that. There's no way to run compiled C code that's stored within the database (unless you write a C function to do so, but that's a chicken+egg situation). This kind of thing doesn't really match SQLite's mission of being an embedded database. -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
