[sqlite] unrecognized token when trying to import (.read) a database

Hi. I'm trying to convert a sqlite3 database into sqlite2 database with: c...@emx:~$ sqlite3 banco.sqlite3 .dump > dump3 c...@emx:~$ echo '.read dump3' | sqlite banco.sqlite2 CREATE TABLE `abc` (`test` TEXT); SQL error: unrecognized token: "`" c...@emx:~$ I know that the problem is in `abc`,

RE: [sqlite] unrecognized token error

> -Original Message- > From: Florent THIERY [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 15, 2006 9:27 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] unrecognized token error > > Hi > > My request: > > "create table %s (

Re: [sqlite] Unrecognized token error

On 3/20/06, Tito Ciuro <[EMAIL PROTECTED]> wrote: > If I escape single quotes (that is, from "'" to "''"), then > everything is fine. I usually do that when I want to query for a > value that contains a quote (i.e. O'Rourke). > > However, why do I have to manipulate the string value to be stored?

Re: [sqlite] Unrecognized token error

Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? If I escape single quotes (that is, from "'"

[sqlite] [LONG]Re: [sqlite] Unrecognized token error

Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? Here's the string (it's a preferences file):

Re: [sqlite] Unrecognized token error

Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string?

[sqlite] Unrecognized token error

Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito

Re: [sqlite] unrecognized token: ":"

On Thu, 2005-03-03 at 19:00 -0600, David Taylor-Fuller wrote: >char* sqlStmt=sqlite3_mprintf("INSERT INTO %q > (FileName,ArtistName,TrackNum,TrackName,AlbumName,Genre,Year) values > (%q,%q,%q,%q,%q,%q,%q)", > Can Someone please I beg of you explain to me why I am getting the >

[sqlite] unrecognized token: ":"

Ok I have skimmed the archives and even though people have had similar problems there solution all point to using '' as an escape instead of '\. However that doesnt solve my problem. I am writting a mp3player and wanted to use sqlite as the db backend for the library. Now all was going well untill