Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2002, 12:18 AM
ratman ratman is offline
Junior Member
 
Join Date: Jan 2002
Posts: 1
Default Link (master-detail) dbase files with delphi?

I have two dbase files with a common field named 'code'. I want to link them, so when I change record in the first to automatically change record in the second also. Something like the clipper command 'set relation to'.
I know how I can do this with Paradox files but I can not with dbase.
Thanx in advance.
Reply With Quote
  #2  
Old 01-02-2002, 05:28 AM
digitiger digitiger is offline
Senior Member
 
Join Date: Jan 2001
Posts: 716
Default RE: Link (master-detail) dbase files with delphi?

dbase was not a full RDBMS and does not supports the idea of relationships. if you want that to work then you will have to write some codes for that for every event
like update,insert,edit,delete in both the tables to check the other table also or else you will have to use some other database

though if you just want to show the related records togather then ofcourse you can use query component instead of table component and then in select statement you can link any table on any field even if they do not have the same name.


i am not sure it helped but if it is of any use then do click on accept button above
Reply With Quote
  #3  
Old 01-03-2002, 09:44 PM
DarkHorse DarkHorse is offline
Senior Member
 
Join Date: Dec 2000
Posts: 1,636
Default RE: Link (master-detail) dbase files with delphi?

Hi,

You can set the MasterSource and MasterFields for the detail table programatically. Set the MasterSource of the detail table as the MainTable Source and set the MasterFields as the common field. This you have to do in Delphi as DBase is not an RDBMS. This will work out.

Regards
Tomy.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:06 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.