How To Display <empty> Text When The Value Is Empty Or Null In Db S’abonner

0
Avatar
Legacy Poster

Hi All,
Is there any way to handle "" or NULL value in db can be represented as <Empty> text on the label by default with out writing any VB script. Why i am asking is in Label Matrix which we used before there is an option implicitly to hande NULL values and display them as <Empty> but here i have not found any option like that so i am handling it through script for each and every field on the label. Let me know if there is same option here or else should i follow VB script.

Thanks,
Phaneendra

9 commentaires

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

So when the field is empty you want the data of the object set to "<Empty>"?

For this you will need to use an OnProcessData VB Script via the "More Options" dialog.

[code]
If value = "" Then
value = "<Empty>"
End If
[/code]
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

[quote name='Ian C - Seagull Support' timestamp='1323782199' post='1312']
So when the field is empty you want the data of the object set to "<Empty>"?

For this you will need to use an OnProcessData VB Script via the "More Options" dialog.

[code]
If value = "" Then
value = "<Empty>"
End If
[/code]
[/quote]

Yes Ian i am doing the same thing now through vb script, i would like to know weather there is any way to handle it without writing script for each and every field placed on the label. I mean is there any option that will display <empty> tag by default with out writing any script.

Thanks,
Phaneendra
0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

No there isn't. You need to use VB script.
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

[quote name='Ian C - Seagull Support' timestamp='1323782712' post='1315']
No there isn't. You need to use VB script.
[/quote]

Its ok, thanks for clarification.
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

When the value is empty or null in the Db how I can just not print this field with his preffix in the label ?
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

my problem is that in some times this field has value in other times has not
0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

I suggest you use a separate sub-string for the prefix instead, and perform the conditional VBS statement on each.
0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

Alternatively, if you have v9.40 you can dynamically change the object properties to set the whole object not to print. See the white paper below and the BarTender Help System for more information.

http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_DynamicallyChangingObjectsAtPrint-TimeUsingVBScript.pdf
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

I have the v.9.2SR2 so I will try your first proposal

Vous devez vous connecter pour laisser un commentaire.