INSERT and SQLlite command"

Peter Haworth pete at lcsql.com
Thu Apr 23 12:39:29 EDT 2015


Also, if id is your primary key, no need to provide a value for it,
although that does mean you will have to name the other two fields in the
INSERT statement.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Thu, Apr 23, 2015 at 9:35 AM, JOHN PATTEN <johnpatten at me.com> wrote:

> 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
>
>
> _______________________________________________
> 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