Mark Wyszomierski wrote:
Hi Cory,
Alright I gave it a shot from the docs but I'm not handling the
prepare statement correctly. I'm trying the ASCI version first. The
prepare statement returns an error. Here is the code snippet I'm
trying:
strSql.Format("CREATE TABLE test (something TEXT, something_else TEXT,
primary key(something))");
sqlite3_stmt *pStmt;
const char *pszTailPointer;
int nRetVal = sqlite3_prepare(db, strSql, strSql.GetLength(),
&pStmt, &pszTailPointer);
while (nRetVal == SQLITE_BUSY || nRetVal == SQLITE_ROW) {
Sleep(100);
// Try again.
nRetVal = sqlite3_step(pStmt);
TRACE("ret val was [%i]\n", nRetVal);
}
switch (nRetVal) {
case SQLITE_DONE:
TRACE("Done ok\n");
break;
case SQLITE_ERROR:
TRACE("ERROR!!!!\n");
break;
case SQLITE_MISUSE:
TRACE("MISUSE!!!!\n");
break;
default:
break;
}
sqlite3_finalize(pStmt);
return true;
Any hints?
Thanks,
Mark
On 8/13/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
On 8/13/06, Mark Wyszomierski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have been using sqlite on windows for a few months, it is great. I
> need to switch over to unicode support now though, and I am confused
> how to do this with sqlite.
>
> 1) First, when I compiled the original sqlite project, I have the
> character set to MBCS. Should I switch this to Unicode and recompile?
I think SQLite explicitly calls CreateFileW but I could be wrong.
Might as well compile as Unicode anyway.
> 2) I have been using sqlite3_exec() to execute my sql statements, but
> I see that there is no sqlite3_exec16() equivalent to take a unicode
> string. I think I'm supposed to use sqlite3_prepare16() but I have no
> idea what the last two parameters of that function are?
Check the docs, they explain how to use prepared statements.
> 3) To escape my sql statements I was using sqlite3_mprintf() - is
> there a unicode equivalent?
With prepared statements you put placeholders like "?" into your sql
and bind data to the placeholders - no escaping required.
> Thanks for any information,
> Mark
>
>
-----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
>
-----------------------------------------------------------------------------
>
>
--
Cory Nelson
http://www.int64.org
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
A "prepare" just compiles the statment, and does not get busy. You do
it to get ready for your execution loop.
You execute the compiled statement with "step" and then call "reset" to
check for errors and intialize the compiled statement ready for the next
"step". At the end of your processing you "finalize" the statement to
tidy up and let you close the database.
open
prepare
loop
step
reset
repeat
finalize
close
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
