Re: Window XP Error Accessing File



"Juan Alonso" <john@xxxxxxxxxxx> wrote in message news:#cpH$LVYJHA.5156@xxxxxxxxxxxxxxxxxxxxxxx
Ok. Here is something new.

I am having a problem with very large tables.

The error I get is "File Read Error... Path and File Name".

I am performing a simple replace on a numeric field.

Eg.: Replace All "numeric field" with "Numeric Value"

I use VFP 8 Plus all service packs and hotfixes.

The table is about 23 million records.

I tryed it with several different commands.

Like Scan...Endscan, Do While !EOF()....EndDo, and of course the
above REPLACE ALL command.

They all give me the same problem after 999,5xx records.

I don't know why it gives me this problem. It id not do this when I created
the 23 million original records and I have not changed anything in this
table.

By the way.. the table contains every single combination you can play in the
Florida Lottery.

The fields are POS1, POS2, POS3, POS4, POS5, POS6, MACBALL, DESTINY

All fields are character type except MACBALL and DESTINY.

I am replacing MACBALL with
VAL(POS1)+VAL(POS2)+VAL(POS3)+VAL(POS4)+VAL(POS5)+VAL(POS6).

The record stays locked if I suspend.

I did notice that in a browse window the bahavior happens if I PageUP or
PageDown while holding the button so it goes fast.

Any Ideas??????

Anyone???

The file is 941 megs. in size.

The VFP Help on the error says the system gave me that problem.

I don't know what else to do.

My OS is Windows XP with all updates and service packs on a IBM NetVista
Computer.

Its a pritty nice PC, never gives me problems. Well until now.

But other than this happening it works fine with other programs I have
created and won't crash.

Ok.. let me know if you can figure something out.

Thank you all in advance,

Juan.


What is the format type of the hard drive (FAT32 or NTFS)? If FAT 32 you may be getting a file size limitation of 4 GB on the replace.

Do you have at least 4 times (my estimate) the free space on the hard drive over what the file size is when it just sits on the hard drive (941 MB)?

What program are you using?

.