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:
local lcAlias
lcAlias=alias()
IF VARTYPE(goquery)=[O]
RELEASE goQuery
ENDIF
LOCAL llError
IF FILE('c:\dev.cq')
ON ERROR
else
ON ERROR llError=.t.
ENDIF
goQuery=NEWOBJECT("sfquery","c:\ctsql\stone\sfquery\sfquery.vcx")
IF USED('sqlresult')
select sqlresult
with goQuery
.calias=[sqlresult]
.cFilter=" "
.show()
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.