>>>>>>>>>>>I have a form with a listbox but when run from the exe on the network , >o you use the same data (dbc,dbfs) running locally and on network?
>>>
>>>here's something interesting. The form has a dataenvironment and the cursorsource is set to the residence on the local drive. should this make a difference. The same bad results occurred when I copied the form to the r:drive and tried to execute it. So this seems to be more at where the problem lies, not the exe.
>>
>>You hit the basic network DE issue. The idea is to reset Database/Cursorsource properties programmatically in DE.BeforeOpenTables event. However, don't try to copy separate forms to server, etc., it's better to move step by step, i.e. compile exe/app and run it, btw normal VFP installation assumes exe located locally and data on server.
>
>Actually you hit upon it just prior when you mentioned having 2 copies of the data. There was an old copy on the R:drive so I deleted it. And now it works. I did NOT know that An App looks for data on the drive it was executed from
>even though the work directory is the curdir(). I posted this in essence a few minutes ago. I guess I'll have to be careful to avoid this in Future.
Restating one suggestion Ed gave you, you should specify in your DE.BeforeOpenTables the source of your cursors and views. For example:
THIS.Cursor1.Database="\DATA\TRAINING\TRAINING.DBC"
HTH
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.