RE: [sqlite] Functions & Keywords

2004-01-26 Thread Williams, Ken
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 5:57 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > Williams, Ken wrote: > > > > Hmm - all of thos

RE: [sqlite] Functions & Keywords

2004-01-23 Thread Drew, Stephen
-Original Message- From: Drew, Stephen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:05 AM To: '[EMAIL PROTECTED]' Subject: [sqlite] Functions & Keywords Hello, It is straightforward to define a function in SQLite...such as MY_FUNCTION( ). Is there an equally simple

Re: [sqlite] Functions & Keywords

2004-01-22 Thread D. Richard Hipp
Williams, Ken wrote: Hmm - all of those functions seem to depend only on their argument input, making no external calls to the database. How would I implement, for example, a stored procedure that performs several inserts/selects on several database tables? I tried a little experiment with the Per

RE: [sqlite] Functions & Keywords

2004-01-22 Thread Williams, Ken
> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 5:23 PM > To: Williams, Ken; [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > Again, see the SQLite source, in particular the file func

Re: [sqlite] Functions & Keywords

2004-01-22 Thread Dennis Cote
> So after I write & compile the code, how can I tell SQLite to load it? Or > do I need to compile it into the sqlite libraries? No, you install your user defined function using the sqlite_create_function() or sqlite_create_aggreate() calls at runtime. These calls require function pointer argum

RE: [sqlite] Functions & Keywords

2004-01-22 Thread Williams, Ken
> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 1:58 PM > To: Williams, Ken; 'Drew, Stephen'; [EMAIL PROTECTED] > Subject: Re: [sqlite] Functions & Keywords > > > > Please excuse the sill

Re: [sqlite] Functions & Keywords

2004-01-22 Thread Dennis Cote
> Please excuse the silly question, but how is that done? It can't be done in SQL code. You can do it quite easily using C language API calls. These are documented in section 4 of the API documentation at http://www.hwaci.com/sw/sqlite/c_interface.html All of the built in functions in SQLite are

RE: [sqlite] Functions & Keywords

2004-01-22 Thread Williams, Ken
-Original Message- From: Drew, Stephen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 5:05 AM To: '[EMAIL PROTECTED]' Subject: [sqlite] Functions & Keywords Hello, It is straightforward to define a function in SQLite...such as MY_FUNCTION( ). Hi Drew,

[sqlite] Functions & Keywords

2004-01-22 Thread Drew, Stephen
Hello,   It is straightforward to define a function in SQLite...such as MY_FUNCTION( ).   Is there an equally simple way to define a keyword, i.e. exactly like the function above but without the parentheses?   I am trying to expand SQLite, using user-defined functions, to more closely resem