Re: [sqlite] Small change to support poor man's extended features

On Tue, May 4, 2010 at 9:00 PM, Roger Binns wrote: > On 05/04/2010 03:50 PM, Aron Rubin wrote: >> If I could have a SQL function that returned an id of the current >> frame I could create poor man's variables. > > You'll need to be more specific about what you mean

[sqlite] Small change to support poor man's extended features

If I could have a SQL function that returned an id of the current frame I could create poor man's variables. In turn that would allow me to create return locations for stored procedure triggers and branching. The id would need to be unique against any parallel executions. -- Aron Rubin

Re: [sqlite] reuse of named parameters within a single statement

It would be great to include "SELECT @myparam, @myparam, @myotherparam, @myparam" is it equivalent to "SELECT ?1, ?1, ?2, ?1" in the documentation on parameters (in expressions). Thank you, Aron On 5/4/10, Jay A. Kreibich wrote: > On Tue, May 04, 2010 at 01:48:52PM -040

[sqlite] reuse of named parameters within a single statement

hich is it equivalent to: A - "SELECT ?1, ?1, ?1, ?2" or B - "SELECT ?1, ?2, ?3, ?4" Aron -- Aron Rubin Handy Husband & Daddy Jungle Gym & Senior Engineer ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users