| View previous topic :: View next topic |
| Author |
Message |
Dolf van den Berg
Guest
|
 Posted: Mon Jun 26, 2006 8:10 am Post subject: Refresh DB |
 |
|
Is there any other way to refresh the information in a DB using ADO
connection than closing and opening it?
Thanks
Dolf |
|
| Back to top |
|
 |
Guillem
Guest
|
| Posted: Mon Jun 26, 2006 3:49 pm Post subject: Re: Refresh DB |
|
|
Dolf van den Berg wrote:
| Quote: | Is there any other way to refresh the information in a DB using ADO
connection than closing and opening it?
Thanks
Dolf
|
you can use Requery, which is the same as if you would call Close and
then Open. It refreshes the dataset using the original command or SQL
statement. However, using it you won't be able to change those
properties that can only be changed when the dataset is closed.
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam |
|
| Back to top |
|
|
Brian Bushay TeamB
Guest
|
| Posted: Tue Jun 27, 2006 6:11 am Post subject: Re: Refresh DB |
|
|
| Quote: | you can use Requery, which is the same as if you would call Close and
then Open. It refreshes the dataset using the original command or SQL
statement. However, using it you won't be able to change those
properties that can only be changed when the dataset is closed.
|
Requery is quite a bit faster than Close/Open
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
