U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Format of Select statement inside Insert..??

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

Format of Select statement inside Insert..?? [message #33748]

Sat, 10 September 2011 14:00

Monty.mvh
Messages: 31
Registered: July 2011
Location: Bangalore

Member

Hi,

I have two tables Master and Slave.
I should access value of KEY_1 generated in Master table in slave table.. How to achieve this..?
I tried with the statement
SQL & Insert(SLAVE) (KEY_1,'Select (KEY_1) .From(MASTER)');
and i got some junk value than the required ..
Is the above Statement correct..??

table1.sch:

TABLE_ ( MASTER )
INT_ ( KEY_1 ) PRIMARY_KEY AUTO_INCREMENT
STRING_ ( DATA, 20 ) PRIMARY_KEY
END_TABLE

TABLE_ ( SLAVE )
INT ( KEY_1 )
INT_ ( MKEY ) PRIMARY_KEY AUTO_INCREMENT
STRING_ ( TYPE, 40 )
END_TABLE

Report message to a moderator

Re: Format of Select statement inside Insert..?? [message #33749 is a reply to message #33748]

Sat, 10 September 2011 15:05

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

I hope this should work:

SQL & Insert(SLAVE) (KEY_1, Select (KEY_1) .From(MASTER).AsValue());

Report message to a moderator

Re: Format of Select statement inside Insert..?? [message #33751 is a reply to message #33749]

Sat, 10 September 2011 15:06

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Of course, it might not be doing what you expect...

I guess you cannot reliably get the last generated key with subsequent select (because some other client can generate another one).

Mirek

[Updated on: Sat, 10 September 2011 15:07]

Report message to a moderator

Re: Format of Select statement inside Insert..?? [message #33754 is a reply to message #33748]

Sat, 10 September 2011 17:48

Monty.mvh
Messages: 31
Registered: July 2011
Location: Bangalore

Member

Thanks mirek...
I will try this..

Report message to a moderator

Previous Topic:	EditField and Sqlite...
Next Topic:	console + sql + unicode or utf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 23 21:25:16 CEST 2024

Total time taken to generate the page: 0.02080 seconds