I'm not sure what a DBT file is - there was a file that saved memo field information separately from the main dBase table, but I dont' remember if the extension was DBT. Are you sure these are dBase files and not FoxPro files (they also have a dbf extension). I think dBase file names were limited to the 8.3 naming convention. At any rate, I'd look around for a file named st_products.dbt.
BTW - in your PROJECT statement, you have a typo on the attached table name - that would give you the eror message. If this is a one-shot deal, then if all else fails, I'd import the dbf files to another program (email me privately and I'll tell you which one, but as a clue, it's the company that makes FoxPro and a low-end but relatively widely distributed database product) then export them as CSV and load into R:BASE that way. Sami ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 2: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 > > > > > > > > > > > >
