Automator SQL Examples
Automator SQL Examples
- Subject: Automator SQL Examples
- From: Bruce Robertson <email@hidden>
- Date: Thu, 12 Mar 2009 10:18:42 -0700
I posted this to the Automator list but that is a very low traffic list and
so I'm posting it here also since it really is scripting related.
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.
For instance if Do this action Convert CSV to SQL:
Before:
BEGIN TRANSACTION;create table bikes( company);
Per Row:
INSERT INTO bikes values (%{1}@);
After:
end transaction;
And before the above action I point to a CSV source, and after the above
action I 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.
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