I use the ATTACH command, the DBF table is accessed and I have to rename five columns. It looks like it is continuing with the file and then R:Base 9 (64) crashes. I have tried this with and without the accompanying dBase index file. I figured I cannot rename the columns that are used in the index file so maybe it crashes for that reason, but no, even just attaching the DBF file crashes R:Base and Microsoft wants to be notified.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Wednesday, August 25, 2010 4:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Opening and modifying DBaseIV tables Hans, INS is a reserved word - short for INSERT. That is probably the source of the complaint. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hans Manhave Sent: Wednesday, August 25, 2010 17:03 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Opening and modifying DBaseIV tables A month later... I get an error #2037 about an illegal table name when using the statement: attach c:\test\ins using ins I understood that a database has to be connected before ATTACH works so I created a database and defined a single table. That table has a single field, no rows. No matter if I create a seven column table or a one column table, I get this error 2037 that complains about 'illegal table name'. In the error it lists the name of the column, not the name of the table. I'm lost. So soon in the process. Anyone have suggestions? Thanks. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Friday, July 23, 2010 9:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Opening and modifying DBaseIV tables You can simply ATTACH the DBase file and go to it. Look up the ATTACH syntax to see how to use the DB index file as well. Albert Hans Manhave wrote: > I would like to open a DBaseIV table, find a certain record based on a > value in a spreadsheet, insert data (currently contained in that > spreadsheet) in a certain field of the record and repeat until the > spreadsheet records have all been evaluated/processed. > > I realize I may want to import the Excel sheet into a temporary R:Base > table. > > Is this (modifying a DBF file) something I should consider doing with > RBase Xtreme 9? I'm hoping it is. > > If it is, does anyone want to give me some brief pointers on it? > > Thank you, > > Hans > > > >
