Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Persistent, occasional error loading a view
Hi Y'all,
About once a week someone gets an error opening a form and it seems to be when loading one of the views. I just tell them to try again and it pretty well always loads. But they would like this fixed. Here is the error:
"Error loading file - record number 16. PARTFILE .Loading form or the data environment : Database object is being used by someone else"
Happens on a few forms so not specific to one. I load my views via the data environment with usually "NoDataOnLoad" set to .T. so I get something like this for error code something like this:
SELECT Plaintif.firstname, Plaintif.lastname, Plaintif.birthdate,
Plaintif.gender FROM plaintif WHERE 1=0 ORDER BY Plaintif.lastname,
Plaintif.firstname into cursor Viewcalv16
Couple of questions:
1) is the above solvable or is using the data environment just not robust enough on a network
2) if it's not good enough, has anyone developed a routine that would allow me to use the data environment for development but then it auto-switches to code to open the view? I was thinking that it might be possible to do something like this:
a) pull the views into the DE
b) set AutoOpenTables to .f. in the DE
c) put the code in the Load method to open the form again as read-only and scan for the view records and fire them from there
Albert
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement