Alpha Video Training
Results 1 to 3 of 3

Thread: <tbl>.Append() and Sorting records

  1. #1
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default <tbl>.Append() and Sorting records

    What I am wanting to do is when I take records from transaction table and append in the master table I want to add them into the master table in a certain order. I know I can filter after but I was hoping I could get them entered in the order I want. I can not see that I can do this. Anyone has an idea how?

  2. #2
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: <tbl>.Append() and Sorting records

    Just on top of my head:
    1-First copy those records in the desired order
    2-Then append from the new table.
    You could automate this with xbasic

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: <tbl>.Append() and Sorting records

    Quote Originally Posted by turbojack View Post
    What I am wanting to do is when I take records from transaction table and append in the master table I want to add them into the master table in a certain order. I know I can filter after but I was hoping I could get them entered in the order I want. I can not see that I can do this. Anyone has an idea how?
    You may have a valid reason for wanting to do this but since the currently applied index or query controls the display or processing order, what difference does the physical order make?

    You could copy the records from the transaction table to a temporary table, in the order you desire, and then append from that table.

Similar Threads

  1. Append Filter to append records that are different.
    By CowPoet in forum Alpha Five Version 7
    Replies: 2
    Last Post: 12-10-2006, 10:43 AM
  2. Sorting Records
    By George Smyth in forum Alpha Five Version 6
    Replies: 6
    Last Post: 12-15-2004, 03:38 AM
  3. Sorting records in Reports
    By Stephen F Zaborsky in forum Alpha Five Version 6
    Replies: 2
    Last Post: 12-14-2004, 11:14 AM
  4. Sorting Records
    By Rhea Vaughan in forum Alpha Five Version 5
    Replies: 7
    Last Post: 11-18-2002, 12:01 PM
  5. Sorting Records on Subform
    By Jeff Klages in forum Alpha Five Version 4
    Replies: 7
    Last Post: 07-22-2002, 09:10 PM

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
  •