<div>
hi tom,<br />
<br />
an order by clause causes that the query becomes readonly, you need a TUpdateSQL-Component as UpdateObject for the query to make it editable, but this works only with cachedupdates.<br />
<br />
if you leave your email here, then i can send you a sample<br />
<br />
meikl
</div>


hi tom,

an order by clause causes that the query becomes readonly, you need a TUpdateSQL-Component as UpdateObject for the query to make it editable, but this works only with cachedupdates.

if you leave your email here, then i can send you a sample

meikl

<div>
Meikl, I'll look into it here, thnak you. My emial if you get a chance is tomcorcoran@email.com<br />
<br />
Cheers, Tom.
</div>


Meikl, I'll look into it here, thnak you. My emial if you get a chance is tomcorcoran@email.com

Cheers, Tom.

<div>
Miekl, that worked well. Setting the InsertSQL and other stringlists is a little cumbersome but it works fine. Please answer to grade.<br />
<br />
Tom.
</div>


Miekl, that worked well. Setting the InsertSQL and other stringlists is a little cumbersome but it works fine. Please answer to grade.

Tom.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am hooking a table to an SQL Server table, in order to gaurenteee the correct order is displayed I need to link a Query (do an Order By) to the grid as opposed to a TTable. Howevere, i also need a live result set. When I set RequestLife to True and run the query I get an error message saying Invalid fiedl name (it runs fine if RequestLive is False). Any ideas how I might achieve what I need?<br />
<br />
Thanks, Tom.
</div>
</div>


Hi,

I am hooking a table to an SQL Server table, in order to gaurenteee the correct order is displayed I need to link a Query (do an Order By) to the grid as opposed to a TTable. Howevere, i also need a live result set. When I set RequestLife to True and run the query I get an error message saying Invalid fiedl name (it runs fine if RequestLive is False). Any ideas how I might achieve what I need?

Thanks, Tom.

TQuery, TDbGrid, SQLServer and Live Result set

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.