• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

TQuery, TDbGrid, SQLServer and Live Result set

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.
0
boardtc
Asked:
boardtc
  • 2
  • 2
1 Solution
 
kretzschmarCommented:
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
0
 
boardtcAuthor Commented:
Meikl, I'll look into it here, thnak you. My emial if you get a chance is tomcorcoran@email.com

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

Tom.
0
 
kretzschmarCommented:
hi tom,

well, just sent you the res-file and
a little descripion, how let the ide create the
the statements for the UpdateSQL

glad that you get it work
good luck again

meikl ;-)
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now