INSERT and SQLlite command"

JOHN PATTEN johnpatten at me.com
Thu Apr 23 18:35:37 CEST 2015


Gosh darn it!  

Nevermind… 

I had the colon in the wrong spots  1: and 2: instead of :1 and :2 etc…. 

Thanks anyways!


> On Apr 23, 2015, at 9:26 AM, JOHN PATTEN <johnpatten at me.com> 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




More information about the use-livecode mailing list