U++ framework: U++ SQL » GetInsertedId does not work for all data types.

Home » U++ Library support » U++ SQL » GetInsertedId does not work for all data types.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GetInsertedId does not work for all data types. [message #52530]

Fri, 18 October 2019 13:34

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

Experienced Member

The Sql::GetInsertId() call always gives an integer value of 0 if the key is a Date.

[Updated on: Fri, 18 October 2019 13:41]

Report message to a moderator

Re: GetInsertedId does not work for all data types. [message #52531 is a reply to message #52530]

Sun, 20 October 2019 10:25

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Alboni wrote on Fri, 18 October 2019 13:34

The Sql::GetInsertId() call always gives an integer value of 0 if the key is a Date.

Uhm, I did not even knew that you can have Date primary key with autoincrement... What DB is that?

Mirek

Report message to a moderator

Re: GetInsertedId does not work for all data types. [message #52532 is a reply to message #52531]

Sun, 20 October 2019 12:54

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

Experienced Member

I am using MySql. No there is no autoincrement on the key. I used GetInsertedId() in many cases to check if the Insert succeeded.
I am also seeing the relevant MySql function seems to be integer only.

Report message to a moderator

Previous Topic:	can I use 127.0.0.1 as host in open function?
Next Topic:	undefined symbol when linking pgexec mingw

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 05 19:18:31 GMT+1 2026

Total time taken to generate the page: 0.00583 seconds