1. Roger
  2. Valentina Database ADK
  3. Среда, Август 05 2020, 01:43 AM
  4.  Подписаться через email
Hello

In this (your) example all runs fine, only I have no pictures in the API_Field_Picture.vdb.

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
Комментарий
There are no comments made yet.
Roger Ответ принят
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
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Roger,

What ADK is used? Xojo or LiveCode?
Комментарий
There are no comments made yet.
Roger Ответ принят
Xojo, 10.4.18 on WIndows 64
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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.
Комментарий
There are no comments made yet.
Roger Ответ принят
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)
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories