I assume the wrapper has wrapped this particular function. I'm
currently writing my own wrapper and it has wrapped it as well.
This is my definition (in case your wrapper doesn't have it):
/// <summary>
/// Returns the lengh of data in a single column of the current result row
of a query
/// </summary>
/// <param name="statementhandle">Statement handle</param>
/// <param name="column">Zero based column index. The left-most column has
an index of 0</param>
/// <returns>Column data length. If the SQL statement is not currently
pointing to a valid row, or if the the column index is out of range, the
result is undefined</returns>
[DllImport("sqlite3.dll", CallingConvention=CallingConvention.Cdecl)]
internal static extern Int32 sqlite3_column_bytes(IntPtr statementhandle,
Int32 column);
Rob
----- Original Message -----
From: "Lloyd Dupont" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, October 23, 2005 3:46 PM
Subject: Re: [sqlite] built-in functrion suggestion: size of blob
Isn't this what you are looking for?
http://www.sqlite.org/capi3ref.html#sqlite3_column_bytes
" If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB. "
Or do you really need it inside an SQL statement?
that's right!
I'm not using SQLite C API.
I'm using a .NET wrapper.
I don't see how I could could call this function in a pratical way from
the wrapper...