Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (16)

Gelöst printing reports with pictures from database when field is null it prints previous picture instead of nill o none

  1. jaume
    jaume
  2. Valentina Reports ADK
  3. Montag, September 23 2019, 05:22 PM
  4.  Abonnieren via E-Mail
Hello,

Printing reports with pictures stored in blob field, when blob is null, instead of print none or null, it prints previous picture
Kommentar
There are no comments made yet.
Antworten (16)
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
So the problem is solved in a new report?
If you still have an old report - can you attach it so we'll be able to analyze it?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
creating a new report it works ok
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
The result of sql statment returns null in the field camp that is a blob field containing the imag when no there is a image and it is correct. However, in the report insted of print null or empty, it prints the previous image.

runing the report from valentina studio it works fine.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
The result of sql statment returns null in the field camp that is a blob field containing the imag when no there is a image and it is correct. However, in the report insted of print null or empty, it prints the previous image.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
I've just installed the plugin and compiled, but kthe result is the same.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Direct link:
http://valentina-db.com/download/release/win_32/v4rb_9_win.exe
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
Where can I donload the lastest pluggin ?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Can't reproduce for now, even with the same version.
Can you try to compile with the latest version of plugin?
If an update doesn't help/not possible - a small example database and project reproducing this issue would help.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
The release is 9.1.5
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
And the version of V4RB plugin is 9.6, or?

You can check it in the properties of, for example, vreport_...dll
Anhänge
Screenshot 2019-09-27 20.36.06.png Screenshot 2019-09-27 20.36.06.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
Xojo on windows

the sql that is send to the report is :
SELECT CONCAT (a.NOM," ",a.COGNOM1," ", a.COGNOM2) AS NOMX, YEAR(a.DATA_NAIXEMENT) AS ANYNAIXEMENT, a.* , b.camp
from v_participants a
left outer join blobs b on a.id = b.id_participant

images are stored in the table blobs
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hello Jaume,

So the problem only with Xojo application, on what OS is it running?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
Hello,

Sorry for the delay.

In valentina studio works fine.

The version is the last (right now) 9.6.1
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Unable to reproduce for now.

Can you reproduce it in the Valentina Studio?
What is the version of Valentina Studio?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
jaume
jaume Akzeptierte Antwort
Hello Sergey,

The database is Mariadb and version 13
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hello Jaume,

What database is used?
What version is used?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
  • Seite :
  • 1


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