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: BareFeet <email@hidden>
- Date: Sat, 31 May 2008 12:21:29 +1000
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?
Thanks,
Tom
BareFeet _______________________________________________
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