Re: [DUG]: Flagging invoiced records

[David Brennan]

It's hard to say without more information but if you are processing a lot of invoices in each print run then I would say that running your own prepared update queries for each row you want to update (as suggested by David O'Brien) is probably the fastest way of solving your problem.   Of course that means that you are updating the database directly bypassing MainDataModule.DocketsTable. As a result MainDataModule.DocketsTable will become outdated and need refreshing, probably by closing and re-opening (or using the Refresh method?) when you are finished the print run. The cost of this will somewhat negate the gains you make from running direct update queries but I suspect it would still be a lot faster.   David. DB Solutions. ----- Original Message ----- From: Mark Howard To: Multiple recipients of list delphi Sent: Thursday, October 26, 2000 9:10 AM Subject: Re: [DUG]: Flagging invoiced records Dave Yep, I have a unique composite (3 field) key. I'll try FindKey Thanks Mark ----- Original Message ----- From: David O'Brien To: Multiple recipients of list delphi Sent: Tuesday, October 24, 2000 3:59 PM Subject: RE: [DUG]: Flagging invoiced records If you have a unique field on the table, return that in the query and do a findkey on the table. Or write an update query rather than using a filter.   Dave.