Kirk

Try SET ENGINEBEHAVIOR 70 in your program ,compile and run.



>I'm trying to move my app from version 7 to 8, and I have ran into a problem with the sfquery program. I've had this a long time and it has always worked great. Our data comes from SQL Server, and it gets loaded into a cursor (we do not use remote views). The problem I'm having is when they go to create a filter, and click the values button, nothing happens (I do see a flash of a wait window, but I can't read it.) I don't get the value selection window. I can type in a value in the box, and it works. When this same app is compiled in version 7, it all works.
>
>Below is the code I call from a button:
>
>

>*****************************************************
>* Create a filter using the sfquery.vcx
>*****************************************************
>local lcAlias
>lcAlias=alias()
>* Make sure any previous one is gone
>IF VARTYPE(goquery)=[O]
>	RELEASE goQuery
>ENDIF
>LOCAL llError
>IF FILE('c:\dev.cq')
>	ON ERROR
>else
>	ON ERROR llError=.t.
>ENDIF
>******************************************************
>* Create the query object
>******************************************************
>goQuery=NEWOBJECT("sfquery","c:\ctsql\stone\sfquery\sfquery.vcx")
>IF USED('sqlresult')
>	select sqlresult
>	* Select our alias (it is always this alias from the reporting dialog
>	with goQuery
>		.calias=[sqlresult]
>		.cFilter=" "
>		* Display the sfquery dialog
>		.show()
>		* Set the filter on the cursor
>		lcFilter=goQuery.cFilter
>		thisform.frmFilter=lcFilter
>		set filter to &lcFilter
>	ENDWITH
>ENDIF
>ON ERROR DO errsys WITH ERROR(),MESSAGE(1),MESSAGE(),PROGRAM(), LINE(1)
>

>
>
>Thanks for any help.