--- Ralf Junker <[EMAIL PROTECTED]> wrote: > I wonder if it is possible to retrieve bound host parameters from a prepared > SQL statement? I am > thinking of the opposite of the sqlite3_bind... family of functions like: > > int sqlite3_bound_int (sqlite3_stmt*, int*); > int sqlite3_bound_double (sqlite3_stmt*, double*);
You'd also need to specify the index of the ? parameter you're seeking. > They would be usefull to work around the sqlite3_trace() limitation which > does not replace host > parameters in the SQL. With the sqlite3_bound... functions, the trace > callback would be able > retrieve the parameter values from the statement and replace them or log them > separately. You could create all this functionality in your wrapper level above the sqlite3 API. It would be easy enough for you to modify the sqlite3 sources to add such functions to fish the values out of the internal Vdbe.aVar Mem array of the sqlite3_stmt. If the type does not match what is stored internally, or something was not previously bound or out of range, I imagine an SQLITE_ERROR could be returned. Or maybe you want your bound* functions to coerce the bound value to the type you specify. Another complementary function, say sqlite3_bound_type, could return the type(s) of the bound field. (I say types plural because sometimes a value can be a combination of types at the same time - i.e., MEM_Real|MEM_Int). These internal types would have to be exposed if you required such functionality. #define MEM_Null 0x0001 /* Value is NULL */ #define MEM_Str 0x0002 /* Value is a string */ #define MEM_Int 0x0004 /* Value is an integer */ #define MEM_Real 0x0008 /* Value is a real number */ #define MEM_Blob 0x0010 /* Value is a BLOB */ __________________________________________________ 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] -----------------------------------------------------------------------------
