I am using LS 2 to build a form that will pull data form an ERP system
at work. The data is on an IBM AS400 that I connect to threw an ODBC
connection I tested the connection with this statement:SELECT
"ESSS01"."ESINV" FROM "S101735A"."CAMISFIL"."ESSS01" "ESSS01" WHERE
"ESSS01"."ESINV"=2151919and it worked.Next I tried the statement below.
The statement worked in Crystal Reports and Excel, but when I tried in
Adobe I get the error “Could not execute the query”.Any idea what is
wrong with this st...