StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Map business object to Visual Foxpro remote view

Map business object to Visual Foxpro remote view

Wang Tong Yin — Thu, 16 Jul 2009 12:33:31 GMT

I can map my business object to Visual Foxpro database table. How can I map the business object to Visual Foxpro remote view?

RE: Map business object to Visual Foxpro remote view

Trent L. Taylor — Thu, 16 Jul 2009 12:33:31 GMT

I would assume so....that was a long time ago!!! :D

I will have to set this up as I honestly haven't tried this in a very long time.

RE: Map business object to Visual Foxpro remote view

Keith Chisarik — Thu, 16 Jul 2009 11:06:29 GMT

Was this addressed, I am unable to see VFP views. Thanks.

RE: Map business object to Visual Foxpro remote view

Trent L. Taylor — Tue, 18 Jul 2006 21:19:25 GMT

We are working on this as we speak. There is an issue with the OLE DB provider giving us the views. We will let you know as soon as we have a fix. Sorry for any trouble.

RE: Map business object to Visual Foxpro remote view

Wang Tong Yin — Tue, 18 Jul 2006 20:15:08 GMT

I can connect to foxpro local view using OLEDB connection string in Visual Studio .Net. For example, my connection string is "Provider=VFPOLEDB.1;Data Source=C:\data\test1.DBC". How to use StrataFrame business object mapper connect to foxpro local view?

RE: Map business object to Visual Foxpro remote view

StrataFrame Team — Mon, 17 Jul 2006 08:38:35 GMT

No, within the .NET DbConnection.GetSchema() method, the SQL Server connection returns views as if they were tables, so you can easily map a business object to a view in SQL Server. However, it is more difficult to map a business object to a view in FoxPro. I will test to determine if it is possible at all and let you know.

RE: Map business object to Visual Foxpro remote view

Wang Tong Yin — Mon, 17 Jul 2006 02:18:02 GMT

I cannot see the view and romote view of my foxpro database when using business object mapper. I only see the tables. Did I made any mistake?

RE: Map business object to Visual Foxpro remote view

Wang Tong Yin — Mon, 17 Jul 2006 01:54:30 GMT

I will like to add on the above. What we are trying to achieve is enable our app in Strataframe to support current and new version releases of the main app. Future releases may require newly added of fields and changed field names. So we are figuring whether possible to use remote view or cursoradapter where we only need to change this for future releases...