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

Gelöst Wrong empty picture field value

  1. Roger
    Roger
  2. as Valentina DB Server
  3. Freitag, August 21 2020, 09:45 PM
  4.  Abonnieren via E-Mail
Hello

If I read a picture field in the Valentina db it is ok, the next Cursur pos I read, the picture on the db is empty (0 bytes) but the cursor give me the value from the picture readed before.

Is this the same problem we have in the report ? Or its any thing I make wrong?

Regards Roger

(Xojo with 10.4.20)
Kommentar
There are no comments made yet.
Antworten (5)
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hello Roger,

No, it’s something else.
Thank you, we’ll check it soon.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as Valentina DB Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
I can reproduce it with Valentina Server connection.
What about the IsNull method? For me, it is true for an empty field
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as Valentina DB Server
  3. Permalink zu dieser Antwort
Roger
Roger Akzeptierte Antwort
Thanks Sergey

If ModellCursor.PictureField("BildFront";).Value.IsNull Then
- is every time False

If ModellCursor.Field("BildFront";).DataSize > 0 Then
- had every time a value > 0

If ModellCursor.Field("BildFront";).ISNULL Then
- this works.

I need it to work with field, can not use PictureField....
Anhänge
Annotation 2020-08-22 132012.png Annotation 2020-08-22 132012.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as Valentina DB Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Yes, it is better to always check if a field is not null before getting the value, so it is correct:


If ModellCursor.Field("BildFront").ISNULL Then


We'll recheck why the previous value is not cleared when the server is used (probably it is some optimization).
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as Valentina DB Server
  3. Permalink zu dieser Antwort
Roger
Roger Akzeptierte Antwort
Ok, thanks Sergey.

Have a nice weekend.
Roger
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as Valentina DB Server
  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.

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