StrataFrame Forum

Map a Free DBF table

http://forum.strataframe.net/Topic1838.aspx

By Ivan George Borges - 7/13/2006

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.

By Trent L. Taylor - 7/13/2006

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.
By StrataFrame Team - 7/13/2006

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.

By Ivan George Borges - 7/13/2006

Hi Ben.

It worked like a charm !

Thanks a lot.

By StrataFrame Team - 7/13/2006

Glad to hear it Ivan Smile