I think you miss my point. I already have multiple tables SATACHED.
When I do UNLOAD STRUCTURE the file contains the definitions. Here is one example: SCONNECT 'CRMLive' SATTACH Users USING + UserID ALIAS + UserID , + CRMUserName , + Password , + FullName , + RBASEPunchCode , + RBASEID , + RBASEInitials , + CRMPhoneExtension , + CRMEmail , + fkDepartmentID , + fkManagerUserID , + ScheduledStartTime , + ScheduledEndTime , + ProfilePictureName , + ProfilePicturePath , + CreatedDate , + CRMCreatedBy , + CRMActive All I'm interested in doing is unloading these definitions to a file without having to unload the entire database structure, just like I can do with tabledef, views, etc. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, January 27, 2012 12:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: UNLOADIN SAttached definitions Dennis, Do you want a dsnless connection something like this; set v vsconnect text= + 'MS Access Database;driver={Microsoft Access Driver (*.mdb, *.Accdb)} {;dbq=' set v vsconnect=(.vsconnect+.vdirname+'SomeAccessDatabase.mdb') sconnect .vsconnect sattach temporary ASalesImport using all Or does the sattach change ? Then you could build a list of foreign tables to sattach and pick from the list. Does this help ? Bil Eyring -------- Original Message -------- Subject: [RBASE-L] - RE: UNLOADIN SAttached definitions From: Dennis McGrath <[email protected]> Date: Fri, January 27, 2012 9:31 am To: [email protected] (RBASE-L Mailing List) Bill, Looking for a way to unload the commands to SATTACH foreign tables. Currently I have to UNLOAD STRUCTURE, edit the file and grab the section that does this. On a large db (tablewise) this is a SLOW process! The unload is instant but editing a large file is a pain. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Thursday, January 26, 2012 7:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: UNLOADIN SAttached definitions Dennis If you need data and structure all you have to do is; PRoject NewTableName from SAttachedTableName using all After that you can then just do an Unload data and structure from the projected table and you will not have the SCONNECT/SATTACH command. Hope that helps. Bill Eyring ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, January 26, 2012 10:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - UNLOADIN SAttached definitions If I UNLOAD STRUCTURE, included in the file are commands to SCONNECT/SATTACH permanently SATTACHed tables. Is there an UNLOAD synatax to just UNLOAD the SCONNECT/SATTACH? UNLOAD TABLEDEF gives me just the table definitions. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]
