foxpro 2.6 Free Tables


Author
Message
Paul Chase
Paul Chase
Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
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?

StrataFrame Team
S
StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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 Smile

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

Paul Chase
Paul Chase
Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
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 typeBigGrin
Paul Chase
Paul Chase
Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
It works fine
StrataFrame Team
S
StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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...
Paul Chase
Paul Chase
Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)Advanced StrataFrame User (594 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
Hehehe I bet!

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

StrataFrame Team
S
StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Hehe, yes, the tools development business is completely different from creating commercial software Tongue
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search