[DBF] Read/Write DBF file using jDBF
[DBF] Reading Visual Foxpro DBF using JDBC
Since you never asked me about the difference between the both
Code Snippets above, I assume you have read the details.
However, please let me point out again some important points.
1. Both solutions are B4J projects
2. It is not meant to work straight away in B4A
3. They are depends on third party Java libraries which access through JavaObject
4. The first snippet is simple as it only depends on one library. The drawback is it doesn't support some column types such as datetime field.
5. The second snippet is more complicated as the jdbc driver provided by dbschema requires H2 library. It depends on 3 third party libraries. What the driver actually do is, it created a clone of the original dbf file into a cache. Any SQL query or command operations doesn't have effect to the original dbf file. To write back the changes, you may also need to use JavaObject to execute a command as stated in the Github readme. (I think many wouldn't have read it)
Statement st = connection.createStatement();
st.execute("save dbf to <folder_path>");
At that time I shared the snippets, I was creating a POC for a potential customer. So I only focus on reading the data out of the DBF file. Very unfortunate, I didn't get the project.