5 replies to this topic

[KuonThe_Newbie_Programmer]

Uhum.... I just start using Delphi7 and i want to make some program that have a database relationship, and this is where the problem is coming up ..... i can create a simple database but how can i RELATIONSHIP THEM ? I hope the Professional programmer here can help me with this simple things , thank you :) and i really appreciate it

[WingedPanther]

Can you clarify what you're trying to do?

[KuonThe_Newbie_Programmer]

i want to making relationship to other database so it can connect with each other like relationship on microsoft access

[WingedPanther]

Again, this is not clear.

If you are using SQL Server, you can do cross-database queries by doing things like:

select * from db1.owner1.table1 join db2.owner2.table2 on (whatever fields)

Oracle has a similar concept, but you would specify the schema instead of the database/owner pair.

For file-based databases, such as sybase, it's just a matter of having the proper ODBC connections defined in a meaningful way.

For some databases, like Firebird, it really may depend on how you're connecting to the database as to whether this is even possible.

More importantly, however, is whether you want to establish relationships between multiple databases, or just between tables within a database. Again the details will depend on the database type.

With all that in mind, what, exactly, are you trying to do? What databases are involved? What tables are involved? What RDMS systems are you using? How are you connecting to them? etc, etc, etc.

[KuonThe_Newbie_Programmer]

Quote

connecting to the database as to whether this is even possible.

I mean this i want to make the relation with paradox 7

[WingedPanther]

I would strongly suggest you use something other than Paradox. It is not an RDBMS, and is quite limited.