U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

SqlArray Insert [message #4139]

Tue, 25 July 2006 02:31

rbmatt is currently offline

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

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Tue May 14 16:14:19 CEST 2024

Total time taken to generate the page: 0.02178 seconds