Questions for text files!

[James Bond 007]

I have questions for text files!

1. What are the major differences between Random and Binary. If using Random to manipulate as a database, how can I tell the number of records in a text file?

2. For Lock, what is SHARED, LOCK READ, LOCK WRITE, LOCK READ WRITE?

[kedaman]

Random opens with fixed length records, and your file needs to be formatted according to a pattern. Using Binary you can read and write stuff more freely, put several headers, footers, and data suiting your needs.
Lock means when you open the file,
Shared > it can be opened by other open statements but not be deleted
Read > can't be read but written to
Write > can be read but not written to
read write, can't be opened at all.

I remember there was an article on this site about different access modes. I'll if I can find it for you.

[James Bond 007]

Thanks for going the distance Megatron. I wish I can help you guy back.


Kedaman, thanks for your effort. You explained alot of stuff to me in the past.

[James Bond 007]

How can I find the total number of records in an existing random file?

[kedaman]

by integer division

Recs=lof(filenumber)/Reclen

[James Bond 007]

Kedaman,

I am using this code right now. I is placing the next record on the same line. How can I make each record on a new line.


Dim LastRecord As Integer
Open "C:\HHH.txt" For Random Access Read Write As #1 Len = Len(MyWorker)
LastRecord = LOF(1) / Len(MyWorker) + 1
Put #1, LastRecord, MyWorker

[kedaman]

i'm not sure if this works with random access, at least it does with binary, that it automatically moves the location one step forward and write the current record by omitting the record#

Put #1, , MyWorker

[James Bond 007]

Is there a way to delete a record Kedaman?

[kedaman]

Of course it is, but how hard depends on how you want to delete it.

1. just reset the record data
2. shuffle the following data one step left
3. move the last record into the just removed item.