Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Deleted Records
Message
From
11/03/2000 18:01:02
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344598
Message ID:
00344626
Views:
25
OOP's < pun intended > I forgot to copy that from my code. Thanks

>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...
>>
>>
>>SELECT MyTable
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform