Re: SQL Examples
Re: SQL Examples
- Subject: Re: SQL Examples
- From: Daniel Rhoden <email@hidden>
- Date: Thu, 12 Mar 2009 15:43:16 -0500
The transaction related sql is probably a bit of an overkill for such
a controlled environment. You might want to limit the sql to only the
insert statements. I'll try out an example later on this evening if
you send me a reminder email.
On Mar 12, 2009, at 3:37 PM, Bruce Robertson wrote:
Thanks for your suggestion but it doesn't work.
That's why I keep asking for working examples.
Sorry for not following up with you earlier. I believe the course of
action is to create the database as a separate step in the beginning,
and THEN Apply SQL to that table later in the action, specifying the
database created earlier.
On Mar 12, 2009, at 12:16 PM, Bruce Robertson wrote:
It would be helpful to see some simple examples of using the
Automator SQL
funtions like Convert CSV to SQL, Apply SQL, and Execute SQL.
Bruce Robertson
For instance if Do this in Convert CSV to SQL:
Before:
BEGIN TRANSACTION;create table bikes( company);
Per Row:
INSERT INTO bikes values (%{1}@);
After:
end transaction;
And feed it to action Create SQLite Database, then the result does
not
contain any of the data.
Instead, it contains tables ZFIELD, ZRECORD, Z_METADATA,
Z_PRIMARYKEY
And none of these table contain my data.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden