Hi Mike, That did the trick. I am new to C, but I have used SQLite in Perl and Python. Thanks!*
List: sqlite-users <http://marc.info/?l=sqlite-users&r=1&w=2> Subject: Re: [sqlite] C API trouble From: "Mike Polyakov" <mike.polyakov () gmail ! com> <http://marc.info/?a=114953723100011&r=1&w=2> Date: 2007-09-30 23:49:36 <http://marc.info/?l=sqlite-users&r=1&b=200709&w=2> Message-ID: f18b74060709301649q4a439ed2pe0a2f6d7d0934cea () mail ! gmail ! com <http://marc.info/?i=f18b74060709301649q4a439ed2pe0a2f6d7d0934cea%20%28%29%20mail%20%21%20gmail%20%21%20com> [Download message RAW <http://marc.info/?l=sqlite-users&m=119119633623003&q=raw>]* Besides the unneded function calls, and a lot of checks for valid data, the problem here is that you have to copy data using memcpy or somthing similar: instead of chCommand = (const char*)sqlite3_column_text(ptrSel,2); do memcpy(chCommand, sqlite3_column_text(ptrSel,2), sqlite3_column_bytes(ptrSel,2)); chCommand[sqlite3_column_bytes(ptrSel,2)] = 0; ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- -- Andrew Sledge
