|Subject:||Re: Run query locally
|Date:||Sun, 16 Feb 2020 17:50:45 +0100
|From:||Anders Jonsson <andersREMOVETHIS@jonssondata.se>
I'm not 100% sure I understand what you are trying to do, but if you
just need to have paradox installed on one PC and the tables on another
PC (or server) - that is pretty much standard and should be no major
problem. If the tables on the server are being shared with other users,
you just need to make sure that everyone is using the same NET-file.
The setting for queries running localy or remotley is only valid for
SQL-servers. As long as you hav Paradox tables it shouldn't be needed.
FWIW my setting seems to be "Query may be local or remote".
As to the istable and findfirst giving different results for full
version compared to rutime, I have no idea. I will see if I can verify
that (but I'm using P10).
One thing - I suggest you don't refer to the tables by drive-letter. You
could find yourself in a situation where you can't control the drive
letter and must change it. It could be a nightmare if you are using it
all over your application!
It's much better to defin an alias. Then you only need to change in ONE
place. I define my aliasis in a startup-script for the application which
makes it very easy to maintain (I combine that with an old fashion
ini-file so it is very easy to change even without access to Paradox).