Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use an Event Object to Import Data?
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00453014
Message ID:
00453333
Views:
20
Thank you!

>>I am new to MM, and wanted to say what a great product this is! Now that I have buttered some people up < g >, I have a question about event objects.
>>
>>I have to import some data from a text file into a SQL Server database, and am wondering if an event object is the best way to do this. I have three entities (tables):
>>
>>1. Company
>>2. CompanyImport
>>3. CompanyUpdate
>>
>>The way the process works is that I append records from the text file into the CompanyImport table (entity). For each CompanyInport record, I see if it already exists in the Company table. If it does, I update the information in the Company record, if necessary. If the CompanyImport record does not exist in the Company table, I add it to the Company table. In either case (an update or an add), I record what happend in the CompanyUpdate table (entity).
>>
>>Since this is really my first OOD, am I correct in using an event obect in MM to handle this?
>>
>>TIA
>
>I would agree with you in wrapping the whole process in an Event object. Events are used when you need to work with more than one Business Object.
>
>P.S. I sent you a private email about the SQL Server procedures you asked for.
>
>Hope this helps.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform