I am trying to use SQL Server 2000 to pull from Progress using OpenLink Lite 8.3e .. the query I am trying to run is
select usrw_charfld[11] format x(20) from usrw_wkfl
i can run with no problems so it is a syntax issue
select usrw_charfld[11] from usrw_wkfl
the error I recieve is
[OpenLink][ODBC][Progress Server]** Unable to understand after -- "DECLARE". (247)
format is a key word in sql ... does anyone know how I can run this command?
Thank you for any help ... been scratching my head over this for a week.
select usrw_charfld[11] format x(20) from usrw_wkfl
i can run with no problems so it is a syntax issue
select usrw_charfld[11] from usrw_wkfl
the error I recieve is
[OpenLink][ODBC][Progress Server]** Unable to understand after -- "DECLARE". (247)
format is a key word in sql ... does anyone know how I can run this command?
Thank you for any help ... been scratching my head over this for a week.