Results 1 to 3 of 3

Thread: AXP & Locking

  1. #1
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Unanswered: AXP & Locking

    I have an app which i am migrating from A97 to AXP. This app does a lot off checks and takes an hour to process.

    So i created "shadow" applications that work together with the main app to reduce processing time.
    1) main app start at the top and runs down.... to the end
    2) Shadow 2 starts in the middle works up
    3) Shadow 3 starts in the middle and works down
    4) Shadow 4 starts at the bottom and works up

    1) gets the recordset "Order by UID" ---> UID = Autonumber
    2) gets the recordset "Order by UID Desc"
    then moves to rst.recordcount /2
    Using a dummy recordset moved 15 records ahead the make sure I dont get into the first batch...
    Once this dummy recordset has found a processed record this 2nd shadow kills itself.
    3) Gets the recordset "Order by UID"
    does the same as 2
    4) Gets the recordset "Order by UID Desc"
    Does the same as 2 but starts from record 1

    It should not happen that 2 shadows are working on the same record, but i am getting the error:
    Runtime error 3218:
    Could not update; Currently locked

    I double checked all 4 databases set in "Record locking", so why would it be throwing this error?

    Greetz

    The Mailman

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Isnt there anybody out there who has any thoughts on this matter?

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Further attempt

    I have trimmed the DAO recordset to the bear essentials (4 fields) and changed all to start from bottom up..

    1) Top down
    2) Stil starts middle up
    3) 3/4 up
    4) Bottom up

    Since we are talking multi thousand records (5000 +) each run, there are at least 1250 records between each process, but still i get this same error...

    Please anybody have any new ideas?

    Greetz

Posting Permissions

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