Hi Doug;

Thats actually what I did, except I did it once for every table.

use data\dbf
for x=1 to afields
dbsetprop
endfor

then repeat.

The reason I say this is because SFQuery and other things take their captions from the database, and we wanted to take it form our captions.dbf. And I think you changed that while you where here but i've updated since then it overwrote. So to change it back should I just search in the class browser for dbgetprop and dbcxgetprop then change them to oApp.GetCaptions?

Thanks
Mike Helland

>
>It's pretty straightforward code, something like:
>
>lnTables = adbobjects(laTables, 'Table')
>for lnI = 1 to lnTables
> lcTable = laTables[lnI]
> use (lcTable) again shared
> lnFields = afields(laFields)
> for lnJ = 1 to lnFields
> dbsetprop(lcTable + '.' + laFields[lnJ, 1], 'Field', 'Caption', '')
> next lnJ
>next lnI
>
>Doug