Search results

Infact Yes . Bit dumb for my part. Thank you again :)

Hi , I found some documentation and tutorial with your help. But I'm confused. Progress send me this error: In english : Class or Interface "CrystalDecisions.CrystalReports.Engine" not found . But as you can see in my screenshot he is in my xml assembly . Do you have any idea ? Best...

Do you have some example for that ?

We didn't changed anything on our progress program maybe a windows update as you said. I will keep looking

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

Hi, Thank you both @Stefan & @Osborne for your help. It work perfectly. The only issue I still have is that each time i update on of the "fi" variable by a value-changed trigger the browse blink. So not so good at the eye . Best Regards, - BobyIsProgress -

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

Ok I will create another thread to that. It will be more accurate .

One more questio @Rob Fitzpatrick if you can. Because I use OUTER-JOIN, sometimes I know that I will have "?" value when display the VAFDAI. I would like to be able to prompt a blank like "" if possible. I add the column like this: DEFINE VARIABLE myCol AS HANDLE NO-UNDO. ASSIGN...

Thank you Rob. I was totally blind......

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

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

Hi, If I understand it well : The ROWID is the position of a row of a table at anytime. The RECID is associated to your buffer so if you do something like this : DEFINE BUFFER BUF1 FOR CUSTOMER. DEFINE BUFFER BUF2 FOR CUSTOMER. FIND BUF1 WHERE BUF1.custnum = 100514 NO-LOCK NO-ERROR. FIND...

Maybe you can do this a do like this DEFINE VARIABLE listDate AS DATE EXTENT 2 NO-UNDO. DEFINE VARIBALE cmpt AS INTEGER NO-UNDO. ASSIGN listDate[1] = DATE("11/19/2019") listDate[2] = ? . DO cmpt = 1 TO 2 : FOR EACH ucd_receival NO-LOCK WHERE ucd_receival.id_location =...

Thank you @Stefan , I didn't notice while searching for information. I will update my code ASAP. Also one thing I'm surprised is how fast it works. I remember reading somewhere that dynamic table/query where more more slower than static one . But dosen't look that way for me .

Ok, I found the answer to my question : DEFINE VARIABLE TTFIN AS HANDLE NO-UNDO. DEFINE VARIABLE bH1 AS HANDLE NO-UNDO. DEFINE VARIABLE bH2 AS HANDLE NO-UNDO. DEFINE VARIABLE qh1 AS HANDLE NO-UNDO. DEFINE VARIABLE qh2 AS HANDLE NO-UNDO. CREATE TEMP-TABLE TTFIN ...

Hi, Some update on my progress: /*------------------------------------------------------------------------------ Purpose: Création de la table temporaire dynamique Parameters: <none> Notes: ------------------------------------------------------------------------------*/ DEFINE...

Just a mistake in writting example, my Temp Table have unique index

Thank you I found it :)

It's not that I' don't have the doc. I always search before asking. But I didn't found this option on the FOR statement Thank you @PeterB Best Regars BobyIsProgress