Dennis, See if the information you need is in the following system table: Table: SYS_SERVERS
No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 SYS_TABLE_ID Type : INTEGER Index : SINGLE-COLUMN 2 SYS_SERVER_NAME Type : NOTE 3 SYS_SERVER_TABLE Type : NOTE 4 SYS_NOTE_DATA Type : BITNOTE Current number of rows: 0 Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 >________________________________ > From: Dennis McGrath <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Friday, January 27, 2012 12:55 PM >Subject: [RBASE-L] - RE: UNLOADIN SAttached definitions > >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] > > > > > >
