Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table Structure & XML (HOT-FIRE)
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement