Hans It has been a long time since I needed DBFs (approx 15 years) so my memory is cloudy. But let me also give you another approach. For any foreign DBMS I always create in R:Base a temp table of the (sconnected) and or sattached table. All reports and forms are based on the R:Base temp table. If I need to push information back to the original DBMS I use SSQL command Maybe I do this since I am more careful then I need to be. But it works for me! DBF ACCESS and other DBMS
Gunnar Ekblad -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Hans Manhave Skickat: den 15 september 2010 16:24 Till: RBASE-L Mailing List Ämne: [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
