How To Display <empty> Text When The Value Is Empty Or Null In Db
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
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
0
-
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 -
[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,
Phaneendra0 -
No there isn't. You need to use VB script. 0 -
[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 -
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 -
my problem is that in some times this field has value in other times has not 0 -
I suggest you use a separate sub-string for the prefix instead, and perform the conditional VBS statement on each. 0 -
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.pdf0 -
I have the v.9.2SR2 so I will try your first proposal 0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
9 commentaires