jmkimmel Posted September 27, 2004 Share Posted September 27, 2004 I need to make a copy of a table's structure within the same file. I am making archive tables to cut down on the number of records normally seen by a user in day to day use. I don't want to have to totally redefine the tables if I don't have to. I am assuming that I will have to make an odbc connection to the file and use SQL to copy the table somehow, but since there isn't a supported Copy function in the documentation, that makes it hard. Has anyone solved this type of problem that could give me a point in the right direction and save me some all too precious hours? Link to comment Share on other sites More sharing options...
andygaunt Posted September 27, 2004 Share Posted September 27, 2004 John - Look at FMRobot by New Millennium (www.nmci.com) Unfortunately FileMaker 7 does not include a native function to duplicate tables (yet) Link to comment Share on other sites More sharing options...
RalphL Posted September 27, 2004 Share Posted September 27, 2004 Why not put the archive tables in another file? Make a clone and modify it. Link to comment Share on other sites More sharing options...
jmkimmel Posted September 27, 2004 Author Share Posted September 27, 2004 I was trying to minimize the number of files to simplify the security setup. It just seemed like there ought to be a way to pull it off with the parts of SQL that are supported, but maybe not. Link to comment Share on other sites More sharing options...
jmkimmel Posted September 27, 2004 Author Share Posted September 27, 2004 I wasn't looking to automatically convert much of this solution, so I was not looking at purchasing anything to do it for me, just trolling for a ready made solution. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7292 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 accountSign in
Already have an account? Sign in here.
Sign In Now