I am using a Dataserver to connect to an SQL database and using the BUFFER-COPY statement to transfer a record from the Progress db to the SQL db. I received error 6174 because the SQL db was migrated from the Progress definitions and a field contains a decimal value that exceeds the defined...
I receive essentially the same error with the Initialize-Document-Type and Create-Node-Namespace:
X-NODEREF or X-DOCUMENT INITIALIZE-DOCUMENT-TYPE got an error: Method not implemented. (9082)
/* Test 1 code */
DEFINE VARIABLE xDoc AS HANDLE NO-UNDO.
CREATE X-DOCUMENT xDoc.
xDoc...
An SQL statement run through ODBC in MSAccess takes 20 seconds to return a result set. My equivilant in Progress takes 35 minutes to iterate the records in a 'FOR EACH'. Both are displayed below. Can anyone pinpoint possible syntactical oversights that may be hindering the Progress...
The COMPILE statement below throws this error: Insufficient access privilege for table MyTable. (234). I checked the data security for AS400 db using Data Admin and each table throwing the error has complete access. The calling program resides on a WIN2k machine and is initially connected to...
I don't seem to have a grasp of the Progress syntax required to form the equivilant of this:
SELECT A.Field1, A.Field2, B.Field1, B.Field2
FROM A LEFT JOIN B ON A.Field1 = B.Field1 AND A.Field2 = B.Field2
WHERE B.Field1 IS NULL
Anyone care to help?
The following code reads a text file to import records. I receive modal pop-ups with a warning when a unique record already exists. I would like to just ignore these and move to the next record, but I am unable. Is there any way to do this without expressly finding whether the unique record...
I have a report that takes about 5-10 seconds to preview in the Report Builder development interface. However, using the code below to launch the same report within a procedure, with the same selection criteria passed as parameters, the report takes about 15 minutes to display. Does anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.