On 12/24/15, Bart Smissaert <bart.smissaert at gmail.com> wrote: > I have no problems at all with sqlite3_bind, but I understand that the > sqlite3_result group of procedures is very similar to sqlite3_bind group. > > In a UDF procedure (callback procedure in the ActiveX dll) I do things like > this: > > sqlite3_result_text lPtr_ObjContext, VarPtr(arrBytes1(0)), lPos - 1, > SQLITE_TRANSIENT > > where arrBytes1 is a local variable, a Byte array. > This goes out of scope once the callback procedure finishes. > Could that be a problem? >
No. SQLITE_TRANSIENT causes SQLite to make its own private copy of the string. -- D. Richard Hipp drh at sqlite.org