Hi Bob.

>I was wondering... when SFQuery gets the field names to put in the combo box, and SDT is avilable, does it get the list of fields from SDT which have the filter property set to true...
>
>Or, does it get a list using afields() and then look at the properties for each field eliminating the ones the the filter property is false for?

The latter, but it also spins through the meta data and grabs any calculated fields (assuming you're using SDT 5.1, which supports calculated fields in the meta data) for each table and adds them to the field collection as well.

That said, I'll likely be changing this in a future release because then it could automatically populate the field collection from remote data that has meta data stored in SDT. Currently, either you have to have tables or views open for it to use AFIELDS or you have to populate the field collection yourself.

BTW, if you want to look at the code, it's now (in the latest update to SFQuery available from our Web site) in the GetFields methods of the SFFieldCollection class. It used to be in the same named method of SFGetFilter, but it made more sense to put it where the fields are actually stored (plus I actually use SFFieldCollection in some other tools I'm working on, so I needed it there <s>).

Thanks for these questions, Bob -- it helps me to see how folks are using the product and gives me ideas to make it better. I look forward to any suggestions you have, especially regarding how SDT and SFQuery can be improved for remote data.

Doug