Alpha Video Training
Results 1 to 2 of 2

Thread: Appending Records

  1. #1
    Scott Rusoff
    Guest

    Default Appending Records

    Hello,

    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.

    Thanks,
    Scott

  2. #2
    "Certified" Alphaholic
    Real Name
    Russ Boehle
    Join Date
    Mar 2000
    Location
    Connecticut
    Posts
    2,767

    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.

    Russ

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

Bookmarks

Posting Permissions

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