J
jmosow
I am trying to access a Progress database using the Datadirect Openedge
10.08 ODBC drivers. I created a datasource and am able to connect to
the database using FP. My problem is with the database results. If I
select the table from the record source, I get an error trying to
connect. If I use the Custom Query, I am able to access the data if I
prefix each of the tables with PUB. However, I then lose the ability
to use the FP criteria, ordering, etc. functions. Is there a way to
set up my ODBC connection in FP to get the best of both worlds?
TIA
10.08 ODBC drivers. I created a datasource and am able to connect to
the database using FP. My problem is with the database results. If I
select the table from the record source, I get an error trying to
connect. If I use the Custom Query, I am able to access the data if I
prefix each of the tables with PUB. However, I then lose the ability
to use the FP criteria, ordering, etc. functions. Is there a way to
set up my ODBC connection in FP to get the best of both worlds?
TIA