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 » Bitwise and, or, xor in sql
Bitwise and, or, xor in sql [message #59961] Fri, 23 June 2023 19:07
Alboni is currently offline  Alboni
Messages: 214
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
Example: select all rows with odd numbers
select MT_ID From MY_TABLE Where MT_ID & 1;


When I try to code that in Upp it doesn't compile.
Sql sql;
sql*Select(MT_ID).From(MY_TABLE).Where(MD_ID & 1);
while (sql.Fetch())
{
...
}

......./test.cpp (114): error: invalid user-defined conversion from 'int' to 'const Upp::SqlId&' [-fpermissive]
Is there a way? (besides sql.Execute())
Previous Topic: Sqlite3 ChangePassword() failed.
Next Topic: Strange (perhaps) DropList ctrl behaviour
Goto Forum:
  


Current Time: Mon Apr 29 12:41:11 CEST 2024

Total time taken to generate the page: 0.02719 seconds