StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » foxpro 2.6 Free Tables

foxpro 2.6 Free Tables

Paul Chase — Wed, 13 Dec 2006 13:35:37 GMT

I am working on writing an import routine for 2.6 free tables to SQL. Currently I am just using an oledb command to get the fox data but it would be nice to be able to use a business object for the strong typing(I have a terrible memory when it comes to field names) , however it looks like you only support a DBC in the BOMapper when it creates the connection string.

I guess I can just create a DBC and add the tables I need to it, but because this is going to be part of the install which means I will also need to create a VFP com object to create and add tables to the DBC aswell as ship the VFP runtimes. So might just be easier to flip back and forth to get field names and the translation. any recomendations?

RE: foxpro 2.6 Free Tables

StrataFrame Team — Wed, 13 Dec 2006 13:35:37 GMT

Hehe, yes, the tools development business is completely different from creating commercial software :P

RE: foxpro 2.6 Free Tables

Paul Chase — Wed, 13 Dec 2006 13:30:57 GMT

Hehehe I bet!

Im sure that developing for developers has its own set of challenges!

RE: foxpro 2.6 Free Tables

StrataFrame Team — Wed, 13 Dec 2006 08:50:40 GMT

Hehe, well, when we first put the connection string blanks in the BOMapper, there wasn't a "..." button to build the string for you in a wizard, and we got some major blowback on that...

RE: foxpro 2.6 Free Tables

Paul Chase — Wed, 13 Dec 2006 08:49:59 GMT

It works fine

RE: foxpro 2.6 Free Tables

Paul Chase — Wed, 13 Dec 2006 08:29:11 GMT

Ben that makes sense I just didnt think of manually setting the connection string. You spoiled me with too many wizards and gui options. I have almost forgot how to type:D

RE: foxpro 2.6 Free Tables

StrataFrame Team — Tue, 12 Dec 2006 16:23:28 GMT

No, you can use free tables, you just have to manually create the connection string... you can't use the wizard, as the wizard (through the "..." button) looks only for DBCs.

Here's some more info for you :)

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