>>>>what code could i use to verify if a field name is present in a table.
>>>>

>>>>Alter Table c:\db\past.DBF Rename Column thh05 To thh11
>>>>

>>>>
>>>>this works fine however if the program is repeated thh05 is no longer present and an error message appears.
>>>>
>>>>i need an 'if' command to check for thh05
>>>>
>>>>thanks
>>>>kù
>>>
>>>

>>>? !EMPTY(FSIZE("thh05",AliasName))
>>>

>>
>>Unless SET COMPATIBLE On or SET COMPATIBLE DB4 ...! You may argue that only fools use those settings, but there are fools out there, and the setting is there for a reason. :-)
>
>I know.
>But I suppose that before to use a hint,
>a good developer reads the specific documentation.

Unfortunately most developers don't read the documentation thorough enough to remember every little detail. And especially if you inherit an application, you can't take anything in the environment for granted.