Hi,

I’m still getting my feet wet with VFE. I need a little advise on the best way to use VFE for what I’m trying to accomplish.

I need to import data from 3 different sources into 3 different holding tables in the DBC then process through those holding tables to get the data where it needs to go. (These are not straight append into the destination files.)

What I’ve done so far is create a form class based on ibasemodalform with a text box and two command buttons. The textbox is used to accept the date of the import files (used to check importing the correct file) and the command buttons are “run import” or “cancel”. I’m working on creating a custom class that holds all of the methods of the processing that needs to take place, these methods need to be available to other classes as well. I will drop this custom class on the form class.

My dilemma is how to deal with the tables. Should I create views for each of the holding tables and create cursor classes for each of those and drop the cursor classes on the form class with the no data on load property set to T. I’m assuming no data on load is like zapping a file, without the zap? Each time I run the form I need to have the holding tables empty. Should I also do the same thing for the tables that the data is processed into, but open them with data on load?

I’m also assuming, when I drop a cursor class on a form the table/view, it is available to me to start working with as long as I set the auto open property to T? Do I have to worry about if !USED() when I do this?

Here is where I’m really confused: Do I use the cursor classes or do I need to continue up the chain of classes and create data environments and bizobj classes and drop the bizobj class on the form to do what is described above.

Thanks,
Jacci