exporting records from fp5 to fp5 does not yield a table?

March 13, 200124 yr

Hello? Am I all alone here? Maybe if I post enough questions and answer some (most?) of them myself maybe I can be the moderator of this forum (probably not).

If I export (a subset of) records from an existing fp5 file, for some reason ODBC doesn't recognize the new fp5 file as a table.

Why is that?

If I create a copy of the fp5 file, ODBC recognizes it (the copy) fine. What's the difference between exporting to a fp5 file and creating a copy? Doesn't exporting create a table if it is exported to a fp5 file? It sure looks like a table...

Is anyone out there using ODBC?

Michael

[This message has been edited by mikihasa (edited March 12, 2001).]

March 13, 200124 yr

If you 'copy' the FMP file, you also copy all of the data, the layouts, scripts, etc. - in other words - a copy of the file, warts and all.

When you export to an FMP file, you only copy the fields exported, and only the data from the fields exported from the current found set of records. No scripts, or layouts are included.

March 13, 200124 yr

Author

I think I understand what you said. Thanks for responding. I was beginning to think I was all alone here in this ODBC forum.

My problem is that ODBC doesn't think the exported file is a table. I don't mean anything layout-related by using the term "table". I don't care about layouts, scripts or anything else...just the data.

What I mean is that when I open the exported file in FMP and then try to connect to it using ODBC I get errors that the exported file is not a table (a.k.a. datasource).

I apologize if I wasn't clear.

Here is an example of the error I get when I try to connect to an exported database (MIKE3) that is opened at the time the program is run:

DBD::ODBC::db prepare failed: [FileMaker][ODBC FileMaker Pro driver][FileMaker P

ro]Invalid database name. (SQL-S0002)

[FileMaker][ODBC FileMaker Pro driver]Cannot open table: MIKE3 (SQL-S0002)(DBD:

st_prepare/SQLPrepare err=-1)

I get no such error if I save a copy of the file, delete out the records to make a subset, and run the program again. I'd like to be able to use the export feature to create a subset--it seems easier.

Michael