Hi there I’ve been trying to make just a simple CREATE TABLE into the NF DB, but I haven’t been very successful. The ODBC driver keeps telling me “Data source is read-only (#4)”. I have tried this using a developer license on a local database and a remote too. Has anybody out there successfully executed a CREATE TABLE using ODBC? If so any advice on how-to would be very helpful. Regards Nikolaj
You can read/write data through ODBC, but not change the structure of the database. Navision is keeping track of the tables in other ways also, and you will have to make your changes within Navision to make it work. Can’t think of any reason to create a table from outside either. John
There are a lot of reasons for creating new tables, especially for storing temporary calculations inside the database instead of transferring data on a slow network line. However, CREATE TABLE is fully documented (see page 58 in the C/ODBC manual), so I keep the faith that Navision actually will allow me to create a table - if only I find out how. Nikolaj
I had a similar problem. I had to export some data to DBF file. But I’ve found a nice solution. Some guy is suggesting DLL (it’s name is modbf.dll), which can create, erase and compact DBF’s. It’s freeware. It works with VBA, but I can’t import it into NF. System says, that it was imported, but nothing new appears in the list.
Sounds interesting. Although I am not sure I can see the connection to CREATE TABLE? But some further information about the DLL and where to find it would be useful.
You must register DLL in your VB project. After that new class DBF appears: Set d1 = New Dbf d1.AddField “ID”, “N”, 10, 2 d1.AddField “Name”, “C”, 20, 0 d1.AddField “BirthDate”, “D”, 8, 0 d1.AddField “HaveSalary”, “L”, 1, 0 d1.Create (“C:\new.dbf”) Also there are other useful methods: MOVE; APPEND, DELETE, COMPACT etc. Help is in Russian :), but there is nothing useful except list of methods and mail of the author.
You must register DLL in your VB project. After that new class DBF appears: Set d1 = New Dbf d1.AddField “ID”, “N”, 10, 2 d1.AddField “Name”, “C”, 20, 0 d1.AddField “BirthDate”, “D”, 8, 0 d1.AddField “HaveSalary”, “L”, 1, 0 d1.Create (“C:\new.dbf”) Also there are other useful methods: MOVE; APPEND, DELETE, COMPACT etc. Help is in Russian :), but there is nothing useful except list of methods and mail of the author.
Hi Is this modbf.dll available somewhere? I’m not able to find it anywhere. Thanks in advance Andreas L.