I'm working on a structured procedure that weithg around 191ko but it takes to much time to save.
I'm running OE 10.02B (i know it's not the late version, we have planned to update to OE 11.7)
Is there some key point that can caused this enormous time of saving my structured...
I want to make my window gui more attractive to my user. But I don't know exactly how. I would like to be closed to what you can do with windows graphical object like a browse with treeview like this:
I don't know how to do it. If you have idea I will be glad to read them :)
Hello everyone ,
have you got nice holidays ?
So soon we will be able to upgrade to openedge 11.7 (the most updated version supported by our ERP vendor) .
As we will do this update we are asking ourself witch IDE use and how?
So what IDE are you using ? and Why ?
I was looking on the export statement and the delimiter option. Is there a way to put the delimiter value as variable:
DEFINE VARIABLE toto AS CHARACTER .
define TEMP-TABLE TT1
field myValue as character .
toto = "," .
FOR EACH TT1 no-lock :
EXPORT DELIMITER toto TT1 .
How are you ?
While coding today I was asking myself what is best to leave a procedure or a trigger with some test, is it the LEAVE or the RETURN ?
DEFINE VARIABLE i AS INTEGER
i = 1 .
IF i = 1 THEN LEAVE .
/* VS */
DEFINE VARIABLE i AS INTEGER
i = 1 .
IF i = 1 THEN...
Long time no see. I hope everyone is safe in this difficult time.
I have a question about the filters of the system-dialog get-file. I know how to setup multiple filters staticly and dinamicly but don't know how to get the Filter selected by the user?
Do you have any idea ?
On one of our table we did a dbanalys and he get us 39k record. But when we are executing a "COUNT" on the table, we are getting around 33k.
Do you have any why ? How is it possible?
- Vivien -
Since two weeks now we have run time error with crystal report as the image below:
We are running on our user the last version of windows.
This error is random. Sometimes we can generate 10,20,30 and more and nothing will happen. And sometimes we can have it at the height one...
While making improvement in my understanding of dynamic query I encounter a new unknown;
In fact in my dynamic Query bellow I use an outer-join on two tables : VAFDAI & VFGDAI:
CREATE QUERY dispQuery.
dispQuery:SET-BUFFERS(BUFFER FGSERV:HANDLE,BUFFER SACDPE:HANDLE,BUFFER...
While doing some dynamic query I get the following error message while performing the query-prepare at runtime :
'QUERY-PREPARE' need to have one 'FOR EACH/PRESELECT' for each buffer memory of the query
This is my code:
First Happy New Year and wish you best .
I know that the title don't tell much. I will try to be as precise as possible .
This is my case:
We have an application that allow the user to make purchase request .
For this request we have an approval workflow.
Today the user that...
I know that the subject don't say that much so I will try to explain what I'm trying to do.
I'm working on our MPS.
So this is my code :
DEFINE TEMP-TABLE TTREF
FIELD proref AS CHARACTER
FIELD prodes AS CHARACTER.
DEFINE TEMP-TABLE TTNEED
While reading some old codes I found something I don't understand:
FOR EACH <tableName> FIELDS(List of Table fields) WHERE <condition> NO-LOCK:
I search for the "FIELDS" keywork but found nothing helpfull .
Do you know something about this ?
When I need to output some formatted data on excel I used the excel API that progress give us. But it's very slow.
Do find maybe a speed up way to do it by using the Microsoft.Office.Interop.Excel .
So I found some code on progress KB that was demonstrating the error you get when...
I'm a bit confused about the run persistent .
I know how to use it for a .p procedure, but in some old programs i found "run myWindow persistent set myHdl" .
But when I replace the myWindow by a new one, my Windows don't show up but she is runing. Do you know why ?
I have a programm that's playing song if the transaction was successful and another if it wasn't. We are using them to help the operator notice that something is wrong.
But the first time it's used, it's really low to come. Do you have already done this ? how? What are your...
I will have a huge project where there is many temp tables. For some reason I will build them in a procedure file before using them in a window file.
I would like to know if it's best to push all the temp-table by parameter or by using them as shared temp-table?
What do you think...
I'm actually working on standardize our code. And I already have some procedure/function that a use on many apps.
I'm thinking of unite them in one code to simplify the maintenance & reduce the number of programs.
I just don't know if I have to go for an include or a class type...