INSERT and SQLlite command"

[Mark Schonewille]

Hi John,

What is the error you get?

Why do you have return in your syntax? Usually, SQLite syntax doesn't 
contain returns (even though it can). If you want to include a return as 
part of data, you need to encode or escape it.

Additionally, you're combining curly quotes with straight quotes. Don't 
mix them.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Installer Maker for LiveCode:
http://qery.us/468

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

LiveCode on Facebook:
https://www.facebook.com/groups/runrev/

On 4/23/2015 18:26, JOHN PATTEN wrote:
> Hi All,
>
> I have a very simple SQL Lite database consisting of three fields, an ID (INTEGER PRIMARY KEY) and two basic fields (technology char(200) and notes char(200).
>
> I am trying to INSERT records into the database.
>
> This works:
>
>   repeat with x=1 to the number of items in tTopics
>        put item y of tTopics into $technology
>        put item y of tTopics into $notes
>        put "INSERT into teacher_notes VALUES (null,'" & $technology & "','" & $notes & "');" into tSQL
>        revExecuteSQL tDatabaseID, tSQL
>
> This doesn’t work:
>
> repeat with x=1 to the number of items in tTopics
>        put item y of tTopics into $technology
>        put item y of tTopics into $notes
>        put "null" into $id
>        put "INSERT INTO teacher_notes(" & return & \
>              “id, technology, notes)" & \
>              "VALUES(" & return & \
>              "1:, 2:, 3:)" into tSQL
>        --answer tSQL
>        revExecuteSQL tDatabaseID, tSQL, "$id", "$technology", "$notes”
>
> Can anybody point out what I’m missing in the second version?
>
> Thank you!
>
> John Patten
> SUSD
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>