Alpha Video Training
Results 1 to 2 of 2

Thread: Appending Records from a Transactional Tables to a Master Table

  1. #1
    Member
    Real Name
    Luis E Rodriguez-Galvan
    Join Date
    Oct 2007
    Location
    Monterrey, N.L. Mexico
    Posts
    46

    Default Appending Records from a Transactional Tables to a Master Table

    I have an A5 application where several users are adding information to a transactional table (TT). After finishing capturing data the records will be appended to a master table (MT) and this can be done at the same time with the capturing users.

    I am wondering if I have to lock the MT so the records of the first user can be appended and leave waiting for appending the next users.

    I read that the MT is locked for appending and I would like to know what happen for the other users that select to append the records? Is there any warning to them or A5 send them to wait?

    Please advise what are the functions for locking files or records.

    I used to program in Clipper and we used to lock File & records and send the user to a waiting loop until all was unlocked and then append. This for each user.

    Thanks

    Luis R

  2. #2
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,200

    Default Re: Appending Records from a Transactional Tables to a Master Table

    Luis,
    Something doesn't make sense here, or much explanation is missing in what you are doing. Why would you not have the same conflict with the transaction table with multiple users as you would with the master table with multiple users? Why would you enter records into one table only to append them to another table?

    If you want conflict checks, open the table read-write-exclusive and close it immediately before the append. If can't open table read-write-exclusive, enter a loop with a sleep time and retry for "x" number of iterations before success or an alert the append failed.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

Similar Threads

  1. Append All Tables/Records to Master Automatically?
    By b.black@sunstarusa.com in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 07-31-2014, 01:17 PM
  2. Monthly records appending to existing data tables
    By rrego in forum Alpha Five Version 10 - Desktop Applications
    Replies: 11
    Last Post: 07-07-2014, 03:16 PM
  3. Appending or Copying Records to a Child Table
    By newbee in forum Application Server Version 11 - Web/Browser Applications
    Replies: 5
    Last Post: 09-23-2013, 06:32 PM
  4. Appending filtered records to the same table
    By dealover in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 11-08-2012, 02:16 AM
  5. master table appending and more Q's
    By david dickie in forum Alpha Five Version 4
    Replies: 3
    Last Post: 02-12-2002, 07:51 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
  •