I'm working on the same kind of ERP.
For us we don't "DELETE" the BOM like that. If take the view of data management it's a savage solution.
We used an cancelation button that add the date value to candat (cancelation date) field. Like this all the application working with the BOM check if...
Is it possible to abord the window-close trigger like that:
DEFINE VARIABLE lChoice AS LOGICAL NO-UNDO.
/* This ADM code must be left here in order for the SmartWindow
and its descendents to terminate properly on exit. */
MESSAGE "Are you willing...
I found this and it works very well.
hBr = BR-TTFin:HANDLE
iCmpt = 0 .
hCol = hBr:FIRST-COLUMN .
DO WHILE VALID-HANDLE(hCol) ...
Hi @TomBascom ,
I can't thank you enough for your help. Maybe it was the modification of the VFGDAI table and also the DAWFLW without the "DO FOR buffer TRANSACTION" statement, that was causing my lock issue. With the good correction it's all ok :)
I will continue to work with the XREF and...
Hi @TomBascom ,
All the include part is from our ERP editor. I use a Window template file from them. This template give directly the variable c-stecod : code of the plants running the ERP (he can be multi-plant) ; c-uticod : that is the current user logged in this session.
I do not have...
I, on the usefull advice of @TomBascom , use the "DO FOR myTable TRANSACTION" every time I need to create, update or delete a row in tables.
But in one of my app I have an issue.
My code is write I follow:
MyTable1 will be the head of a buying request
MyTable2 will be the line of...
The thing is I can have to change the value on other column and not only one or two predefined column.
So I keep my solution for now. But i saved your solution @Osborne for when I will need it.
Thank you all for your advice and help as always :D
Hi thank you for your advice. But it seems that the trigger doesn't work.
In the same times I write this on the "ROW-LEAVE" trigger of the BROWSE and it works, but I have to go through all the column to find my difference between value .
DO iCmpt = 1 TO NUM-ENTRIES(cListData) :
Yes I think, I create it with the appbuilder tools.
I will try to turn my question arround.
So in this browser I create dynamicly the columns I want to show with the code I posted before:
And my Browse is updatable. But I don't manage to update the temp-table field with the value I write on...
I have a new one for you.
This is my case:
I have a Window app with a Temp-Table in parameter, and a list of the field I want to display:
DEFINE INPUT PARAMETER cListData AS CHARACTER. /* My list of field (index of the extent) */
DEFINE INPUT PARAMETER cListCol AS CHARACTER. /*...
when you whant to play with the width of a field there is 3 way:
width : calculate on the same scale tha, your grame width
width pixels : can be usefull when you want to manage your field width dinamicly
FORMAT : as a double use, first it adjust your field width and second it force the display...