Re: [sqlite] Availablility of current row information in a select

2008-06-23 Thread Igor Tandetnik
John Stanton <[EMAIL PROTECTED]> wrote: > Without looking up my code I recollect being able to pick up the > connection pointer from the context and to continue accessing the DB. But that's not what the OP is asking. He wants the function to pick up values from the current row it is being called

Re: [sqlite] Availablility of current row information in a select

2008-06-23 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > > Given a user-defined function of Foo(), and a query such as > > select * from sometable where foo() > > Is it possible from within the body of Foo() to access data from the > current row of the database that is being examined? > > For instance, if I have a text

Re: [sqlite] Availablility of current row information in a select

2008-06-23 Thread John Stanton
Without looking up my code I recollect being able to pick up the connection pointer from the context and to continue accessing the DB. Igor Tandetnik wrote: > [EMAIL PROTECTED] wrote: > >>Given a user-defined function of Foo(), and a query such as >> >>select * from sometable where foo() >>

Re: [sqlite] Availablility of current row information in a select

2008-06-23 Thread Igor Tandetnik
[EMAIL PROTECTED] wrote: > Given a user-defined function of Foo(), and a query such as > > select * from sometable where foo() > > Is it possible from within the body of Foo() to access data from the > current row of the database that is being examined? As far as I know, no. You would need to

[sqlite] Availablility of current row information in a select

2008-06-23 Thread dan.winslow
Hi folks- Given a user-defined function of Foo(), and a query such as select * from sometable where foo() Is it possible from within the body of Foo() to access data from the current row of the database that is being examined? For instance, if I have a text field in the db record named