Paradox Community

Items in pnews.paradox-development

Subject:Re: Run query locally
Date:Thu, 20 Feb 2020 21:07:23 +0100
From:"Ivan" <>

"Steven Green" <> schrieb im Newsbeitrag 
> sorry, but your description does not make sense.. it doesn't matter what 
> OS is controlling that other drive, your copy of paradox knows what the 
> files are, and what files it needs
> example.. my laptop and an external drive.. paradox is on my laptop, and 
> when the external is plugged in it is drive E.. that is all paradox needs 
> to know, to operate correctly

and is on the external pc paradox installed or not? if yes, i agree, if not, 
i don't know, what software makes remotely the query and sends just the 
result from remote pc to you (if it should be done remotely).

have you tested it e.g. with linux pc without any database sw on it? and 
then you send the question to the remote pc, if isTable( ..myTable.db.. ) is 
a table? i think, the answer will be NO. but fs.findFirst(..myTable.db ..) 
will be YES, because for the remote pc it's just a file. therefore you can't 
e.g. get as query-answer only a piece of data, which you need from the 
remote pc, which is a "plain" pc with a lot of data-files.

i only want to understand it, because i've tested it with win 7, 10, vista, 
... and it will not work. if you say, it works, ok i'll try different 
settings (as usual) on the win-pc's.


> Steven Green
> Myrtle Beach, South Carolina, USA
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Ivan"  wrote in message news:5e4ed52e$
> hi anders,
>> 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.
> of course its not a problem, if you have on both windows and pdox 
> installed.
> the problem is, that on the pc with tables there's no windows and no p9r
> installed. therefore each file is a file and if i want a table, linux (or
> whatever) don't know, that myTable.db is a pdox table. and it don't know
> anything about .NET file.
> and he has not a network. he ist the only one user, but want to have only
> the data on an another pc protected. the app itself should be on his pc.
> i said him, that his wish is a nonsense. but he has somebody froum
> university (or such thing), who said, that the new laws in EU to protect
> data would be very good fulfilled with such a solution.
> i've talked to other users (which have my installations and had controls 
> by
> authorities) and they said, that it's enough to use passwords to fulfill 
> the
> law (that not everybody can start the app) - and some tables with critical
> data should be encrypted (and this is the case).
> i told him that out of fear of unauthorized access to his data, he would
> destroy it even with such a configuration.
> he is now on vacation and will be back in early march ...
>> 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".
> this works only if on both pc's p9r is installed. or i've done something
> wrong.
>> 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!
> as long windows don't kill the drive letters, i think that i can handle 
> it.
> the unc adresses ( \\server\somewhere\dir ) works for nearly everything, 
> but
> there are some places where i can't use it. therefore i stay with drive
> letters.
>> It's much better to defin an alias. Then you only need to change in ONE
> i have many (about 20-30) of aliases created on start within an
> init-section - so i can save the data, pictures, backups, ... wherever i
> want (within network too for all users).
> this is not the problem.
> and i tested the above problem and want to solve it with aliases. but it
> works only with p9r installed on both pc's. this seems to be the problem 
> (if
> p9r is only on one pc) - then you can't use "Query may be local or 
> remote",
> because the remote pc dont't work as you expect.
> If you have just "Run query locally" access, then the file if first copied
> to the local pc (where p9r exists), and on the local pc it's recognized as
> table ... but such a solution is a nightmare with huge tables ...
> ... just my opinion.
> Grüezi
> Ivan

Copyright © 2004