Paradox Automation

[mwoch]

Hi Everybody,
I am looking for a documentation of Paradox Automation Server. Enybody can help me?

Regards
Marcin

 

[Mike Lewis]

Marcin,

Didn't know Paradox had an automation server. You might do better by asking in a Paradox-related forum. We're all VFP folk here.

I have used ODBC with Paradox if that's any help.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[mwoch]

I want to get an access to Paradox tables (ver. 8.0) from external system. My system does not support ODBC, so the only way may be OLE Automation or OCX. I have found a component PdoxAuto 8.0, but I do not know how to use it.

Regards
Marcin

 

[Mike Lewis]

Marcin,

You say your system doesn't support ODBC. That's surprising. All versions of Windows support ODBC, as do all versions of VFP. Is there something unusual in your system that doesn't support it?

As for PdoxAuto, if you don't have a Help file for it, you can try opening it in the object browser. That'll give you a guide to its properties and methods. Or use Intellisense to get the same info.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[wgcs]

I don't have paradox, so I can't test any of these, but it looks like there might be an automation server that you can access by:
loX = CREATEOBJECT("Paradox.application")

Then see if you can use intellisense (or the object browser) to learn more about "loX"

Here's the page I found the "Paradox.application" reference on:

http://www.prestwood.com/community/paradox/info/dde_ole.html

It also describes using DDE to manipulate Paradox. Even though the page is geared toward Delphi, VFP includes all the DDE functionality. Lookup "DDE Functions" in the VFP help to find DDEInitiate, DDEPoke, DDERequest, etc. It's not very hard to use.

Here's a more difficult method based on windows messages:
(The original page at

http://www.techtricks.com/paradox/ctrlmsgs.php

seems to be gone... this is a link to the google cache:

http://64.233.179.104/search?q=cach...radox+"ole+automation"&hl=en&client=firefox-a

)

- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[mwoch]

Thank you everybody for your help. A friend of mine sent me a link to OCX that allows me for this. Thank you again.

Marcin

 

[wgcs]

If the OCX is publicly available, you may want to post a link here for future readers....

- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[mwoch]

I think it is not a problem:

http://www.brothersoft.com/Software_Developer_Active_X_Paradox_Direct_Engine_ActiveX_33631.html

But I cannot say anything about it because I have not tested it, yet.

Best Regards
Marcin