Search results

  1. R

    domain comparision

    First you are doing a find first on empty temp tables after which you put the entire contents of pt_mstr and in_mstr and later you put a not equal to condition between the temp tables and pt_mstr and in_mstr where no records will be found since the temp tables will have all records of pt_mstr...
  2. R

    domain comparision

    oops:( replace DISPLAY "Domain Total ------->" @ in_qty_oh by DISPLAY "Domain Total ------->" @ in_domain. also add an end.
  3. R

    domain comparision

    your required code might be something like this: FOR EACH in_mstr WHERE <<selection criteria>> BREAK BY in_domain BY in_site BY in_part: IF FIRST-OF(in_domain) THEN DISPLAY in_domain in_site. DISPLAY in_part in_qty_oh. ACCUMULATE in_qty_oh(TOTAL BY in_domain). IF LAST-OF(in_domain) THEN...
  4. R

    Select working database

    Thanx once again for your reply. found the alias one useful as i am taking the database name in a variable
  5. R

    Select working database

    Is there a way to select any working database using a query, and not via the data dictionary? (the database is already connected)
  6. R

    Displaying fields in Table

    GR8. Thanks a lot
  7. R

    Displaying fields in Table

    Is there a way or a query to display the fields of a table like in the data dictionary. My purpose itself is to create something like a data dictionary which will allow the users to select fields from the desired tables.
  8. R

    MFG/PRO newbe

    Hi to all, just started my career in mfg/pro. hoping to gain a lot from here!
  9. R

    Sales Order Delete

    In sales order maintenance 7.1.1 goto the third frame of the order you want to delete (order date starts here) and then press ctrl-d to delete the entire sales order.
Top