Freight01 is char datatype with size of 10
Database is Pervasive ver 9.50.077.002
The result when it works, is as follows
<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Syntax Error: SELECT cast (Freight01 as integer)as Freight01 FROM "HistoryHeader" WHERE Freight01 >= 89512...
SELECT cast(Freight01 as integer)as Freight01, PPeriod FROM "HistoryHeader" WHERE Freight01 >= 89512 and Freight01 <= 100000 order by freight01 desc; This query returns nothing
But if I change it to this "SELECT cast(Freight01 as integer)as Freight01, PPeriod FROM "HistoryHeader" WHERE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.