Paradox Community

Items in pnews.paradox-development

Subject:Re: Run query locally
Date:Sun, 16 Feb 2020 14:53:08 -0500
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-development
settings in one instance of paradox have nothing to do with settings in 
another instance, in this regard..

have you looked in the buglist for that kind of istable/findfirst conflict? 
to me, the istable is the important one.. I've seen others use findfirst in 
apps I work on, but I've never found an instance where I *had* to use to use 
it myself

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Ivan"  wrote in message news:5e466154$1@pnews.thedbcommunity.com...

additional information
(perhaps i don't understand something or it's a bug)

e.g. the remote drive with the tables has the letter Y:

each icon has for P9 and P9 runtime (P9R) its own priv-dir (with the same
tables)

as i said:
with P9 open and set
    RunQueryLocally
it works
even P9R works too, as long P9 is open.
if I start P9R alone - it won't work

setDesktopPreference(prefQbeSection, prefSqlRunMode, 1)

sets the value for RunQueryLocally
but it has no effect for P9R, as long P9 is not running. i.e. it
seems, that P9R ignores the set preference value.

i've made a small script:
________

var
    fs    FileSystem
endVar

msgInfo(
    isTable("Y:\\MyApp\\MyTable.DB"),
    fs.findFirst("Y:\\MyApp\\MyTable.DB")
            )

________

with P9 i get the info    True,    True
with P9R                     False,   True

what's wrong? is it a P9R bug?

it changes nothing, if i start the script from Win 7, Win 10, ... or take an
another pc with drive W: ...

any suggestions?

if someone has experiences with such / similar configuration, it would be
nice to hear, that it works somewhere. in this case i will find out, where
the problem ist. otherwise it's senseless to search for something, where is
no solution.

thanks

Ivan

"Ivan" <ivan.moro@web.de> schrieb im Newsbeitrag
news:5e4585c1$1@pnews.thedbcommunity.com...
> hi folks,
>
> With P9 I can set:
>
>    Tools | Settings | Preferences ...
>
> for Queries the choice
>
>    Run query locally
>
>
> How can I set this option for the Paradox Runtime?
>
> Is there an registry-entry?
> Or an another way to do it (script ...)?
>
> An user want to have a special configuration (forms, reports, scripts, ...
> on the "client" pc)
> Tables on another pc within a network (I think Linux but don't know it
> exactly).
> Only on the client P9 is installed.
>
> I've made a test with my network:
> Installed the ap on one PC and the Tables on an another PC within my
> network and get the same error.
>
> If I runt the app with P9 as usual, I get an error "Not initialized or
> accessing network files".
>
> If I set P9 to
>    Run query locally
> it works ok.
> But he has only the runtime installed. How can I set this feature for the
> runtime (if possible with a script)?
>
> Thanks for a hint.
>
> Ivan 


Copyright © 2004 thedbcommunity.com