Search results

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

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

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

So, There is some news on my project. Because I'm running OE10.2B08, and the fact that OpenEdge just add the .net class interface in OE 10. it's possible that I will have more chance of success with OE 11.7 or 12 . I will keep you updated. Best Regards, - BobyIsProgress -

I'm a bit surprised because when I tried to use the class: USING System.IO.DirectoryInfo . USING System.IO.FileInfo . It work perfectly but not with this one

He says that he can't cast in objSheets . DEFINE VARIABLE objSheets AS Worksheets . objSheets = CAST(objWorkbook:Worksheets,Microsoft.Office.Interop.Excel.Worksheets). It's a bit weird . I tried to adapt c# code into VB but it's very hard