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 » Problem with SqlUpdate

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

Return to the default flat view

Create a new topic

Submit Reply

Problem with SqlUpdate [message #45715]

Tue, 29 December 2015 07:51

nilrum is currently offline

nilrum
Messages: 3
Registered: December 2015

Junior Member

Hi all!

How can I run the following query using the Sql Update:

update LINK set ID_OTHER = (select ID_TWO from TWO where NAME_TWO = 'Name')
where ID_LINK = 1

I tried the request, but is it wrong
SqlUpdate(LINK)(SqlSet(ID_OTHER), SqlSet(Select(ID_TWO).From(TWO).Where(NAME_TWO == "Name"))).Where(ID_LINK == 1);
==>
update LINK set (ID_OTHER) = (select ID_TWO from TWO where NAME_TWO = 'Name')
where ID_LINK = 1

How to remove the brackets around ID_OTHER?

Report message to a moderator

Send a private message to this user

[Message index]

		Problem with SqlUpdate By: nilrum on Tue, 29 December 2015 07:51
		Re: Problem with SqlUpdate By: dolik.rce on Tue, 29 December 2015 16:20
		Re: Problem with SqlUpdate By: nilrum on Tue, 29 December 2015 17:48
		Re: Problem with SqlUpdate By: dolik.rce on Tue, 29 December 2015 20:05
		Re: Problem with SqlUpdate By: nilrum on Wed, 30 December 2015 05:58
		Re: Problem with SqlUpdate By: dolik.rce on Wed, 30 December 2015 08:29

Previous Topic:	Commas into SQL
Next Topic:	MySql, boolean values and SqlArray

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat Apr 27 21:43:55 CEST 2024

Total time taken to generate the page: 0.03428 seconds