Peter,
It would be helpfull if you tell what 'DOES NOT WORK' actualy means. Anyway, UPDATE-SQL command w/o WHERE clause updates all records in the table/cursor/view and REPLACE w/o conditions/scope updates only current record.
>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
--sb--