Re: Reading SQLite results directly into a list
Re: Reading SQLite results directly into a list
- Subject: Re: Reading SQLite results directly into a list
- From: Axel Luttgens <email@hidden>
- Date: Sun, 1 Jun 2008 18:14:26 +0200
Le 31 mai 08 à 04:21, BareFeet a écrit :
Hi Bruce,
Doesn’t work for me - result:
"select *, '<rSep>' as rowSeparator from (select Name, Company from
Contacts where URL not null);
SQL error: no such table: Contacts"
The problem appears to be the statement "create table if not exists
Contacts"
If the "if not exists" part is removed, it works.
Hmmm, strange. What happens if you run the script a second time
witout the "if not exists"? I get the error:
SQL error near line 2: table Contacts already exists
which is why I included the "if not exists".
It's working fine here as I posted it. Anyone else having a problem
running the sample script I posted?
IIRC, support for the "if not exits" clause has been added somewhere
between versions 3.1.x and 3.4.x of SQLite.
So, could above discrepancy just be a matter of Tiger vs Leopard?
Axel
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden