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" ?



>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