smason
New Member
I'm trying to use an ODBC query in Microsoft SQL Server Manager Studio to get data from an Epicor Progress DB.
The driver we have to use is OpenEdge 102a / DLL file is pgoe1023.dll if that helps.
SELECT
c.Company,
c.CallSeqNum,
c.CallDesc,
RIGHT(c.CallText, 4000),
c.SalesRepCode,
... many other fields ...
FROM MFGSYS.PUB.CRMCall AS c
However when I run that I get an error:
Error: Column "right(CallText,4000)" cannot be found at the datasource.
The reason I have to do a right statement is because that field (CallText) has a large number of characters and the Open Edge driver doesn't seem to allow more than 4000 characters. I think the actual DB field can be up to 32000 chars but for whatever reason the driver only supports 4000 chars.
So how can we select with right or even left.
The driver we have to use is OpenEdge 102a / DLL file is pgoe1023.dll if that helps.
SELECT
c.Company,
c.CallSeqNum,
c.CallDesc,
RIGHT(c.CallText, 4000),
c.SalesRepCode,
... many other fields ...
FROM MFGSYS.PUB.CRMCall AS c
However when I run that I get an error:
Error: Column "right(CallText,4000)" cannot be found at the datasource.
The reason I have to do a right statement is because that field (CallText) has a large number of characters and the Open Edge driver doesn't seem to allow more than 4000 characters. I think the actual DB field can be up to 32000 chars but for whatever reason the driver only supports 4000 chars.
So how can we select with right or even left.