Wrong empty picture field value

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

ログインを記憶

パスワードを忘れましたか？

解決済み Wrong empty picture field value

Roger
as Valentina DB Server
金, 8月 21 2020, 09:45 PM
メールで購読

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)

There are no comments made yet.

返信 (5)

Sergey Pashkov 承諾済みの回答

Hello Roger,

No, it’s something else.
Thank you, we’ll check it soon.

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

I can reproduce it with Valentina Server connection.
What about the IsNull method? For me, it is true for an empty field

There are no comments made yet.

Roger 承諾済みの回答

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....

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

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).

There are no comments made yet.

Roger 承諾済みの回答

Ok, thanks Sergey.

Have a nice weekend.
Roger

There are no comments made yet.

ページ :
1

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

返信するにはログインしてください

投稿するにはログインする必要があります。右側のフォームからログインするか、新規アカウントを作成してください。ここで登録 »

パスワードを忘れましたか？

解決済み Wrong empty picture field value

Categories

Developer Network

Reports for...

Forms for...

Support

Company