deleting records 
Author Message
 deleting records

Is it possible to delete multiple records at the same time in a TPS
file, or must recods be deleted one by one? total newbie!


Sun, 06 Nov 2005 21:58:12 GMT  
 deleting records
You can delete all of the with empty, or create to replace an existing file.

If you want to delete a block of records, you will have to loop through the
file.


Quote:
> Is it possible to delete multiple records at the same time in a TPS
> file, or must recods be deleted one by one? total newbie!



Sun, 06 Nov 2005 22:22:14 GMT  
 deleting records
Hi,

You can use the Process template to loop thru the file and selectively
delete. Or create a small Loop in your code to do the same. Or if you
want to delete them all you can use Empty(). It needs exclusive access
so do something like this:

       close(tps_inp)
       open(tps_inp,18)  !* open with exclusive rights
       empty(tps_inp)



Quote:
>Is it possible to delete multiple records at the same time in a TPS
>file, or must recods be deleted one by one? total newbie!



Sun, 06 Nov 2005 23:58:37 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Delete key on keyboard deleting records

2. deleting records in a file using AWK, SED, or kshell

3. deleting records using AWK, SED, etc.

4. deleting record in database

5. Database Delete record question

6. Deleting records within a process

7. Deleting records!!!!

8. deleting records

9. Deleting Records with Calrion 5

10. Delete record from unrelated file?

11. Speed increase not using Reclaim Deleted Records

12. Reclaim Deleted Record with Auto Number Set

 

 
Powered by phpBB® Forum Software