Hello

In this (your) example all runs fine, only I have no pictures in the API_Field_Picture.vdb. (in folder API_way but is the same on SQL_way)

I see in the debuger, I have the 3 pictures, all comands are done inclusive the flush. At end I have the db with the table and the field but all fields are empty.

Is the same in debug mode as in the compiled mode. The comands show good as I can see in the helps. But whan can be the problem?

Regards Roger

Hello Roger,

What ADK is used? Xojo or LiveCode?

Xojo, 10.4.18 on WIndows 64

Hi Roger,

well, will be a long story

1) This example works on Mac but broken on Windows.
The first issue - because on Windows Xojo now creates a sub-folder with MyAppDebug.exe, so pictures are not visible.

FIXED adding in this project "Windows - Build Step - Copy Files"
The same made for other Picture examples and TestProject.

2) After this fix, we have found another issue.
At some point, Xojo have changed the format of Picture which goto plugin.
In the past, it was DIB, not another format.
Maybe this is related to Win10 or Win64

We need to learn it and find a way to compress it to JPG.


3) Anyway you have simple and consistent way for 3 OS - compress into JPG using Xojo itself.

Var mb As MemoryBlock = pic1.ToData( Picture.Formats.JPEG ) // XOJO do job to convert to JPG

pic1 as Picture
mtbl1.SetBlank
fldPic.WriteData( mb )
rec = mtbl1.AddRecord()
mdb.Flush

ATTN: example use API, but can be used SQL of course.

Thanks Ruslan, I go to try it the next days, because one of my next programs have about 2500 pictures (as jpg) to save and show in the program (and on reports).

The false path I had see in the debugger and corrected it. In the debugger I had see too the pictures was loaded in the field correct, only not saved.

Can I save its in the vData Type picture or is bether a blob - or are this too much and it bether to save it external?

(My system is Wind10, 64Bit)