Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change between VFP 6 and 9 -- DateTime and Date
Message
From
10/03/2009 23:50:42
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
Database:
MS SQL Server
Miscellaneous
Thread ID:
01048077
Message ID:
01387039
Views:
94
>>>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 :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform