Re: [sqlite] sqlite3_last_insert_rowid in transactions

[Clay Dowling]

[EMAIL PROTECTED] said:
> "Clay Dowling" <[EMAIL PROTECTED]> wrote:
>>
>> Can I get a reliable rowid from [sqlite3_last_insert_rowid()]
>> while I'm in the middle of a transaction
>>
>
> Yes.  Why would you think otherwise?

Because I work all day with SQL Server.  I have to issue a query to get
that data, and it's a query on data that doesn't actually exist yet in SQL
Server, so it tends to return 0 (this from memory; I haven't tried it in a
while).  It makes me cautious about assuming things.

Clay Dowling
-- 
Simple Content Management
http://www.ceamus.com

Re: [sqlite] sqlite3_last_insert_rowid in transactions

[drh]

"Clay Dowling" <[EMAIL PROTECTED]> wrote:
> 
> Can I get a reliable rowid from [sqlite3_last_insert_rowid()]
> while I'm in the middle of a transaction
> 

Yes.  Why would you think otherwise?

--
D. Richard Hipp   <[EMAIL PROTECTED]>

[sqlite] sqlite3_last_insert_rowid in transactions

[Clay Dowling]

I'm using SQLite in a performance-intensive data conversion process and
it's come about that it would be very useful to get the insert_rowid of
the last record inserted while I'm still in the middle of a transaction of
servert hundred inserts(the primary key will become a foreign key to a
child table).

Can I get a reliable rowid from this call while I'm in the middle of a
transaction, without interrupting the transaction?  The large transactions
are too important to sacrifice just to get this information, but it would
make the programming a lot easier to have this data.

Clay
-- 
Simple Content Management
http://www.ceamus.com