Does this happen with every view? What if you predefine the parameter before you create the view? What if you create the view outside any designer and just use code in a PRG to do it?
>Thx Mark.
>
>OK, I tried that .. no help .. same error.
>
>So, I created a new database container, new connection, new remote view and it still procudes the same error...
>
>Here is the sql from the View SQL menu item in VFP:
>
>SELECT Person.Code, Person.Firstname, Person.Lastname;
> FROM dbo.Person Person;
> WHERE Person.Lastname = ?testparm
>
>I have found that I cannot use a parameter field at all. (its not just with the LIKE condition as I had said)
>
>It works ok with a literal instead of a parm field as in:
>
>SELECT Person.Code, Person.Firstname, Person.Lastname;
> FROM dbo.Person Person;
> WHERE Person.Lastname = 'Smith'
>
>I am suspecting this problem is at a lower level .. but I don't want to rebuild everything. Any other thoughts?
Mark McCasland
Midlothian, TX USA