Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

Change in handling nullable integers in dynamic query?

I'm in the process of upgrading our current ES objects to the latest ES2009 Q3 (2009.2.0928.0). I figured out that I now need to include the DynamicQuery.dll which fixed most issue. Now in my implementation I get the following error: Error 6 Operator '=' is not defined for types 'EntitySpaces.DynamicQuery...

Posted to Dynamic Query API (Forum) by tlbignerd on 09-28-2009
Difficulty representing a Query with AND NOT in ES Query syntax

I am using needing to write an Entityspaces .WHERE construct for this query. Code: select * from stocktransaction where stockitemid = 1263 AND location =1 and date > '2009-06-02 11:58:40.00' and not (audit=27 and pos=94) and i've got most the query sorted with the following but i'm stuck on how to...

Posted to Dynamic Query API (Forum) by Paul_IBSoftware on 07-27-2009
Replace string value in WHERE

I'm working on a query to compare a string to my varchar field in the database. I want to replace certain characters, such as a dash "-" (really remove the dash). My SQL looks something like this: Code: SELECT * FROM qual WHERE REPLACE (qual.QualNumber, '-' , '' ) = REPLACE (@Number, '-' , '' ) I can...

Posted to Dynamic Query API (Forum) by tlbignerd on 07-19-2009

Page 1 of 1 (3 items)