Hi

am trying to clear five fields over around a thousand records for a script.

this take a while to loop through the lot so i need to cut it down to record just with text in the five fields

does any one know how i can script it to enter in "" into a field to find any text

if not does any one know how to find blank fields in a script the i can just show omitted and hey presto i have my record set i need

cheers all

To find non empty values in TEXT field use following

Set error Capture [on]

Freeze Window

Enter Find Mode[]

SetField [field1, "="]

New Record Request

SetField [field2, "="]

...

...

Perform Find

If [status(CurrentFoundCount)]

Show omtted

Perform Script [Your Script For Clearing Fields]

else

//Handle no records found

end if

Dj

you could also do a

SetField [field1, """"]

(That's four quotes).