Search found 5 matches

by Betalord
08.04.2010, 12:32
Forum: MySQL
Topic: How to get last inserted row's id?
Replies: 5
Views: 2073

Hm actually I read that last inserted id is "local" to the connection, meaning that if someone else increases it from another connection it won't change in current connection. Which means my approach is safe. However I was hoping ZeosLib provides some kind of feedback (result) from MySQL w...
by Betalord
07.04.2010, 13:43
Forum: MySQL
Topic: How to get last inserted row's id?
Replies: 5
Views: 2073

Yeah that works but I have to do SELECT to get it. I was wondering if there is some direct way to do it? What if something happens between INSERT and SELECT (like someone else inserts another line and increases id)?
by Betalord
06.04.2010, 19:01
Forum: MySQL
Topic: How to get last inserted row's id?
Replies: 5
Views: 2073

How to get last inserted row's id?

I am doing a simple INSERT using ZQuery and after I do insert I need the id (it's auto increment field in the data base) because I need it with the next UPDATE command. How can I get id of last inserted line?
by Betalord
02.04.2010, 09:19
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7 Alpha and Delphi 2009 Support - Official Thread
Replies: 97
Views: 29244

I don't use the latest svn, I use 700 Alpha (downloadable package from the main site).
by Betalord
01.04.2010, 23:23
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7 Alpha and Delphi 2009 Support - Official Thread
Replies: 97
Views: 29244

I have the following problem with ZeosLib 700 alpha and Delphi 2010: Everything compiles fine, but when I try to install it, error pops up: "This application has failed to start because ZDbc140.bpl was not found. Re-installing the application may fix this problem. " And immediately after t...