On Fri, 19 Aug 2011 08:26:49 -0700 (PDT), NOCaut <per...@mail.ru>
wrote:

> Say my some wrapper for i can make this query:
> "Select Value from Config
> Where Key = \"??????\""

In SQL, string literals are delimited by single qoutes.
So, the statement would be:

SELECT Value FROM Config WHERE Key = '??????';

Single quotes inside a string can be escaped with another single
quote. 'O'Donnell' -> 'O''Donnell'.
Of course, escaping is not needed when you sqlite3_bind*() the
values using the C programming interface.

Your question is not completely clear to me, so here are a few
pointers.

You can find some coding examples in the wiki:

http://www.sqlite.org/cvstrac/wiki?p=SampleCode

http://www.sqlite.org/cvstrac/wiki?p=SimpleCode

Also of interest might be:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Lots of links to follow from there.

Good luck.
-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to