Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: byronmunya
- Order by date
-
Query problem in Pervasive when returning values between two integer parameters
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...- byronmunya
- Post #3
- Forum: Pervasive: Btrieve
-
Query problem in Pervasive when returning values between two integer parameters
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...- byronmunya
- Thread
- Replies: 3
- Forum: Pervasive: Btrieve
