Recent content by ChezJfrey

Sorry, I wasn't explicit - the NO-ERROR statement does not allow the program to continue, it still terminates on the BUFFER-COPY statement.

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

Try using the PROGRAM-NAME function: DEFINE VAR level AS INT INITIAL 1. REPEAT WHILE PROGRAM-NAME(level) <> ?. DISPLAY LEVEL PROGRAM-NAME(level) FORMAT "x(30)". level = level + 1. END.

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

If using VBScript in ASP, try: FormatNumber(Expression ,NumDigitsAfterDecimal)

Oversights abound Thanks for the reply. It's amazing what a night's sleep and some helpful advice will do. I must admit that the 4GL code I posted was not actually what I was running. I had the Operation-ID exlusions in a preprocess string and when I checked my code this morning I noticed...

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

SOLVED: Insufficient access privelege, But ?? remain Trial and error has uncovered a solution, but I am puzzled. I wrote out the DBPARAM() strings for each connected db and found that the WIN2k db did not have a username. The program was launched with a -pf specified that did not supply it...

Use DBPARAM("DBLogicalName"). It returns a comma separated list that you can iterate using ENTRY().

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

SOLVED This is what I want, thanks.

Here is a more specific example of my problem. Is there any way to make the Progress code more efficient or faster? I ask because I want to perform a similar query where I insert/delete records based on the result set rather than merely display. The following SQL statement takes 36 seconds...

Thanks. I figured I could use nested statements, but the single SQL statement is quite elegant and was wondering if the left-join phrase used in an open query statement would accomplish the same thing by returning only records in the table with missing records. Or is at least one nested...

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?

I have had similar experiences. It appears that finding records with fields in the where clause (or table joins without every field of the primary index) not contained in an index seem inordinately slow. Try adding a trip_type to your query, or add an index that contains just the batch_number...