U++ framework: U++ SQL » SqlArray Insert

Home » U++ Library support » U++ SQL » SqlArray Insert

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

SqlArray Insert [message #4139]

Tue, 25 July 2006 02:31

rbmatt
Messages: 90
Registered: July 2006
Location: Tennesse, USA

Member

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?

Report message to a moderator

[Message index]

		SqlArray Insert By: rbmatt on Tue, 25 July 2006 02:31
		Re: SqlArray Insert By: mirek on Tue, 25 July 2006 15:48
		Re: SqlArray Insert By: rbmatt on Tue, 25 July 2006 17:14
		Re: SqlArray Insert By: mirek on Tue, 25 July 2006 18:27
		Re: SqlArray Insert By: rbmatt on Tue, 25 July 2006 23:20
		Re: SqlArray Insert By: mirek on Wed, 26 July 2006 13:19

Previous Topic:	Fields
Next Topic:	607-Dev3 Errors (worked previously) [SOLVED]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 26 23:05:14 GMT+2 2026

Total time taken to generate the page: 0.00495 seconds