Thanks a lot Joe, I'll take a look at that.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/



On Oct 18, 2007, at 7:05 PM, Joe Wilson wrote:

--- Marco Bambini <[EMAIL PROTECTED]> wrote:
I need to create a custom function that returns all the value from
that row.
If the * syntax was supported then I don't need to save or retrieve
all the column's name for that table.

Here's a simple workaround similar to the 'eval' function in scripting:

Look in vacuum.c and you'll see 2 functions: execSql and execExecSql.
Create sqlite function wrappers for them. Using these wrapped user
functions and querying the sqlite_master table will allow you to
generate the SQL query you want with an expanded arg list. This
generated SQL will in turn be executed by these functions.
There are many example in vacuum.c.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------- -------
To unsubscribe, send email to [EMAIL PROTECTED]
---------------------------------------------------------------------- -------



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to