I don't have access to the sys tables. Can I grant myself access or does a sysadmin have to do it. As you can tell I am not very familiar with this application, so that is making this difficult as well. I do appreciate the help.
Thanks -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Tuesday, July 29, 2008 10:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export Charles, Try the following code to see if it is defined in a view and/or column. SEL SYS_COLUMN_NAME, SYS_TABLE_ID,SYS_TABLE_NAME FROM SYS_COLUMNS T1, + SYS_TABLES T2 where T1.SYS_TABLE_ID=T2.SYS_TABLE_ID and SYS_COLUMN_NAME+ LIKE 'F_SDUE' The list column command does not list the columns in a view the above code will include them. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/29/08, Charles L. Dore <[EMAIL PROTECTED]> wrote: > From: Charles L. Dore <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: 6.5 export > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 29, 2008, 8:35 AM > F_SDUE was only in one table, it's not even in the table I am trying > to export. It doesn't make any sense to me. > > > Column Name Table Name Attributes > ------------------ ------------------ > --------------------------------------- > F_SDUE BDINFO01 Type : DATE > > Compute: FYE+60 > > Thanks again > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami > Aaron > Sent: Tuesday, July 29, 2008 9:27 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > Ah - so the problem is that, either in another table or in a view, you > have this same column, F_SDUE, that is NOT set up as a computed > column. > To see if it is in a table, do this: > > At the R> Prompt, type: > > LIST COLUMN F_SDUE > > This will show you all the tables this column is in, AND it will show > if it is defined with the proper expression in all tables. > Find the > table(s) where it is listed without the expression and either drop the > column from just those table(s) or rename the column in those > table(s). > > If it doesn't appear to be a problem in a table, then the problem > could be in a view where you have included the F_SDUE column but have > not also included the required columns in the table that are used in > the expression on this column. > > Sami > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > Charles L. > Dore > Sent: Tuesday, July 29, 2008 8:13 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > Here is the error message and the code I used. This column is also in > another table. > > -ERROR- Column F_SDUE exists as both a computed and non-computed > column. > ( 195) > You must rename the non-computed column before you can do an UNLOAD. > > > Unload data for reg_exem using reg# comments as ascii. > > Thanks for your help > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami > Aaron > Sent: Tuesday, July 29, 2008 8:19 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > Hmmm... an UNLOAD should allow you to UNLOAD a computed column. > > Or is the problem that once you UNLOAD a computed column you can't > LOAD the > data back into a table with the same computed column? If > that's the > case, > use the "USING columnlist" option in the UNLOAD statement and exclude > the computed column from the list. > > If that doesn't work for you, post your exact set of commands and > error messages here. > > Sami > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > Charles L. > Dore > Sent: Tuesday, July 29, 2008 6:55 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > It won't let me do the unload command because of a computed field. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami > Aaron > Sent: Tuesday, July 29, 2008 7:44 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > Charles - > > Exactly how are you trying to do this export? > > Here's one way: > > SET WIDTH 5000 > OUTPUT filename.dta > UNLOAD DATA FOR tablename USING columnlist AS ASCII WHERE clause ORDER > BY columnlist OUTPUT SCREEN SET WIDTH 79 > > Or type HELP UNLOAD at the R> Prompt for more options. > > Sami > > ____________________________ > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > Charles L. > Dore > Sent: Tuesday, July 29, 2008 6:20 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > Is there a limitation on the field size for exporting? It seems that > it will only export 256 characters. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. > Razzak Memon > Sent: Monday, July 28, 2008 1:55 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: 6.5 export > > At 01:37 PM 7/28/2008, Charles L. Dore wrote: > > >I am trying to export a table with a note field. The > export works okay, > > >but truncates the notes field. Is there another way to > export the data? > > Charles, > > Take a look at the enhanced R:BASE GATEWAY Import/Export modules in > R:BASE 7.6 and Turbo V-8 for Windows. > > R:BASE 7.6 for Windows (FREE Evaluation Version): > http://www.rbase.com/evaluation/ > > Product Details: > http://www.rbase.com/rbg76/ > http://www.rbase.com/rbg8/ > > Product Comparison: > http://www.rbase.com/products/compare.php > > Good luck! > > Very Best R:egards, > > Razzak.
