General information
Title:
Remote view + NoDataOnLoad -> no filters/group by?
I am creating a remote view (with tehe view designer) and I need the group by clause. When I view the SQL code, it is okay. When I run the view, it is also okay.
BUT, when I add my view to the dataenviroment (through a framework) and I set the NoDataOnLoad to .T., VFP doesn't send the group by clause to the server (not even other filters I have set). It just sends my selected fields, plus 'where 1=0'...
When I set NoDataOnLoad to .F., everything is allright.
Why is that?
Is this a bug?
I'm using VFP 7.0 and MS SQL Server 2000.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only