|
| [WB19] How to determine if $ field is empty |
| Iniciado por guest, 11,ago. 2015 21:20 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 11,agosto 2015 - 21:20 |
Hi all -
How can I determine if a Currency field in a database is empty? Not $0.00, but actually empty.
IF gpsdContact.cMembershipPaymentRate = Null THEN
iNeedUpdate = iNeedUpdate+1
END
Null Doesn't seem to work... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,agosto 2015 - 08:34 |
Maybe
cMembershipPaymentRate..EmptyIfZero = True/False
OR
You can in "Description of Items" check Null Authorized and default value=0 so you can
test Null. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 13,agosto 2015 - 22:06 |
hI jOEL,
IF gpsdContact.cMembershipPaymentRate..Null = True THEN
iNeedUpdate = iNeedUpdate+1
END
should work ... |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
204 mensajes |
|
| Publicado el 14,agosto 2015 - 14:56 |
Depending on the type of the field in the database.
For a field type money, I'm don't think you can have "" or empty value.
You onlye can have 0.00 or null.
For a varchar field you can have "0.00", "" and null. |
| |
| |
| | | |
|
| | | | |
| | |
|