Re: [sqlite] how to create C functions and refer to them in sql

2007-08-07 Thread John Stanton
Chase 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 o

Re: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread drh
"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 o

Re: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread Joe Wilson
--- Chase <[EMAIL PROTECTED]> wrote: > 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

Re: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread Clark Christensen
Clark - Original Message From: Chase <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, August 6, 2007 2:43:13 PM 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 trigge

RE: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread James Dennett
> -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. > >

Re: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread Chase
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 i

Re: [sqlite] how to create C functions and refer to them in sql

2007-08-06 Thread Eugene Wee
You are probably looking for sqlite3_create_function: http://www.sqlite.org/capi3ref.html#sqlite3_create_function Regards, Eugene Wee Chase wrote: i need a trigger to create and insert a new guid into a table, but apparently there is no built-in function for creating guids in sqlite. i can