B4J Question Reading Visual Foxpro DBF MEMO field using JDBC (B4J)

[Sergio Barbosa de Souza]

Hello, what is the correct way to read a MEMO field stored in a Visaual Fox Pro database, can someone give an example in B4J? Thanks.

 

[aeric]

You should post in question forum.

Here are what I shared last time:

[DBF] Read/Write DBF file using jDBF

https://www.b4x.com/android/forum/threads/aceesing-dbf-files.47068/ The example above works but the characters are not displaying correctly. With some trial-and-error, I finally get it works like the Test.java 'Non-UI application (console / server application) #Region Project Attributes...

www.b4x.com

[DBF] Reading Visual Foxpro DBF using JDBC

This snippet demonstrates how to use FoxPro JDBC Driver to read DBF file. The driver read the DBF file and generate a H2 cache in C:/Users//.DbSchema/jdbc-dbf-cache/ Compare to jDBF driver, this driver can read more field types such as timestamp (T) or datetime, General, Memo and more...

www.b4x.com

 

[Sergio Barbosa de Souza]

Hello, thanks for the answer, I saw your great post, but I didn't find an example to use "cursor.getSting(field_MEMO)" or something like that.

 

[aeric]

Hello, thanks for the answer, I saw your great post, but I didn't find an example to use "cursor.getSting(field_MEMO)" or something like that.

Did you see this code?

Dim res As ResultSet = DB.ExecQuery("SELECT * FROM sample")
Do While res.NextRow
    Log($"id: ${res.GetInt("id")} | Name: ${res.GetString("item_name")} | Barcode: ${res.GetInt("barcode")} | Cost: ${res.GetDouble("avg_cost")} | Created: ${res.GetString("created_on")}"$)
    data.Add(Array(res.GetInt("id"), res.GetString("item_name"), res.GetInt("barcode"), res.GetDouble("avg_cost"), res.GetString("created_on")))
Loop
res.Close

Have you tried the project I shared with your own database?

 

[Sergio Barbosa de Souza]

Did you see this code?

Dim res As ResultSet = DB.ExecQuery("SELECT * FROM sample")
Do While res.NextRow
    Log($"id: ${res.GetInt("id")} | Name: ${res.GetString("item_name")} | Barcode: ${res.GetInt("barcode")} | Cost: ${res.GetDouble("avg_cost")} | Created: ${res.GetString("created_on")}"$)
    data.Add(Array(res.GetInt("id"), res.GetString("item_name"), res.GetInt("barcode"), res.GetDouble("avg_cost"), res.GetString("created_on")))
Loop
res.Close

Have you tried the project I shared with your own database?

Hello, I saw the code but when using Log(res.GetString("MEMO_field")) it comes in blank, I realized that dbf that use MEMO fields recorded in .FPT are difficult to visualize.

Sorry for my english, I use translator.

 

[aeric]

Try use GetString2 or GetBlob.

Upload a small sample dbf file for members to test.