fileProODBC (was Re: filepro wish list)

[Enrique Arredondo]

----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Jay R. Ashworth" <jra at baylink.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Friday, April 29, 2005 1:26 PM
Subject: fileProODBC (was Re: filepro wish list)


> Quoting Jay R. Ashworth (Fri, 29 Apr 2005 16:21:31 -0400):
> [...]
>> > > And, to clarify, is that actually correct?  Based on what I think
>> > > I've heard about fpODBC...  Will it actually run unmodified fp code?
>> >
>> > Yes.  You can take an existing filePro application, move the data into
>> > an ODBC source, point filePro there, and run without any modifications
>> > to the code, screens, reports, etc.
>>
>> Misunderstood, clearly.  Thanks.
>
> Well, there is also a "low level" access method, where you explicitly
> control everything, from connecting to a DSN, to building and executing
> a query, to extracting the data.
>
> The "high level" access method hides just about everything, and allows
> you to access the file just as any other alien file you could define in
> ddefine.
>

Which level of fileproOBDC would work with multiple tables within a database 
? On MySQL you can define tables with different fields (I have only 2 weeks 
experience with MySql so correct me If I'm wrong) on them so you just use 
the table that you need with the fields that you need at a certain time and 
not the whole list of fields.