🚀 go-pugleaf

patrick martin <patrickmmartin@freenet.co.uk> wrote:

>E.g. for the Access ODBC driver, I found TTable would often hang
>completely getting the fields in a table.
>TQuery could do this with a "select * from [Table1]" and was not
>noticeably slower with no loss in functionality.

I've got a really weird problem with TQuery.  I had a working program
which used TTables, and was a bit slow.  So I put a TQuery in place of
the slowest table.  Sure enough, that sped it up a bunch.

But now the program doesn't work.  I cannot get a DBEdit control to
save it's contents back to the database.  Nor can I get any other
data-aware control to work.  I found and corrected a number of errors,
but I haven't found the magic words.

Yes, I have "RequestLive==true".  I tried putting an implicit
StartTransaction on the opening of the form, and a button to Commit.
No joy.  I thought that a TQuery could be used roughly the same way as
a TTable wrt data-aware components.

Could somebody send me a clue?

Spam Me and Get Sued <harkness@suespammers.org>
see www.suespammers.org for details & free spam-nuking email account