fileProODBC (was Re: filepro wish list)

[Jay R. Ashworth]

On Fri, Apr 29, 2005 at 04:26:46PM -0400, Kenneth Brody wrote:
> 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.

So... what *can't* you do with alien files?

Does fpODBC make indexed columns in the underlying database *look* like
they have automatic indexes, for example?  You wouldn't want to have to
build a filePro-level index for data that already has one -- and lives
somewhere else to boot...

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me