Jay5962

piunitbatch: overloaded functions don't work on Col. Product

Discussion created by Jay5962 on Jun 15, 2009
Latest reply on Jun 16, 2009 by Jay5962

Hi guys

 

I’m trying to do some generic queries using Like and Left on the column piunitbatch.product, however when running the queries I get back this error<

 

Overload resolution failed for (LIKE) argument(s)

SELECT  * FROM pibatch..piunitbatch where product LIKE 'IMO*'

Overload resolution failed for (Left) argument(s)

SELECT  "batchid", "starttime", "endtime", left("product",4) PackingArea, "procedure", "moduleuid", "batchuid" FROM "pibatch".."piunitbatch"

These same arguments work on other columns like UID, could you please if an alterative syntax is required or a limitation in the driver?

Outcomes