Ali,
The XML in the memo can be as simple as something like:
<mydata>
<itemX>value</itemX>
<itemY>7,/itemY>
</mydata>
Depending on what version of VFP you are using, VFP7 has native XML functions, along with STREXTRACT( ). In VFP6 and before you can use the wwXML classlib from
www.west-wind.com.
Parsing a few items out of a memo should be fast enough for you either by using the full blown XML DOM, or just using simpler string functions.
>Actually it is not a program of mine. I am asked to improve and add some new features to it. He used a Memo field since it is easier to write every thing in a memo field and it shows a good report on the screen as he wishes. As far as it is related to entering data, there is no problem, because he put a hot key to open a form to add new record in another table. However, when you are going to change a number in that memo field it won’t affect the value of the related field in corresponding record in the other table. (I even believe using a hot key is not a good way to add a record to the other table since you might forget to press the hot key.)
>
>He wants to have a very fast program. I am not sure whether using XML in memo field and then parsing the memo field would be fast enough? On the other hand I don’t know how to use XML in a memo field?