A customer is using an application on top of visual foxpro v5. I connect and do following:
@tables = $dbh->tables( $catalog, $schema, $table, $type );
for (sort @tables) { print $_, "\n" }
That returns tables in following format:
`C:\test\BCI\database\DOLLAR2\amw.dbc`!`prepmt`
For now, I am working with a copy of the production database. vfp uses
a database container (.DBC) and each table is a separate file (.DBF) in
same directory as DBC.
What is that prefix called?
`C:\test\BCI\database\DOLLAR2\amw.dbc`
How can I programmatically get the above string into a variable?
The DSN in winders ODBC Data Source configuration points directly to
that file.
Since I will move code between this test box and the production server,
I want to automatically know that prefix, regardless which box I am on.
What do you think?
--
Best Regards,
Mike Schleif
mds resource
877.596.8237
-
Who do you know with idle cash or retirement funds that are not getting
a well-secured, double digit return?
--
signature.asc
Description: Digital signature
