1. 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.
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.
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.
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
Kommentar
There are no comments made yet.
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.
Roger Akzeptierte Antwort
Ok, thanks Sergey.

Have a nice weekend.
Roger
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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