Steve, I converted a FoxPro system and didn't have any DBT files. Here is my procedure: create a file that has:
Attach file1 out file1.cnv unload data from file1 as ascii repeat for file2, etc. detach file1 and all other files Create an rbase database with all the tables as in Foxpro I did the above once just to get the column names to be able to find the ones that aren't legal in rbase. Then I can create an rbase database with the same table names as in foxpro. Conn mydb load file1 from file1.cnv as ascii etc. Bernie Lis ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 3:51 PM Subject: [RBASE-L] - RE: SATTACH > Sami, > > Thanks for the response. I used the following command: > > ATTACH st_products.dbf > > and I get the error > > -ERROR- Unable to open file : st_products.DBT (2583) > > I was able to get one file open with > > ATTACH st_optionval > > but when I try to project to another table using > > PROJECT s_optionval FROM st_ooptionval USING * > > I get the following error: > > -ERROR- Cannot find dBASE file in current directory or path (2585) > > Any thoughts > > Thanks > > Steve > > -----Original Message----- > From: Sami Aaron [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 2:36 PM > To: [EMAIL PROTECTED] > Subject: [RBASE-L] - RE: SATTACH > > > Steve - > > Try using just the ATTACH command rather than the SATTACH. It will link to > a dbf table and may work better than the SQL attach. > > Sami > > > ----- Original Message ----- > From: "Fogelson, Steve" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, October 03, 2003 1:35 PM > Subject: [RBASE-L] - RE: SATTACH > > > > I forgot to add that the Number column is defined with a length of 16. I > > have other columns assigned with a length of 10 that work fine. > > > > Thanks > > > > Steve > > > > -----Original Message----- > > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 03, 2003 1:33 PM > > To: [EMAIL PROTECTED] > > Subject: [RBASE-L] - SATTACH > > > > > > Rbase 6.5+ > > > > I am trying to attach to a Dbase (dbf) table that has a column that is > > defined as "Number" and one that is defined as "Currency". > > > > I get "-WARNING - Unsupported datatype for column XXXXX in table XXXXX > > (2626)" > > > > Is there a workaround for this? > > > > Steve Fogelson > > Internet Commerce Solutions > > > > > > > > > >
