I have used Paradox for about 10 years and here is why I choose it over any
other desktop database application, specifically Access:
1. The programming language, ObjectPal vs a subset of Visual Basic, has
always been more robust. (1500 commands vs 500, previous versions).
2. Distribution- With less than $1000 worth of software (Paradox Developer
and Runtime) I can write applications and distribute them to every desktop
in the company without having to put a licensed copy of the full blown
developer edition where users can get into trouble.
3. I recently read a thread about having to write code to delete and
recreate table indexes if the Access table grows to more than 100 to 120
thousand records. Paradox maintains its' indexes and the number of records
is basically limited to the amount of available disk space. I have seen an
application developed in another part of my company that has two tables
(the application contains many tables, these are the two used in the part I
saw), one with 180,000 records the other with over 300,000 records that is
blazingly fast. It is a testament to what a great tool should do when used
in conjunction with good, common sense programming.
4. I would not go to a horse farm to buy a new car, why should I go to an
operating system company to buy a database?
5. Query by Example (QBE) is extremely easy to use and I believe more
capable than SQL.
I have not had to answer the question you are asking for a long time and
admit that the times and applications have changed, but believe that my
opinions are still reasonably valid.
> To Anyone with Information
> I am looking for information on paradox 5.0. I need to know about its
> limitations and strengths regarding the setup of tables, queries and
> reports. Where does the program run into trouble? What makes it better
> than other database software Programs