Search results

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...