>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only