>>>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
>>>
>>
>>>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'd_ate'.
>>
>>I'm not trying to break Nadya's record... was looking for something else and just noticed this. I think the error came from m-dot in the last line. SQL server never heard of m-dot.
>
>I doubt you would ever answer a question from 1999 :)
Don't give me ideas. What brought me here in April 1997 was the question on how to create a method using a builder - i.e. what was already available from the menu. I could answer it now - it's the .writemethod(cName, cText, lAddNew). I can now tell my 1997 self to wait for VFP7 (or whichever version it was when the third parameter was added).
Which I may eventually do, just for kicks :).