Re: [sqlite] sqlite3_stat problem

>> sqlite3_bind_text(stat,1,uu2,140,NULL); > uu2 is 4 bytes, not 140; are you sure that it is valid UTF-8 text and not a > blob-o-bytes? It may also be SQLITE_TRANSIENT rather than SQLITE_STATIC ... --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org

Re: [sqlite] sqlite3_stat problem

> sqlite3_bind_text(stat,1,uu2,140,NULL); uu2 is 4 bytes, not 140; are you sure that it is valid UTF-8 text and not a blob-o-bytes? --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org

[sqlite] sqlite3_stat problem

sprintf(sql,"insert into student select 1,?,22;"); sqlite3_prepare(l_db,sql,-1,,0); char *uu1="bb"; char *uu2="Öйú"; HINSTANCE mod; Connect foo; mod

Re: [sqlite] no such function problem

This is a C question, not an SQLite question. But I'll answer it anyway. You included the function call in your quoted string, so your compiler thinks it's just random text. You need: sprint(sql, "insert into student select 3, %s, 22;", ldll("bb")); RobR

[sqlite] no such function problem

I write a function in my program: char *ldll(char *s1) { return s1; } and use it to modify my sqlite db: sprintf(sql,"insert into student select 3,ldll('bb'),22;"); but the error msg is "no such function: ldll" ___ sqlite-users mailing list