Jump to content

Duplicating Tables in a Database File


CaelC
 Share

This topic is 6528 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I can't figure out how to duplicate a table inside a DB file. A minor annoyance but is there a way to do it? I don't want to have a to recreate all my basic fields in every table (date_modified, date_created, uid, etc. etc.) It would save a little time to be able to duplicate a template table as many times as needed and then start adding the unique fields to each table.

Can this be done in 7?

Cael.

Version: v7.x

Platform: Mac OS X Panther

Link to comment
Share on other sites

wow, now that you mention it, what an oversight. Having a template table is a major concern in development time. I am getting the feeling that FMP7 will have to wait until 7.5 when some of these concerns are resolved.

Link to comment
Share on other sites

But have y'all looked at the ODBC page within FM7 help?

It seems that the FM7 ODBC will have support for CREATE TABLE queries (among many other SQL statements that were unsupported under v5/6). That seems to mean that (if you're on Win) you could conceivably write ODBC routines to create your tables, then re-use them as much as necessary.

I've seen at least one new commercial product advertised that seems to intend to take advantage of this (to convert MSAccess tables to FM7)

I'd very very surprised if you'd be able to do more than create basic field types, not calcs, auto-enters, validation, etc. I'd love to be proven wrong.

The trial version doesn't seem to come with the ODBC driver, so I can't test any of this.

Matthew

Link to comment
Share on other sites

I see where you read that but I think you are misinterpreting it. I think they are saying that you can execute those commands on data sources Filemaker is using.

Link to comment
Share on other sites

I don't think I misinterpreted it, although I completely understand your unwillingness to believe me.

I'm looking at the help topic titled "ODBC and JDBC support in FileMaker Pro", just after the sentence that reads "Queries to a FileMaker Pro data source can include the following SQL statements and constructs".

Also check this out:

http://www.fmpro.org/news/195418540394/

which is what got me looking at this in the first place.

As I said in my first post though, I can't at all vouch for whether or how well it works.

I'd love to hear from anyone who has actually tried working with the new ODBC functionality. There's apparently further docs on this on the install CD, which I don't have since I'm still on trial version.

Link to comment
Share on other sites

This topic is 6528 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.