Recent content by Arnaud_

  1. A

    accum total by, in a dynamic query

    You may can use a temp-table, or an extent variable to don't have to define a lots of variables.
  2. A

    accum total by, in a dynamic query

    Hi, From Progress help : "Note : You can use the ACCUMULATE statement only in blocks with the implicit looping property." You can't use it with dynamic query, use variables. ;)
  3. A

    Some basic progress queries.

    I don't think this answer is complete. Actually, this is the best way : def var count# as integer. for each table FIELDS() no-lock: count# = count# + 1. end. disp count# . :)
  4. A

    Mask and fill-in

    The value displayed in the browse is "AI52 A3B 44", respecting the format "AA99 A9A 99", so it can be displayed in this format in the browse because the value is known. But i'd like to force the format on the 'value-changed' of a fill-in. So, the user type the first letter, 'B' for example, and...
  5. A

    Mask and fill-in

    Hello, I would like to know how to set a mask on a fill-in, to force the user's entry? For example, i'd like to set this format on my fill-in : "AA9AA_999_999A", with each "A" = one character, each "9" = one integer and each "_" = a space. Is it possible? EDIT : I know it's possible on a...
  6. A

    Background color in column label

    Ah... I forgot that... I work in 10.2A but I don't think it's different between 10.2A & 10.2B... no? Did you tried the progress help?
  7. A

    Background color in column label

    @stokefc22 : He wants to change the label background color, not the cell bgc =) I don't think that the problem is your browse definition... it work when i try it. Don't you set the label-bgc somewhere else?
  8. A

    First-of and Last-of

    Actually, i used to work on progress V9... i didn't know these methods. But i'm recently on progress V10 so... thanks to you! ;)
  9. A

    First-of and Last-of

    Hi, Is there any method to do a "break by", with "first-of" and "last-of", in a dynamic query? Otherwise, how would you do? Thank you.
Back
Top