>I am wondering if using the dataenviroment is worth all the trouble it introduces. I have experimented with using the data enviroment and have found that the Drive and path are stored in the .scx. This causes problem's for me.
>
>If the application is sharing data on the network, you must map a drive to your network. This means that all testing will be done with data on the network vrs on your hard drive. SLOW SLOW SLOW
>
>I would like to hear if anyone has any tips or suggestions concerning using the data enviroment in forms.
>
>Thanks
>
>Steven Summers
>:>
Answer:
<<
>>
You can acces cursors in DE.BeforeOpenTables method and change this property
(SomePublicObject.AplyRelativePaths(this)) for each cursor accordingly and they will open exactly path you specified with NO EXEPTION - as long as you keep DBC container and it's tables in the same directory.
This way you can test your forms by having developing time database at your local machine and all forms.DE pointing to it, and deploy freely on the network
any place (machine) you want.
Now this seems so easy up to now, but you have to build an object by object scanning method as well (e.g. AplyRelativePaths(DE) ) and 'attack' cursors
in right time e.g in DE.BeforeOpenTables method, BEFORE they get executed by DE.OpenTables and change their 'database' property.
As soon as I have some time free I will make an article in knowledge base at this forum in FAQ section and give some more interesting details on this subject.
I hope this will be enough for you to resolve your problems.
Regards from Cyprus.
