Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Field
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00742718
Message ID:
00743154
Views:
13
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?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform