Struggling hard since a month to find out how to write SQL for Paradox
8

No good documentation is there, Even the Help files wiht PDX8 for
WIndows are silent.

Internet is talking a lot about it but hard to find any excellent
source of teach by example lessons

Now I realize the great difference between Microsoft and Others.

I am conversant with MS Access and regularly use PDX from MS Access , I
got troubles when I tried to access PDX tables with INTERSOLV drivers
for *.db in PHP Scripts for my website!

THere should have been something that compares the two SQL formats side
by side like one thing I know is

To fileter a SELECT query on a date field
MS Access: [DATE FIELD]=#yyyy-mm-dd#
Paradox:"DATE FIELD"={d 'yyyy-mm-dd'}

See the difference?

I want all such differences in a single article, before I have to
author one!

Any help, hint and link would be deeply appreciated!

Look in the BDE install directory for LocalSQL.hlp

Liz


sarjanwebdev (AT) gmail (DOT) com wrote: