?
Solved

Master/Detail with ADO and SQLServer 2000 ?

Posted on 2003-03-11
2
Medium Priority
?
448 Views
Last Modified: 2010-04-04
Hello all,

I'm just starting to develop a program with ADO and SQLServer 2000. I'm new with ADO and I need your advice. I run Delphi 6 professionnel on win2000 pro and MSQLServer 2000 on win2000 server.

My table structure is quite simple : I have 3 master table (policies, covers and clients).

1 policy can have 5 different clients (Assignee, recipient, club, owner, payer, etc)

1 policy can have unlimited covers and all covers can have 1 client (the insered).

My problem is when I put all these ADOtables in master/detail relationship, the application become very slow. With paradox, there is no problem, but I know that SQLServer does'nt like full table work. I know that I could use query with joins, but I have problem to display the information.

So, what choice do I have ?

BTW, I would like to buy some books on ADO and Delphi. Do you have any suggestion ??

Thanks in advance for your comment.
Oteau
0
Comment
Question by:oteau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
bogiboy earned 750 total points
ID: 8113098
I had the same problem. My additional problem with Master_Details was unabillity to sort in grids (sorting set IndexFieldNames to the currently sorted-clicked-column).

Here is what I did after that, and it works OK;

For Master table write MyTableAfterScroll event like this:
Go to master table properties and in Events tab select OnAfterScroll event.

procedure TForm1.MyMasterAfterScroll(DataSet:TDataSet);
var
sMasterKey:string;
begin
sMasterKey:=MyTable.FieldByName('Record_id').AsString;
myChildTable.Filter:='MasterForeignKey='+sMasterKey;
myChildTable.Filtered:=True;
//filter other detail datasets if you want
end;

instead of using Table I use TADODataSet;
0
 

Author Comment

by:oteau
ID: 8388643
Thanks for your help.

I'm going to introduced a new method for my user. I know that it's not common that they will need all the policies, covers and insured. So, I'm using Stored procedure to retreive only the record they need to work on. It's simplify coding and it really improuved speed.

Thanks again.
Oteau
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question