dBase do not support integer fields - only decimal / numeric fields. If the decimal fields are too wide, MapInfo won't open the dbf. I had the same problem a few days ago with a decimal field that was 31 wide. Try to check that.
If your dbf is of a more recent kind than the usual version 3 or 4, you may in fact be able to store integer fields in it (in the same ways as MapInfo DAT files do), but then I guess MapInfo just don't support such dbf files. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Terry McDonnell" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, January 18, 2005 5:39 PM Subject: MI-L MI Won't recognise the new fields in my .DBF file. Hello Listers I have a Foxpro tablen which has been, some time in the past, converted to a dBASE .DBF file and imported into and converted to an MI file. On starting my MB app the table is registered as below: Register Table gcWADPath + "SerData\RZStop.dbf" TYPE DBF Charset "WindowsLatin1" Into gcWADPath + "MapData\RZStop.TAB" Open Table gcWADPath + "MapData\RZSTOP.TAB" Interactive Now, recently I have had to alter the structure of my Foxpro table, adding extra fields, but none that I would expect to be "alien" to MI/MB (V 7.8). I've added more of the same character and numeric fields as were always there but one field as INTEGER. When the prog gets to the "Register" command above I get the error message: "This table contains unsupported field types. .... Unable to prepare table ..." Now I'm a bit rusty on the process to make the dbf table compatible so perhaps you could advise me if I've missed something out but I: * took the new version of my Foxpro table and converted it to dBASE. * opened it as a dBASE file in MI, code page convert it, etc., with the MB window open, which resulted in the following code: Register Table "C:\mcl_windows\MapData\rzstop.dbf" TYPE DBF Charset "WindowsLatin1" Into "C:\mcl_windows\MapData\rzstop.TAB" Open Table "C:\mcl_windows\MapData\rzstop.TAB" Interactive Map From rzstop and a map window opens up OK. Note that, apart from the paths, the syntax above is the same in my prog. I'm able to browse the table (although it's empty at the moment). As soon as I run my prog again I get the same error message. What gives!? And are dBASE integer and MI integer fields incompatible? Surely this would be documented?! Can anyone help please? Terry McDonnell --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14903
