Hi,


I'm working on VFP DBC, where structure frequently change,let's assume there is employee information.

EMP.DBF

CID (PK)
SSNO (SK)
EMPNO (SK)
ELNAME
EFNAME
EMNAME ..... 100 others fields.


These strucuture always change.(Some time in one release 3 to 4 time)
I'm updating information using views lv_EMP.IF strucuture expand, I have to change table & view.At client side sometime views curruption occurs or sometime view is not saving information into data.so What I'm thinking is change structure.

EMP.DBF

CID (PK)
SSNO (SK)
EMPNO (SK)
ELNAME
EFNAME
EMNAME
EXMLMemo (store others fields info into XML format).

Create two view.
1. lv_EMP which contains CID,SSNO,EMPNO,ELNAME,EFNAME,EMNAME
2. lv_EMPXML which contains CID,EXMLMemo

So whenever I have to add more fields, I can add one more item into XML.Also I can create four function.

XMLTOMEMO
MEMOTOXML
MEMOTOCURSOR
CURSORTOMEMO


so I can use other fields for reporting & other calculation.
The Reason for XML is, If MS VFP7 or 8 DBC contains XML data type I don't have to do more work.

I'm thinking right or wrong. If any other suggestion, it's help me more.

Please reply me.


Thanks in Advance
Ambrish