<div>
try to establish a master-child relation<br />
in delphi (properties mastersource,masterfield of the dataset).<br />
<br />
otherwise you have to relocate the form2-data<br />
in the afterscroll-event of the dataset on form1<br />
<br />
meikl ;-)<br />

</div>


try to establish a master-child relation
in delphi (properties mastersource,masterfield of the dataset).

otherwise you have to relocate the form2-data
in the afterscroll-event of the dataset on form1

meikl ;-)


<div>
query1.requestlive := true;
</div>


<div>
No sorry.. I meant query1.AutoRefresh := true;<br />
It's a property in the Object Inspector<br />
<br />
From delphi help:<br />
&quot;When AutoRefresh is true, field values are automatically refreshed without an explicit call to the Refresh method.&quot;<br />
<br />
I hope it helps<br />
<br />
Gummi St.
</div>


No sorry.. I meant query1.AutoRefresh := true;
It's a property in the Object Inspector

From delphi help:
"When AutoRefresh is true, field values are automatically refreshed without an explicit call to the Refresh method."

I hope it helps

Gummi St.

<div>
I am using an ADO connection will this still work?
</div>


I am using an ADO connection will this still work?

<div>
it says insufficient base table information
</div>


it says insufficient base table information

<div>
<div class="content wysiwyg-content">
at the moment, I have a screen that then moves to one of two forms. &nbsp;The problem I have is that when I view the form, go out and select another record and go back in, the displayed data is still the data from the previous record.<br />
<br />
I need somehow to refresh the data without clearing the SQL or the query because that looses all the SQL which specifies the records to find. &nbsp;
</div>
</div>


at the moment, I have a screen that then moves to one of two forms.  The problem I have is that when I view the form, go out and select another record and go back in, the displayed data is still the data from the previous record.

I need somehow to refresh the data without clearing the SQL or the query because that looses all the SQL which specifies the records to find.  

Refreshing data

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.