Search results

Hi All, I have a db where data is stored as UTF-8. I am extracting some data from it. Actually I am using a OUTPUT TO VALUE ("xxxx") NO-CONVERT but it produces me a UTF-8 with all special and national character. I would like to have my file in ASCII format without all special and especially...

I have a procedure which I am invoking manually by using prowin32.exe application. Within this procedure I have several RUN statements to run another procedures. All procedures from RUN statements are finished by RETURN statement. Main procedure is finished by APPLY "CLOSE" to this-procedure...

I am using OE10.0B. I want to migrate to Windows Server 2008 but unfortunately PET (Progress Explorer Tool) doesn't work on WS2008. Is there a OpenEdge Management console available for OE10.0B? or any workaround that help me use PET on WS2008? regards

In this whole scenario 3 PC's will be involved. PC1 (win32 machine) - where the OE tools like prowin32.exe, _progres.exe are located PC2 (linux machine) - where the db engine, databases, and my *.p procedures are located PC3 (win32 machine) - from this machine I need to invoke remotely a *.p...

I have a table like below: +-----------+ | Payments | +-----------+ |Amount | |CustID | |Country | |City | |AcctNum | +-----------+with the following data inside: Amount CustID Country City AcctNum -120 001 GER MUN 67241 -120 001...

I have SQL Query which I need to conver to 4GL. I am strugling with two issues. First, the query behave in a strange way, second, conversion. The Query select RD.ponum, V.VendorNum, AH.invoicedate, AH.invoiceamt, AH.entryperson from pub.rcvhead RH inner join pub.rcvdtl RD on...

I have a table which look like below DEFINE TEMP-TABLE Changes FIELD iKey1 AS INTEGER FIELD dDate AS DATE FIELD cChanges AS CHARACTER FORMAT "X(1000)" .Is it possible to build ONE query which will include all rows from last 60 days (based on dDate field) and all rows where iKey1 =...

I have a TEMP-TABLE 'Zmiany' which is an OUTPUT PARAMETER from procedure. I am using this TEMP-TABLE 'Zmiany' in QUERY. I am processing QUERY in DO WHILE NOT QUERY-OFF-END loop. But inside this loop I would like to search again through TEMP-TABLE 'Zmiany'. After FIND FIRST I don't know if I...

I want to skip the code execution in certain cases within DO WHILE loop. DO WHILE NOT QUERY-OFF-END('NameOfQuery'): code to execute code to execute IF .... THEN DO: code to execute code to execute IF ... THEN GET NEXT NameOfQuery. /* if TRUE then skip the rest of the...

I spent a lot of time searching for Open4GL.DynamicAPI documentation and found nothing. Can someone give a hint where I should search for such documentation? I am interesting in description of classes, members, properties, functions etc within Open4GL.DynamicAPI. thanks in advance.

I have a problem with BUFFERs, it seems like I don't understand the philosophy of buffers or I am doing something wrong. What I like to do is to create temp table, then two buffers for this temp table. In this two buffers I would like to keep two different records and modify them. Please look...

I'am struggling with simple Parent-Child problem. I have two columns like below ID ParentID MAIN 12 MAIN 07 MAIN 04 07 08 07 91 12 06 04 02 04 11 02 Now I need to achieve a correct order (Tree), unfortunatelly I am going into endless loop...