I'm looking for clarification about what a DEFINE FILE xxxx ADD does.... does it allow you to redefine a table and at the same time, add more fields to that table?

The reason I ask is that I've inherited several hundered FOCEXECs and have never come across this before, but now have a "need to know."

Thanks to all who reply....looking forward to hearing from you.

This message has been edited. Last edited by: webmeister,

quote:

DEFINE FILE xxxx ADD

It allows you to ADD additional defined fields to a previous set of DEFINE's.

DEFINE FILE ABC

END
TABLE FILE ABC

END
DEFINE FILE ABC ADD

END
TABLE FILE ABC

END

Second one gets new fields. Of courese, I'm not sure this works in all environments any more.

Thank you, Leah,

That was what I was thinking, but wanted to have my thought confirmed.

I appreciate you taking the time to reply.

DEFINE FILE ... ADD is part of core FOCUS and folks here use it all the time.

We do as well.

Leah has the answer, to explain further, if you DEFINE FILE XXXXX and then later in the same procedure you DEFINE FILE XXXXX again, all the defined fields from the first are lost and/or replaced by the second unless you DEFINE FILE XXXXX ADD.