StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Map a Free DBF tableExpand / Collapse
Author
Message
Posted 07/13/2006 2:57:55 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 3:44:43 PM
Posts: 627, Visits: 10,881
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.

Post #1838
Posted 07/13/2006 3:10:16 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 5:44:29 PM
Posts: 4,366, Visits: 4,393
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.
Post #1839
Posted 07/13/2006 3:34:50 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/01/2008 8:53:41 AM
Posts: 2,671, Visits: 1,879
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.


www.bungie.net
Post #1840
Posted 07/13/2006 6:01:20 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 3:44:43 PM
Posts: 627, Visits: 10,881
Hi Ben.

It worked like a charm !

Thanks a lot.

Post #1841
Posted 07/13/2006 9:45:20 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/01/2008 8:53:41 AM
Posts: 2,671, Visits: 1,879
Glad to hear it Ivan


www.bungie.net
Post #1845
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:30pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.