Search results

You will receive message about ambiguous iKey1 or illegal nested block. Even for me it's not clear ...changes.iKey1 = iKey1? What is the source of second iKey1? If I will be able to do such thing the query will be look like following FOR EACH Changes WHERE Changes.dDate GE (TODAY - 60)...

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

Your answer makes the whole situation much more clear for me. The problem is in wipping out the table Zmiany. Now I know the rule but can't understand the filosophy. Why I can't fill out the BUFFER for table Zmiany in external procedure without wipping out table Zmiany? Regarding BUFFERS: 1. In...

I went through handbook and probably I know where is the problem. But not exactly. I have DefineVariable.i file which is included both, mentioned procedure and external procedure. I have also ExternalProcedure.p file and MainProcedure.p file. DefineVariable.i file: DEFINE TEMP-TABLE Zmiany...

After DEF Zmiany2 I lost Zmiany BUFFER - WHY? Because of running external procedure? The code is like following DEFINE BUFFER Zmiany2 FOR Zmiany. RUN Procedure.p (OUTPUT TABLE Zmiany). DEFINE QUERY Change FOR Zmiany, POHeader. OPEN QUERY Change FOR EACH Zmiany, EACH POHeader WHERE...

I forgot about buffers. Thank you. Now I can see that they are usefull :). Thanks.

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

Nice. This is what I was looking for. This is the same resolution as posted by Cringer. The only difference is that this one is written in one line. Now there should be an enhacement to this forum allowing to change the topic and add a [SOLVED] word. Once again. Thank you.

Yes, NEXT statement will do the Job but only if there is no nested DO WHILE loop. If I will have DO WHILE or other ITERATION loop which is nested, then NEXT will reference to this loop. In this case I will need to use 'goto' statement. It will be much better if I will be able to give a name to...

If I understand your approach then: 1. My code will execute inside DO WHILE loop a GET NEXT statement but it will go on with the rest of the code in the loop. However the code after GET NEXT statement will be using the NEXT record from Query. 2. Your code will execute a GET NEXT statement...

Re: Piew - Free PROGRESS editor and source code viewer for Win32 To PDECODE It will be very nice if you could participate in creation of new style for Notepad++. Currently there is a patch (http://www.yuvcom.com/progress4gl/) for Notepad++ for syntax highlighting. It replace a Postscript style...

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

Thanks rstanciu. I found also that "OpenEdge Development: .NET Open Clients" include usefull information. But you need to download this doc for version 10.1B. Documentation for earlier versions are very limited in information. Quick link: http://communities.progress.com/pcom/docs/DOC-19768

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.

Thank you to all of you for helping me. I need to say - nice community and fast response.

This is because the change log doesn't hold the fieldnames - it holds the LABEL attribute of field. So in Change Log I have 'Primary Bank ID', and the filename of Vendor table is 'PrimBankID'. The other thing is - I can't refer to DB table fieldname using variable, and I don't know if it is...

You are right, I want to keep two 'independent' buffers or pointers to this buffers so I can access and change data in each buffer in any place of my procedure.

I know about this additional buffer, but I did it on purpose. I don't want to be confused so I created buffer named ttVendorOrig1 and ttVendorOrig2. I need to use HANDLE's as it allows to me use :NUM-FIELDS and :NAME attributes of filed. This is why I created a TEMP-TABLES. As I said before I...

Thank you for explanation. I am new to 4GL and I thought that DEFAULT-BUFFER-HANDLE will be a default HANDLE for buffer and not for table for which I have created a buffer. One more time - thank you.

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