After testing this problem under many different conditions, I have been able to reproduce the error in code. Using my error handler, I have been able to isolate the line of code for each scenerio. In both cases, the oFieldCollection is blank (when it should be an object).

For the error 1924, the code in sfgetcondition.Init is:

* Copy the collection of available fields to the Fields combobox array.

.oFieldCollection = toFieldCollection
lnFields = toFieldCollection.nCount

For the error 1925, the code in oQuery.Show is:

* If we don't have any fields defined yet, call the Filter dialog's Setup
* method to populate it with fields.

llOK = iif(.oFieldCollection.nCount > 0, .T., ;
.oFilterDialog.Setup(.oFieldCollection))

The strange thing is the oFieldCollection is correct the first time through the show method. It is only after leaving the form and then coming back that oFieldCollection is empty.

Any ideas on how this is getting cleared or not being set again?

I have the cAlias set to a table and several fields have the *:SFQUERY NOFILTER statement in the comments and the first time the field list looks correct. I also have some local views built on this same table. There are also some SQL's to Cursors on this table. Is it possible there is a conflict and Stonefield Query is having difficulty geting the field collection?

Again any help would be greatly appreciated.

Mat Kennedy
Decsion Support Technology Inc.