Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (5)

Resolved Wrong empty picture field value

  1. Roger
    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.
Responses (5)
Sergey Pashkov
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.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Sergey Pashkov
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.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
Roger
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)
Annotation 2020-08-22 132012.png Annotation 2020-08-22 132012.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 3
Sergey Pashkov
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.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 4
Roger
Roger Accepted Answer
Ok, thanks Sergey.

Have a nice weekend.
Roger
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 5
  • 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