StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Map a Free DBF table

Map a Free DBF table

Ivan George Borges — Thu, 13 Jul 2006 21:45:20 GMT

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.

RE: Map a Free DBF table

StrataFrame Team — Thu, 13 Jul 2006 21:45:20 GMT

Glad to hear it Ivan :)

RE: Map a Free DBF table

Ivan George Borges — Thu, 13 Jul 2006 18:01:20 GMT

Hi Ben.

It worked like a charm !

Thanks a lot.

RE: Map a Free DBF table

StrataFrame Team — Thu, 13 Jul 2006 15:34:50 GMT

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.

RE: Map a Free DBF table

Trent L. Taylor — Thu, 13 Jul 2006 15:10:16 GMT

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.