Search results

  1. B

    Answered Saving a structuref procedure take to much time

    Hello guys, 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...
  2. B

    Question More ergonomic view

    Hello, 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 :) What is...
  3. B

    Answered IDE for progress

    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 ? Best Regards, -...
  4. B

    Answered Delimiter option in EXPORT statement

    Hello, 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 . END...
  5. B

    Answered LEAVE VS RETURN

    Hi guys, 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 ? Example: DEFINE VARIABLE i AS INTEGER i = 1 . IF i = 1 THEN LEAVE . /* VS */ DEFINE VARIABLE i AS INTEGER i = 1 . IF i = 1 THEN...
  6. B


    Hi guys, 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 ? Best...
  7. B

    Question Run command from the AppBuilder

    Hi everyone, Do you what instruction is USED by the appbuilder to run the program your currently working on ? Iike run mypgm as persistent Best regards , BobyIsProgress
  8. B

    Question Gap Between dbanalys and COUNT

    Hi guys. 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? Best Regards, - Vivien -
  9. B

    Answered GUI tools on OE10

    Hi guys, I was thinking about the OE10 tool for designing GUI: Do you know if it's specific to the OE version or if we can have more recent tool for GUI ? Best Regards, - BobyIsProgress -
  10. B

    Resolved Error Runtime with progress and crystal report

    Hi everyone, 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...
  11. B

    Question Manage output for dynamic query/browse when using OUTER-JOIN

    Hi everyon, 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...
  12. B

    Resolved 7325

    Hi everyone, 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: dispQuery:SET-BUFFERS(BUFFER FGSERV:HANDLE,BUFFER...
  13. B

    Answered Approval at distance

    Hi everyone, 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...
  14. B

    Question Question of a way to have a flex code

    Hi guys, Running OE10.2B 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 FIELD proref...
  15. B

    Answered question on query

    Hi, 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 ? Best Regards, BobyIsProgress
  16. B

    Question Using class Microsoft.Office.Interop.Excel

    Hello guys, 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...
  17. B

    Answered Persistent run

    Hi, 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 ? Best Regards, -...
  18. B

    Answered Using song effect for user action

    Hi everyone, 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...
  19. B

    Temp Table as parameter or Shared temp table

    Hi Everyone, 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...
  20. B

    Question Standardize procedure and function

    Hi Guys, 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...