>>In my VFP applications I am using SFQUERY to create filters/queries for user-defined reports. I would like to continue using SFQUERY when creating reports based on the data in SQL Server. At the first glance, the way I see it, I would have to have a "dummy" VFP database and tables to match the tables and fields of the SQL Server. Then I would create a query string based on the VFP database and tables and then use it on SQL Server.
>>
>>Does the above approach seem like a logical and practical method?
>>
>>Does anybody use SFQUERY with SQL Server?
>>
>>I use the older version of SFQUERY (v 6, that was in beta but was never released).
>>
>>Thank you in advance for any suggestions.
>
>Just a suggestion. Perhaps creating a new thread in Stonefield category would be better.
>
>I kinda remember Doug saying that he used it already with SQL Server.
Thank you, Denis. I this thread does not pick up, I will post it in the Stonefield category.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham