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 dencom 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: tonyweis138
- Content: Threads
- Order by date
-
AS400 invalid token question
I am trying to run the following query and it is telling me that i have an invalid token comma. Any ideas? select *, CASE WHEN UBILOP = 'SHP' THEN '' ELSE USHACT END AS BILLTO, CASE WHEN USHVIA = '04' THEN 1 ELSE 0 END AS SAT, CASE UPAYTM WHEN '05' THEN 2 WHEN '08' THEN 2...- tonyweis138
- Thread
- Replies: 0
- Forum: ODBC/OLAP
-
MSAccess ODBC
I am writing trying to access data in an Access database via a Delphi 7 program. I have a DSN setup using the Microsoft Access driver which i am using to connect to the Access database. I am attempting to use a query like the following and it keeps giving me read access errors. It has to do...- tonyweis138
- Thread
- Replies: 5
- Forum: ODBC/OLAP
-
ODBC Text problem
I have a customer that is scanning in a value (ex. 12345.00) that needs to be matched to a value in a text file to return a row. However, the key value in the row would be 12345 without the '.00'. My problem is how to strip off that last few characters in the string. If i was doing it with...- tonyweis138
- Thread
- Replies: 5
- Forum: ODBC/OLAP
