>>>I may have been barking up the wrong tree. I converted the VFP memvar to type DateTime and still get the same error. (Which, again, does not occur in the VFP 6 version of the app running against the same SQL Server database). Here is the relevant info. Ndxfl1 is a remote view against a table by that name in the database. The remote view is populated correctly. The DateTime field is d_ate.
>>>
>>>The command:
>>>
>>>select d_ate=max(d_ate)
>>> from ndxfl1
>>> where ir_table=?nirfile
>>> and ir_type=?nir_type
>>> and d_ate<=?m.mdbegdb2
>>>
>>>The values, as captured in the debugger at the point of error:
>>>
>>>Nirfile = 1.00000000
>>>Nir_type = 1.00000000
>>>m.mdbegdb2 = {12/31/1899}
>>>
>>>The error message returned by SQL Server:
>>>
>>>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'd_ate'.
>>
>>I'm confused. If remote view is populated correctly, where error message comes from?
>
>Scratch my previous idea. The SELECT statement that errors is selecting FROM ndxfl1. Now I am curious what it was trying to select INTO.

SO you've a view ndxfl1 on ndxfl1 table and there's also select from ndxfl1 table ? How this select is excuted, SQLEXEC()?