Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File Locking Problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00517658
Message ID:
00517660
Vues:
15
>Dear all,
>
>Do you have same problem in your application? I have an application and run on our LAN environment. I just shared the application directory for user. When User A append a record using APPEND BLANK command, User B also want to append a record at the same time. At that time an message showed on the status bar at User B's computer "Attemping to lock the record, press Esc to cancel". But User A has released/finished the record and repeat the process again, User B still wait to lock the record for a long time. I have already set the "REPROCESS" to 5 seconds. The problem still occurred. Anyone has idea to solve that problem? Thanks a lot!!
>
>Best Regards,
>
>Justy Chow

Justy, check the following :

  • An Unlock was done at user A after Rlock() ?
  • User A didn't use Flock() ?
  • Is MultiLocks Off ?
  • Does the (Novell) server provide for sufficient lock space (per user and global) ? (Set Maximum Record Locks = )
  • if applicable, did user A perform TableUpdate ?

    The above per topic necessarily won't solve the problem, but looking at the combination of things may.
    Anyway, HTH,
  • Précédent
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform