Search results

  1. Marco Mendoza

    QAD Product structure maintenance : date ranges may not overlap

    You need to review carefully the product structure, a structure must already exist, probably with an end date open (blank).
  2. Marco Mendoza

    Question Can we remove the space allocated for a table field in a frame when the field values is empty in CHUI?

    define frame a cs-id cs-name cs-name cs-status cs-ind1 cs-ind2 cs-ind3 /*NO NEED THIS cs-cmnt */ with down width 72. for each customer : display cs-id cs-name cs-status cs-ind1 cs-ind2 cs-ind3 with frame a . if trim(cs-cmnt) <> "" then DO: DOWN WITH FRAME a. /* down */ display cs-cmnt...
  3. Marco Mendoza

    Question Ampersand befor open

    Browses generated on QAD use it pre-processors
  4. Marco Mendoza

    Concatenating Different Records

    With "infinite loop" I mean this, what happen with this case? Record 1: - Order-Number is: 123456 - Previous-Order-Number is: 999999 Record 2: - Order-Number is 999999 - Previous-Order-Number is 111111 Record 3: - Order-Number is: 111111 - Previous-Order-Number is: 123456 Is clear logically...
  5. Marco Mendoza

    Concatenating Different Records

    Of course, you must take care for infinite loop ....
  6. Marco Mendoza

    Concatenating Different Records

    /* not tested, something like this ... */ ordernbr = "123456". find Order no-lock where Order-Number = ordernbr no-error. do while available Order: /*** code your concatenate stuff here ***/ ordernbr = Previous-Order-Number. find Order no-lock where Order-Number = ordernbr no-error. end.
  7. Marco Mendoza

    Question How to check similarity between strings?

    Can't find on my current environment, but I remember a program called "soundex.p" or somethig like that; Soundex - Wikipedia
  8. Marco Mendoza

    Buffer with no-lock

    And, It does not matter if you have a conditional in the "DO FOR", IF FALSE THEN DO FOR pt_mstr: FIND FIRST pt_mstr NO-LOCK. END. DISPLAY AVAILABLE(pt_mstr). /* This show error: ** Reference to table <table> conflicts with block statement reference. (244) */
  9. Marco Mendoza

    Question Bankers Rounding - .NET vs. ABL

    Progress Documentation
  10. Marco Mendoza

    QAD browse that shows Primary Lines as set in 18.22.1.1

    You need to convert the code to a Function. On Browse Maintenance 36.4.8.13 open ic007. Or search for other examples; there are a lot of browses with defined Functions.
  11. Marco Mendoza

    QAD browse that shows Primary Lines as set in 18.22.1.1

    If you don't have clear how to add functions code, take a look at 3.6.11 icbr007 That browse use it.
  12. Marco Mendoza

    QAD browse that shows Primary Lines as set in 18.22.1.1

    Define a function on "Local vars" section. And add a Calculated Field (local-var00) and call the Function created on Local vars.
  13. Marco Mendoza

    QAD browse that shows Primary Lines as set in 18.22.1.1

    This is the code for Primary Line value: v-primary = no. for first lna_det fields( lna_domain lna_allocation lna_line lna_part lna_site) where lna_det.lna_domain = global_domain and lna_site = lnd_site...
  14. Marco Mendoza

    Cimload " inch in 1.4.1 item number or description field

    Test this: display quoter('hello"hello') format "X(20)" The 2 quotes should work, if not is other the issue. On your example you must skip after the part number. @@batchload ppptmt.p "3012.02 6.50"" MIN" "ST" "This item has inch quotes and will not load" "please help" - - . @@end
  15. Marco Mendoza

    CIM load template for supplier maintenacne

    F1 dash and skip line: - F4 dot and skip line: .
  16. Marco Mendoza

    Question Read QRCODE

    On Webspeed app I used this QR Code Generator for generate QR images. And for read it Web QR
  17. Marco Mendoza

    How to remove duplicate values in a string

    I miss the old PEG days when lot of people would compete code for which is the most efficient or the smallest, just because.
  18. Marco Mendoza

    How to remove duplicate values in a string

    good except you will end with a string beginning with a comma.
  19. Marco Mendoza

    Count results in for-each

    Can I add i = 0 before the for each? lol
  20. Marco Mendoza

    Create a table using a variable?

    I don't fully understand your question, but maybe this example can give you some ideas, (be sure you are not using -q parameter) DEF VAR xtable-name AS CHAR NO-UNDO. xtable-name = "table1". OUTPUT TO temp.p. PUT UNFORMATTED "INPUT FROM table1.d." SKIP " REPEAT:" SKIP " CREATE " xtable-name...
Top