Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error Reading File and Multiple DBC's
So in my never ending search for "Error Reading File" and "Invalid Seek Offset" answers I've got a theory to bounce off everyone.
When we do a SELECT in our application we usually add a Public variable path that points to the current active data for that user on the network.\
qData_Cur = "G:\Ourprogram\OurData\"
SELECT Code1, Desc1 FROM (qData_Cur + "CODES") INTO ....
We do this because at some clients there are multiple data directories. The structure of the directories are identical and only the data contained in them is different. All the Data directories are used identically through the same .exe
So I've noticed that often (although NOT always) if I fail to include the path
SELECT Code1, Desc1 FROM Codes INTO...
we receive the error reading file. Now keep in mind that it doesn't always happen at the same point, nor that this is the only situation where ERF occurs, but do you think the multiple directories would cause a problem? The directories would all be under the root..
G:\OurQpp\Data1
G:\OurApp\Data2
G:\OurApp\Data3
and all run off of the same .exe that is housed locally on the workstations. Maybe something is getting counfused or ....?????
Any thoughts?
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