U++ framework: U++ SQL » Problem with SqlUpdate

Home » U++ Library support » U++ SQL » Problem with SqlUpdate

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

Re: Problem with SqlUpdate [message #45725 is a reply to message #45723]

Tue, 29 December 2015 17:48

nilrum
Messages: 3
Registered: December 2015

Junior Member

Quote:

Welcome to the forum

Thanks Honza

Quote:

The problematic brackets come from SqlSet(). You actually want just a single value, not a set of values:

SqlUpdate(LINK)(ID_OTHER, SqlSet(Select(ID_TWO).From(TWO).Where(NAME_TWO == "Name"))).Where(ID_LINK == 1);

This should work as you intended.

So I tried to write, but I receive an error

error C2664: 'Upp::SqlUpdate &Upp::SqlUpdate::operator ()(const Upp::SqlId &,Upp::SqlVal)' : cannot convert argument 1 from 'Upp::SqlId' to 'const Upp::SqlSet &'
Reason: cannot convert from 'Upp::SqlId' to 'const Upp::SqlSet'

Report message to a moderator

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

] [

]

Current Time: Tue Oct 06 20:00:46 GMT+2 2026

Total time taken to generate the page: 0.48446 seconds