U++ forum: Welcome to the forum

Re: SqlArray Insert [message #4146 is a reply to message #4139]

Tue, 25 July 2006 15:48

mirek
Messages: 14261
Registered: November 2005

Ultimate Member

rbmatt wrote on Mon, 24 July 2006 20:31

When my SqlArray inserts a value, it uses NULL for the ID so the DB generates an autonumber. But then if I join something else, it does not work because there is no primary key to search by (it is null in the array, but not in the DB).
Ideally, it would find the last_insert_id and set the value to the array. I couldn't get that to work, though.
I could requery the DB on insert, but I would prefer not to b/c I will have a large number of entries.
What do you suggest?

Actually, I was afraid of this moment Smile

I know for some time now that the Sql package needs fixing to find a way how to return "autonumbers".

Just to explain things: the original database it was developed for is Oracle, which instead of this feature has sequences are separate entitity.

OK, I will do that ASAP. Meanwhile, please use "InsertValue" to assign some of yours "autonumbers".

Mirek

Report message to a moderator