Hi everybody.

Please, would anyone know a way to map a free DBF table (can't add it to the VFP database) into a BO ?

Thanks in advance.

You can use ODBC to map your business objects.  This is really the only way I can think of doing this since the VFP OLE DB provider doesn't support free tables...or does it???  I will have to look into this.  You may be able to specify a free table as the data source.  I have not tried this so I will have to look at it.  I do know that the ODBC provider supports a free table though.

I believe C.T. got his free tables to with a certain version of the VFP OLE DB provider.  His connection string looked something like this:

Provider=vfpoledb.1;Data Source=FolderPathContainingTables;Collating Sequence=general;

You'll have to type that connection string in manually in the BOMapper (since you can't use the wizard), and the same connection string can then be used with the VfpDataSourceItem that is added to the DataLayer.DataSources collection.

Hi Ben.

It worked like a charm !

Thanks a lot.

Glad to hear it Ivan