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?

Thanks, Scott

>Just a SWAG, but:
>
>CLOSE ALL
>OPEN MYDBC EXCL
>VALIDATE DATABASE RECOVER
>MODIFY DATA
>
>Then, click on Database and Clean up the database so all the deleted records are removed.
>
>Next, you could just drop the views, clean up the database again, then try running your code to create the views again.