1. Roger
  2. as Valentina DB Server
  3. Friday, August 21 2020, 09:45 PM
  4.  Subscribe via email
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)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Roger,

No, it’s something else.
Thank you, we’ll check it soon.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
I can reproduce it with Valentina Server connection.
What about the IsNull method? For me, it is true for an empty field
Comment
There are no comments made yet.
Roger Accepted Answer
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....
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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).
Comment
There are no comments made yet.
Roger Accepted Answer
Ok, thanks Sergey.

Have a nice weekend.
Roger
Comment
There are no comments made yet.
  • Page :
  • 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