for each

  1. H

    Understanding IF NOT AVAILABLE STATEMENT

    Hi Guys, I'm very confused and not sure why my "IF NOT AVAILABLE" statement isn't working under certain scenarios. For example when I use the FIND function in the working code with the "IF NOT AVAILABLE" statement, the "UNAVAILABLE COLOUR" message is displayed as I expect. I can then amend the...
  2. Anderson Clayton

    Get all values from created table

    Hi folks, i would like to know if its possible to know the assignments values for each attribute in one table when i run a .w file. For example, i run a program that create customer and behind de scenes are created others tables like customer-repres or whatever. i would like to know which...
  3. kasundha

    Speedup For Each Code

    Hi, I have a openedge code and it gets more than 10 hours to run. first table has 40K + records and other tables have about 5 records per each record of first table. can you give me any suggestion to improve the efficiency of this code. -------------------- FOR EACH corpdata.ArrearsRpt...
  4. jcant

    Update For Each Records

    First of all I'm sorry for the confusing title. Summarizing my need, what I need is that in the example below the last-of of break by is the record of id 3, not the record of id 4. The record of id 4 should not appear. What I think is that when the break by clause is used, all records are...
  5. P

    Answered Can I use a For Each for dynamic input in some circumstances

    Hi All, I have a code that goes ASSIGN dtLastUpdate = TODAY - 30. FOR EACH ORDER WHERE depot-num = currentDepot AND last-update >= dtLastUpdate NO-LOCK: EXPORT ORDER. END. I have a new request to give the user the option to choose all date as well as the...
  6. GirdUpYourLoins

    Lookup Fails When Casting Id To An Integer.

    I have the following code which is supposed to for each through a database table and retrieve records based on id: FOR EACH Proj_Mstr WHERE Proj_Mstr.Proj_client_ID = INTEGER(get-value("clientId")) AND Proj_Mstr.Proj_deleted = ? NO-LOCK BREAK BY Proj_Mstr.Proj_sort...
  7. J

    Question For Each Where Clause Wildcards

    Hi, I'm trying to use the wildcard "*" with the variable cReasonCode so that in the Where clause when you enter "*" it matches all records. Currently it's literally searching for the character "*" and not treating it as a wildcard. Any help would be greatly appreciated. DEFINE VARIABLE...
Top