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
|