On Thu, Mar 09, 2006 at 10:00:50AM +0200, Roger wrote: > Hello guys. > > I have a small problem.I am trying to write some sql queries. Whenever i > put a semicolon, sqlite returns an error immediately.for instance if i > select as follows > > Select Name||" "||Surname||" ; "||Address as "Details > >From Person > where PersID=1098
What interface are you using to access sqlite? If I put a semicolon in a string from the sqlite3 command line client it works fine... e.g.: sqlite> select ';'; ; sqlite> select ";"; ; but I could easily imagine a poorly written library getting confused by such a thing. -- Nathaniel -- Details are all that matters; God dwells there, and you never get to see Him if you don't struggle to get them right. -- Stephen Jay Gould
