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

Reply via email to