Thanks Ron, That was what I was looking for. Just did not know where to find it. When I INSERT a new row with INTEGER PRIMARY KEY AUTOINCREMENT specified for the key column, how do I find out what the new value for that column (the new key value) as that may be the only unique column value in the table?
Vance Wilson, Ron P wrote: >If you click the link for 'create table' on the page below, you get >here: > >http://www.sqlite.org/lang_createtable.html > >Most of the constraint keywords are explained briefly there. > >RW > >Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 > >-----Original Message----- >From: sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Daniel Watrous >Sent: Thursday, January 29, 2009 1:10 PM >To: General Discussion of SQLite Database >Subject: Re: [sqlite] Index keywords > >oops, sorry, here's the link: http://www.sqlite.org/lang.html > >On Thu, Jan 29, 2009 at 11:09 AM, Daniel Watrous <dwmaill...@gmail.com> >wrote: > > >>Could this be what you're looking for? >> >>On Thu, Jan 29, 2009 at 11:04 AM, Vance E. Neff <ven...@intouchmi.com> >> >> >wrote: > > >>>I have seen that list of keywords, but I'm looking for a description >>> >>> >of > > >>>what they mean. In particular those associated with index >>> >>> >definitions. > > >>>Vance >>> >>>D. Richard Hipp wrote: >>> >>> >>> >>>>On Jan 29, 2009, at 9:38 AM, Vance E. Neff wrote: >>>> >>>> >>>> >>>> >>>> >>>>>Hi, >>>>> >>>>>I've searched and can not find where the keywords like PRIMARY, >>>>>UNIQUE, >>>>>etc. in the Documentation. Please point me to the correct section. >>>>>Also, if I use autoincrement, how do I retrieve the new index value >>>>>for >>>>>use in other tables? Again a doc. pointer would be good. >>>>> >>>>> >>>>> >>>>> >>>>http://www.sqlite.org/lang_keywords.html >>>> >>>> >>>> >>>> >>>> >>>>>Thanks! >>>>>Vance >>>>> >>>>>_______________________________________________ >>>>>sqlite-users mailing list >>>>>sqlite-users@sqlite.org >>>>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>>> >>>>> >>>>> >>>>> >>>>D. Richard Hipp >>>>d...@hwaci.com >>>> >>>> >>>> >>>>_______________________________________________ >>>>sqlite-users mailing list >>>>sqlite-users@sqlite.org >>>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>> >>>> >>>> >>>> >>>> >>>> >>>_______________________________________________ >>>sqlite-users mailing list >>>sqlite-users@sqlite.org >>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users