Les Brinkworth - 2004-12-08

This is a problem that I fought long and hard with and from some of the other posts I see I was not the only one.  Having found a solution to the problem I thought I would share my solution.

The cause of the freeze is that the mODBC Query component will not free. 

What I have discovered is the following:
You cannot free the components in the datamodule from the "finalization" section of your code.  You must do this from within the implementation section somewhere.  I have done this at the end of the PalmComponent Execute Procedure.
Secondly and perhaps more importantly is that the mODBC Query component does not free itself if, 1. RequestLive is True.  And/Or you use the statement "Query.Close", you must use "Query.Active := False".

This must be done for each query component in the datamodule and then the "DataModule.Free" will not hang the conduit.

Hope this helps to alleviate someone's frustrations!

Les (in South Africa)