Page 1 of 1

first close ?

Posted: Tue 19 Sep 2006 19:37
by RH
Just a quick question about calling open for TMyQuery

1. Do I need to call close, brore I set the SQL.text property and open. That is

Close
SQL.text:=text
open

or is there no need for close: Just

SQL.text:=text
open

?

2. Do I need to call First after open, or is Bof automatically set ?

Thanks

:D

Posted: Wed 20 Sep 2006 11:03
by Antaeus
1. There is no need to call Close method before changing SQL property, it is called automatically when SQL property changes.

2. This is not necessary too. After opening for example MyQuery, cursor is positioned on the first record.

Posted: Wed 20 Sep 2006 16:15
by RH
Thats great. thanks :D