SQL Query process. 1

[PANTLORD]

Hi there,

Just interested to know what the best process is when dealing with SQL for ensuring that on exiting a form or procedure that everything which needs to be closed off actually is.

For instance I have a form with TQuery, Tdatasource & TTable components (1 of each). On executing an SQL statement when I am finished with it I have been simply closing the TQuery component, the same for when I exit my program do I need to do anything else?

Thanks
PL

 

[TealWren]

If you are using sql components as visual components on your form, they will be closed and freed when your form is freed - so you should be ok.

TealWren

 

[PANTLORD]

Thanks for that still getting used to SQL in Delphi too much ACCESS2K behind me!