Re: Working with Paradox 8 via DDE

#1

Neither. You're better off connecting to the database (tables) directly
rather than trying to go through Paradox the application to do it.

What application did you want to use to control Paradox?

Liz

Ike wrote:

Quote:

I am a newbie when it comes to working with Paradox DDE. Is there a
DDE reference guide for sending commands to Paradox that shows the
proper syntax? I want to be able to send commands to Paradox to search
for matching fields, extract entire records, create a new Paradox
database, add new records, etc. Google does not turn up anything
useful.

Or, is this something that is better accomplished via OLE?

#2

Ike wrote:

Quote:

I am a newbie when it comes to working with Paradox DDE. Is there a
DDE reference guide for sending commands to Paradox that shows the
proper syntax? I want to be able to send commands to Paradox to search
for matching fields, extract entire records, create a new Paradox
database, add new records, etc. Google does not turn up anything
useful.

Or, is this something that is better accomplished via OLE?

Without the slightest doubt ... don't use DDE. Use OLE. The OLE mechanism
works extremely well, and DDE frankly never did.

Furthermore: if you need to access the database files directly, the ODBC
driver _that_ _ships_ _with_ _Paradox_ ( *not* the one that ships by
default with Microsoft Access! ) works extremely well.

It has been my experience that the ODBC driver might not work as expected
when Paradox for Windows is running at the same time on the same machine,
but this is rarely a problem.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com

#3

Quote:

Thanks for the tips. Can anyone point me to a good tutorial on OLE
that a beginner can cut his teeth on?

See the Paradox HELP files; ole server I think, or something like it. Maybe
oleautomation.

---------------------------------------------------------
Tony McGuire

#4

Quote:

Ike wrote:
Thanks for the tips. Can anyone point me to a good tutorial on OLE
that a beginner can cut his teeth on?

The Paradox help system includes a reference of the Paradox OLE-object.
Most of the stuff is self-explanatory.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com

#5

Sorry about leaping in this way, but I can't get my service to let me post
an original message. Don't know why.

Whenever I boot my computer and start Pdox11 I get a Welcome screen which I
tell it I don't want. I also get developer preferences set to Beginner and
I reset it to advanced. In addition, if I create an alias in a session, it
only lasts as long as the session no matter what I save or how I do it
unless I create it directly using BDE (I've been writing in Pdox for 15 or
so years, so I know how to save it correctly within Paradox). As long as I
don't reboot, it holds the settings, but once I reboot it's back to square
one. Any thoughts?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Working with Paradox 8 via DDE

comp.databases.paradox comp.databases.paradox

Re: Working with Paradox 8 via DDE - 12-01-2006 , 04:55 PM

Re: Working with Paradox 8 via DDE - 12-01-2006 , 05:35 PM

Re: Working with Paradox 8 via DDE - 12-04-2006 , 06:38 PM

Re: Working with Paradox 8 via DDE - 12-05-2006 , 04:43 PM

Pdox11 Startup - 01-31-2007 , 10:36 PM