Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Problem with SqlUpdate
Re: Problem with SqlUpdate [message #45725 is a reply to message #45723] Tue, 29 December 2015 17:48 Go to previous messageGo to previous message
nilrum is currently offline  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'
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Commas into SQL
Next Topic: MySql, boolean values and SqlArray
Goto Forum:
  


Current Time: Fri May 10 11:16:29 CEST 2024

Total time taken to generate the page: 0.01496 seconds