Delphi, Paradox, Database Desktop and relational databases..

[mjsof84]

Hi all.

I'm designing a simple database application which requires 4 relational tables. I was planning to create the tables in Paradox with Database Desktop and then use them in Delphi with a mixture of TTable and TQuery (and creating an Alias, obviously). Got as far as creating all the tables..

However, hit a bit of a stumbing block in Database Desktop when I couldn't find how to relate the tables. Perhaps this is just me being dumb, but assuming it is possible - how do you do it?

Or will I have to use Access instead?

TIA.

 

[BTecho]

Hi there.

You can use Access if you like but you can do the same with Paradox.

How to use the Database Form Wizard,

http://delphi.about.com/library/weekly/aa022399.htm

 

[mjsof84]

thanks a lot.

i'll have a go with that tutorial now..

 

[svanels]

With the database desktop you can define your referential integrity of a table in the table properties field. Also look-up tables can be defined thus placing the bussiness rules of your application on the Database Engine. Steven van Els
SAvanEls@cq-link.sr

 

[mjsof84]

thanks for the help.

i've now defined my referential integrity in DBD and it is working fine.

 

[LucieLastic]

You may want to look at adding unique Constraints so you don't end up with duplicate records in one table. Also, indexes are useful and speed up retrieval.

 

[mjsof84]

yeah, i've set up unique keys in each of the tables.

 

[LucieLastic]

...you can still put an index on these too if you want, which (I think) is common practice on unique fields.