Dear Igor,
If already toinfo record exists, that time how to get the h
(primary key) (instead of rowid)?
Any shortcut for this?
Thanks in advance,
Durga.
On Wed, Jan 11, 2012 at 7:19 PM, Durga D <durga.d...@gmail.com> wrote:
> Thanks alot !!!
>
> Have a good day. Let me try.
>
>
> On Wed, Jan 11, 2012 at 7:15 PM, Igor Tandetnik <itandet...@mvps.org>wrote:
>
>> Durga D <durga.d...@gmail.com> wrote:
>> > so, first I need to insert in t0 table, then query for value from t0,
>> then
>> > update t1 with this value. Needs to avoid reading from t0 table.
>>
>> You don't need to query t0 after insert. You can use
>> sqlite3_last_insert_rowid API function, or last_insert_rowid() SQL function.
>> --
>> Igor Tandetnik
>>
>> _______________________________________________
>> 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
