--- 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] -----------------------------------------------------------------------------