Subject | AutoFetchAll in Lookup datasets |
---|---|
Author | Norman Dunbar |
Post date | 2003-01-20T16:10:32Z |
Afternoon all,
I'm playing around again, and in the course of said playing, I've noticed
that regardless of the setting of AutoFetchAll on a query used as the
DataSource for an IB_LookupCombo, that the whole set of rows selected by the
query seems to be pulled over from the server anyway. (Using SQLMonitor)
I'm opening the lookup query before the main query gets opened, so I know
from the monitor that all rows have been pulled down prior to the main query
being opened.
Before I go delving into the source, can anyone confirm that this is the
case please. I'm writing up a small tutorial article and this could be
relevant. I suspect, ut don't know for sure, that if the KeyLinks is a
'paired keylinks' then AutoFetchAll is (internally) set true regardless.
Of course, I could just be barking up the wrong tree again ......
Cheers,
Norman.
PS. Hope none of the Aussies on the list are affected by the fires - it
looks pretty bad down under at the moment. I have a friend (on another news
group) in Canberra that I haven't heard from yet and I'm a bit worried.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.
I'm playing around again, and in the course of said playing, I've noticed
that regardless of the setting of AutoFetchAll on a query used as the
DataSource for an IB_LookupCombo, that the whole set of rows selected by the
query seems to be pulled over from the server anyway. (Using SQLMonitor)
I'm opening the lookup query before the main query gets opened, so I know
from the monitor that all rows have been pulled down prior to the main query
being opened.
Before I go delving into the source, can anyone confirm that this is the
case please. I'm writing up a small tutorial article and this could be
relevant. I suspect, ut don't know for sure, that if the KeyLinks is a
'paired keylinks' then AutoFetchAll is (internally) set true regardless.
Of course, I could just be barking up the wrong tree again ......
Cheers,
Norman.
PS. Hope none of the Aussies on the list are affected by the fires - it
looks pretty bad down under at the moment. I have a friend (on another news
group) in Canberra that I haven't heard from yet and I'm a bit worried.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.