Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Deleted Records
Message
From
11/03/2000 17:54:09
 
 
To
11/03/2000 17:39:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344598
Message ID:
00344623
Views:
30
Looks good. Be sure to SELECT the target table before doing any REPLACE commands, because the replace doesn't happen if another work area is selected and the table in that work area is at EOF(). Probably you already took care of that in the code that precedes what you posted.

Rick

>Hi Rick,
>
>Thanks again for the reply.
>That's kinda what I worked out while I was off line. Thanks for validating my idea on that...
>
>
>SET ORDER TO DelRec IN MyTable
>SET DELETED OFF
>IF SEEK(.T., "MyTable"
>  RECALL
>  REPLACE Field1 WITH NewData, ;
>    ...
>ELSE
>  INSERT INTO MyTable;
>    (Field1, ...);
>    VALUES(NewData, ...)
>ENDIF
>= TABLEUPDATE(.T., .T., "MyTable"
>SET DELETED ON
>...
>
>
>
>Did I miss anything???
>
>Thanks
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform