deleting field information in Paradox8

[Barbara]

Please help. I need to delete large amounts of information in a table without
deleting entire records or actual fields. Basically what I need is to delete
all the column information in a field without deleting the field itself. So far
I have only been able to delete this information one cell at a time. Any
suggestions?

Barbara

[JD Adams]

Here is a simple fix. Make a blank new form, with only a button on it. Assume
that the table you want to work on is called TABLE1.DB (Substitute the actual
name of your table) and you want to blank the information in the field named
MyField. Put the following code in the pushbutton method of the button:

var
x LongInt
n SmallInt
tc TCursor
endvar

tc.open("TABLE1.DB")
x = tc.nRecords()
tc.edit()
tc.home()
for n from 1 to x
message(n)
tc."MyField".blank()
tc.nextRecord()
endfor
tc.endedit()
tc.close()
msginfo("","Done")
endmethod

Run the form, then push the button. It will give you the Done message when it
is finished.

If the table is password protected, be sure to put the master password in
before running this.