MS Foxpro 5.0?

Question

I use Microsoft Foxpro 5.0 to store statistics at work. Owing to bad planning when my predecessor constructed the fields, there are redundant fields. E.g. when I input "1" in field A, I need to input a textual expression of "1" in field B. The number in field A corresponds to the textual expression in field B. The problem is my boss doesnt want to delete either of the field. Is there any way that I can pre-set the programme so that whenever I type "1" in field A, the textual expression in field B will be automatically filled accordingly? Would that change also take effect with previous records?

Also, is there any way to insert a new record between two existing records?

MS Foxpro 5.0 is not 2000 compliant. Would I be under risk of loss of data if I switch to other database programmes such as MS Access or even Excel?

Answer 1

when u input 1 and if u want ONE you have to write a program which will convert number into word. if u are already using program for data entry, then u have to change that program.

u can easily change the previous records with replace command.

to insert a new record between two existing records

suppose u want to insert between recno() 1000 and 10001

use the following command

use
go 1000
insert blank

but there should be no index tag in the file, if there are index tags then deleted them insert a record then u have to recreate the index.

to delete index tags

use