Search results

  1. K

    Selection list - dynamically set intial

    Is there a way to dynamically set the initial value of a selection list? I have a screen that I am developing and the selection list I am using has different values depending on what is passed in but no matter what I want to select the 1st value in the selection box once it's been populated...
  2. K

    Speeding up query

    Yea, I knew I would need to rewrite it because the function causes a whole-index. I like the example you have above but the second lookup causes an issue doesn't it? repeat i = 1 to num-entries(var1,","): FOR EACH tbl1 NO-LOCK WHERE tbl1.fld1 = entry(i,var1,","): do x = 1 to...
  3. K

    Speeding up query

    Morning all, I'm rewriting a screen and the browse in it is based on data pulled from several tables. The way I've got it now, the user selects data from a few selection boxes (multi-selection available) and based on the data selected the query is ran: /* The variables contain the...
  4. K

    Fetching Selected Records in Brw

    Yes! That seems to work for me too, thanks for the help! It's returning the recids.
  5. K

    Fetching Selected Records in Brw

    Here is what I tried for the looping idea: DO v-cnt = 1 TO brw-deploy:NUM-SELECTED-ROWS: MESSAGE brw-deploy:FETCH-SELECTED-ROW(v-cnt) VIEW-AS ALERT-BOX INFO BUTTONS OK. END. I used MESSAGE just to see if anything was returned and it returned "yes" everytime. How do...
  6. K

    Fetching Selected Records in Brw

    Ok, thanks I'll give those a try!
  7. K

    Fetching Selected Records in Brw

    I'm having issues with a multi-selection browse I'm developing. The browse is displaying a query from a temp-table that is created earlier in the program. The issue I'm having is how to find out what the user has selected. I've played around with several different triggers and still can't...
  8. K

    Selection-List: Getting multiple values

    It seems like you aren't understanding the question, either way it doesn't matter. The code does what I need it to
  9. K

    Selection-List: Getting multiple values

    Well, I needed the private-data of the items that the user selects. The same would've worked if I used the LIST-ITEMS attribute instead of PRIVATE-DATA.
  10. K

    Selection-List: Getting multiple values

    Just got a lightbulb: ASSIGN v-list = sel-list:PRIVATE-DATA. DO v-cnt = 1 TO NUM-ENTRIES(v-list): v-selected = sel-list:IS-SELECTED(v-cnt). IF v-selected THEN DO: IF v-hosts = "" THEN ASSIGN v-hosts =...
  11. K

    Selection-List: Getting multiple values

    I'm working with a selection-list and I'm allowing users to select multiple values in the list. How do I get all of the selected values into a variable? I can see there is an IS-SELECTED() method but I can't seem to get it to work. Does anyone know how to get this working correctly?
  12. K

    dynamic find-next() on buffer-handle

    I think the only option is to actually use a dynamic query. I've ran into similar issues/circumstances but I ended up using a dynamic query or just converting my dynamic table back to a non-dynamic temp-table. If there is however a solution to your proble other then that I would also be...
  13. K

    UCC 128 Barcode generation

    Ok, thats not really what I'm looking for though. I'm asking about the code 128. It seems like it should be as simple as assigning the font and putting to the stream but it doesn't seem to be working. Is the check digit required?
  14. K

    UCC 128 Barcode generation

    I'm working on a report that needs to print out a code 128 barcode on it and haven't found much in the way of help for such a task. Can anyone point me in the right direction for finding this, some code examples perhaps?
  15. K

    Alternative to ADD-LIKE-COLUMN

    I'm using OE 101.B. I've used chain attr and methods in my code before, here is what I coded just incase I missed something: hdl-test-tbl:ADD-LIKE-COLUMN(hdl-buffer:BUFFER-FIELD("t-new-field"):FORMAT = "yes/no").
  16. K

    Alternative to ADD-LIKE-COLUMN

    Here's the error I got: Invalid datatype for argument to method 'ADD-LIKE-COLUMN'. Expecting 'handle' (5442) I've tried to add the LOGICAL function around it too. I'm really stumped on this one.
  17. K

    Alternative to ADD-LIKE-COLUMN

    I tried that, didn't work. I've been toying with a few different ways to format it with no luck so far.
  18. K

    Alternative to ADD-LIKE-COLUMN

    Hey all, I'm working on a project and one of the tasks I'm looking into is adding a field to a browser thats from a database. It's pretty simple to implement since it's a new field that was added to the table that the program is already using. The problem is, the new field is a logical and...
  19. K

    Add leading zero to field from csv

    I'm having trouble with a field that I'm reading in from a .csv and loading into a temp-table. The field can (and does) contain characters and integers so the datatype is character for the temp-table field. The only problem is I can't figure out how to add a leading zero for an integer that is...
  20. K

    Nesting dynamic queries

    Thats the answer I was looking for. Also, thanks for the short hand notation note. I remember seeing that somewhere during my training (just under a year ago) but forgot where it was used. Thanks.
Top