Alpha Video Training
Results 1 to 2 of 2

Thread: Appending Records

  1. #1
    Scott Rusoff

    Default Appending Records


    I have created a routine to append records to my Alpha 5 database.

    In my criteria, I have selected a date to chose the records to append, I also need limit the records that get appended.

    There are two fields in the database that I append records from they are the Sold to field and the Ship to Field.

    If the values in both fields are the same, I do not want to append these records, how do I add this to my criteria.

    In a nutshell, I want the user to be promted with a date to chose the orders they want to append, and the system to know not to bring in records where the ship to and sold to fields are the same.


  2. #2
    "Certified" Alphaholic
    Real Name
    Russ Boehle
    Join Date
    Mar 2000

    Default RE: Appending Records

    The append Genie allows you to define record selection criteria. Run through the Genie and you will see this.
    Something on the order of .not.(shipto=soldto) might work but I don't know your context. In any case the genie should give you sufficient options.


Similar Threads

  1. Appending records
    By Jesse Sanders in forum Web Application Server v6
    Replies: 2
    Last Post: 05-03-2005, 04:57 AM
  2. Appending Records
    By kumargroup in forum Alpha Five Version 5
    Replies: 0
    Last Post: 07-10-2003, 09:20 AM
  3. Appending Records
    By Jules Klapper in forum Alpha Five Version 1
    Replies: 1
    Last Post: 03-13-2003, 11:09 AM
  4. Appending records
    By Jim Stermer in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-07-2003, 10:58 AM
  5. appending records from set to set
    By Todd Warren in forum Alpha Five Version 4
    Replies: 3
    Last Post: 08-16-2000, 05:18 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts