According to the stuff I sent previously, 0x03 is a DBF that has a Memo
field which is a separate file *.dbt and in the absence of that file, RBase
cannot connect to it.
----- Original Message -----
From: "Hans Manhave" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, September 15, 2010 10:24 AM
Subject: [RBASE-L] - Re: Problems attaching DBase table
The files (I checked several) have a 0x03 header.
Does that mean I cannot ATTACH it?
There is a whole third party software system that adds & modifies these
DBF tables. I'm wanting to combine those tables (live) with other third
party data (static) that is in Excel or CSV format that I will probably
import in R:Base. Once that is accomplished I want to create forms
and/or reports for the end user to evaluate.
Right now I extract everything to Excel and do it there. The conflict
is that 1. It is a snapshot, 2. Only on my machine. 3. I have to
rewrite the Excel formulas to calculate the data for earlier versions.
I love Excel, but I'm really trying to get this project off my desk and
on the end user's desk as needed.
Going to look into the ODBC suggestion. I know too little to know if
one is advantageous over the other.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Mike
Byerley
Sent: Tuesday, September 14, 2010 6:40 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Problems attaching DBase table
Here found the identifiers:
DBF FILE STRUCTURE
~~~~~~~~~~~~~~~~~~
BYTES DESCRIPTION
00 FoxBase+, FoxPro, dBaseIII+, dBaseIV, no memo - 0x03
FoxBase+, dBaseIII+ with memo - 0x83
FoxPro with memo - 0xF5
dBaseIV with memo - 0x8B
dBaseIV with SQL Table - 0x8E
----- Original Message -----
From: "Hans Manhave" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, September 14, 2010 6:23 PM
Subject: [RBASE-L] - Re: Problems attaching DBase table
Yes, that gives no errors, lists the table in my R:Base tables list. It
also did not give the reserved words error.
The error that I now get is #2585, Cannot find dBase file in current
directory or path. It just attached the file, how can it have a path
error? This occurs when I want to open the table. I probably shouldn't
be opening the table? Creating a form based on the table does work.
However, using that form creates the same error.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Tuesday, September 14, 2010 5:06 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Problems attaching DBase table
Hans: if you type "SET ANSI OFF" before attaching, does that help any?
Karen
I end up with a "R:Base eXtreme 9.0 (64) has encountered a
problem and
needs to close" error and Windows wants to call home.
Following is my process (using R:Base eXtreme 9.0 (64) with the
latest
updates installed):
- Connect a R:Base 9 database
- Attach a DBF table, no index
- receive error msgs that reserved words are being used and I
update
each of those when it pops up with an acceptable field name.
When it is
through, it comes up with the Microsoft problem.
What am I not understanding that is creating this error?
I am not using an index, yet, just wanting to open the DBF
table. This
problem exists if I want to open a 52MB table or a 1KB table. I
keep
getting the Windows error message and R:Base crashes/terminates.
R:Base
opened the file or it wouldn't have known about the reserved
word usage
for the column names.
Thoughts, please?
Thanks,
Hans Manhave
