>In going the Vfpoledb route, is some foxpro syntax prohibited? for example
>VDataSourceG.SelectCommand=" SELECT * from r:mytable WHERE recno() =40" works but how about statements like:
>VDataSourceG.SelectCommand=" SELECT * from r:mytable where 'M-'" $method" ?

Is it my imagination, or do you have an extra set of quote marks in there? Should you have a double quote before the dollar sign?

>
>
>
>>Yes it is expecting a parameter for country.
>>

>> <asp:SqlDataSource ID="vfpTestData" runat="server"
>>   ConnectionString="<%$ ConnectionStrings:vfpTestDataConnection %>"
>>   ProviderName="<%$ ConnectionStrings:vfpTestDataConnection.ProviderName %>"
>>   SelectCommand="SELECT company, contact, country FROM customer WHERE (country = ?)">
>>   <SelectParameters>
>>      <asp:ControlParameter
>>         ControlID="TextBox1" DefaultValue="" Name="country" PropertyName="Text" Type="String" />
>>   </SelectParameters>
>> </asp:SqlDataSource>
>>

>>Here: SqlDataSource sets datasource properties along with SelectCommand.
>>Following that "SelectPameters" tag adds a ControlParameter with ID "TextBox1" and other properties. TextBox1 is a textBox on ASP form and at run time ? is replaced with its text. Maybe you don't have TextBox1 on asp form?
>>
>>UT is working well for me.
>>Cetin
>>
>>
>>>I hope you'll end up liking it, makes datasources/connections easier. As for the error, it didn't like WHERE (country = ?)
>>>Is it looking for something in place of "?"
>>>PS, is the UT experiencing errors, when I click "get the replies to my messages", I get a COM error.
>>>
>>>-T