path-trouble in network app

[Nifrabar]

Hi!
I am trying to create my first multi-user app.
The database will be stored on a networklocation like:
\\PCbart\d\data\
I am using the code given by '1001 things chapter 10' to alter location of the cursors which are stored in the DE.
Up to now that all works smooth.
But....
As I run the app than, after the DE has got the new data of the network-locations for the cursors, the app complains that it cannot find my 'c:\appName\data\my.dbc'.

I can't understand why the app is looking overthere.
I went through the form (openened as table) to check for any reference to 'c:\appName\data\my.dbc' but no found!

Any idea?
Will the '1001-code' still work in VFP9?

Any suggestions are very, very welcome!!!

-Bart

 

[SnyAc]

You will need to map the network drive on the workstation computers. Also in your app SET DEFAULT to the mapped driver. I use a string substitution so you can store the path in an INI file on the local workstation...

cPath="N:\MYDATA"
set default to (cPath)


Andy Snyder
SnyAc Software Services

http://www.snysoft.com

 

[Nifrabar]

Andy,
Thanks for your reply.
In fact the path-setting in the DE is done programmaticly.
So once a table should be opened using the DE the full path is there available.
The (strange?) thing is that nevertheless that the fullpath is there the APP still complains for the DBC which according the APP shoul dbe in th emap from where the APP has been started.
-Bart

 

[SnyAc]

wish I could tell you more, but I don't use data environments... I'm an old school hard programmer.

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

 

[Nifrabar]

Andy,
Following the code as described in 1001 things does give you some advantages over opening tables in the form's load method.

My problem has been solved . I did overlook the need to give a database also it's extension DBC in the lookup-table.

-Bart

 

[SnyAc]

I don't usually open tables till they're actually needed....

May not be until the activate method...

And then I typically close all the open tables after the form has been activated and displayed... I like to be sure that there are no hanging network buffering issues when dealing with time sensitive transactional databases.

Andy Snyder
SnyAc Software Services

http://www.snysoft.com