<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi Leonardo,<br><br>> Date: Sat, 16 Apr 2011 18:39:05 -0300<br>> From: l.rame@griensu.com<br>> To: lazarus@lists.lazarus.freepascal.org<br>> Subject: Re: [Lazarus] Master/Detail Relation<br>> <br>> On 2011-04-16 15:56:19 -0300, Leonardo M. Ramé wrote:<br>> > Hi, I was looking at SqlDb components and I can't find any property to<br>> > link two datasets in a Master/Detail relation, as in Delphi.<br>> > <br>> > Is such feature already implemented? any tutorial/wiki?.<br>> > <br>> > Thanks in advance,<br>> > -- <br>> <br>> I found the solution. <br>> <br>> For the record:<br>> <br>> SqlQuery1 (master)<br>> SqlQuery2 (detail)<br>> <br>> In SqlQuery2.Sql.Text I had to add a "where" condition with a param, for<br>> example:<br>> <br>> select * from a_table where a_field = :field_from_query1<br>> <br>> The param must be a Field from SqlQuery1.<br>> <br>> Then, by code, i had to the param type:<br>> <br>> SQLQuery2.ParamByName('field_from_query1').DataType := ftInteger; <br>> <br>> The last step is to point SqlQuery2.DataSource to a TDataSource<br>> associated to SqlQuery1. In my case I have two TDbGrids in form1, each<br>> grid with a TDataset pointed to SqlQuery1 and SqlQuery2, so in<br>> SqlQuery2.DataSource I assigned "form1.datasource1", and that's it.<br>> <div><br></div><div>I would like to see your solution. I am wondering if you could please make a demo Lazarus project and zip it up and upload it to http://hotfile.com . It is a file sharing website and then I will be able to see your code.</div><div><br></div><div>Thanks in advance.</div><div><br></div><div>Best Regards,</div><div>Peter / pew</div><div><br>> -- <br>> Leonardo M. Ramé<br>> http://leonardorame.blogspot.com<br>> <br>> --<br>> _______________________________________________<br>> Lazarus mailing list<br>> Lazarus@lists.lazarus.freepascal.org<br>> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus<br></div> </body>
</html>