I need to rewrite my FoxPro 2.6 project to Windows.Net platform.
In the existing system I created the following process for correspondence (mass letters to bunch of people or individualized ones). All letters/paragraphs are stored in the Letters.dbf table. Each record contains a paragraph number, text of the letter with macros, list of required by the specific paragraph data that users enter on the fly. Macros can be replaced with the data from our database (address...), user entering (respond by ...) or function results (scholarship...). FoxPro's TextMerge takes care of all my macros. I print labels in FoxPro and create a completed text file which is saved to be printed by MS Word at any time. There are a lot of interactions with the users (parameters for selection of correspondents, list of paragraphs, paragraphs' required entering). Most of entering data are validated against the database.
I want to keep the Letters table in a new system. It's a table on SQL server now. Should I replace my FoxPro's macros in the text (<<...>>) with anything else? Where and how can I get macro values? What is the best practice of text merges? Can VB.Net/SQL procedures merge the text? Does anybody have an example of merging a text with a function's result?
Thanks in advance
Slava
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