General information
Category:
Coding, syntax & commands
Title:
SQL UPDATE of DATETIME field does not seem to work
Sergey:
Can you please explain, or tell me where to find the explanation since I've not found one yet, as to why the SQL update command (I'm in VFP9), when used as 'UPDATE xyx SET lu = DATETIME()' where 'xyz' is an updateable view cursor, created using the view designer, of some data from an MS SQL 2K table (which is updateable) and the field 'lu' being updated is a datetime field in both the cursor and in the MS SQL table, DOES NOT WORK yet if I use 'REPLACE lu WITH DATETIME()' this does work? I need to be able to use SQL UPDATE here.
What am I missing here? Do you happen to know? Appreciate your insight since you've been so helpful with past mysteries for me. TIA. /psb
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