Sunday, January 13, 2008

If None(NS_ONB_PERS_STG.ADDRESS1, NS_ONB_PERS_STG.CITY, NS_ONB_PERS_STG.STATE, NS_ONB_PERS_STG.POSTAL) Then
&address = "empty"
Else
If None(NS_ONB_PERS_STG.ADDRESS1) Then
Error MsgGet(0, 0, "Please fill in Address line 1 ...");
End-If;
If None(NS_ONB_PERS_STG.CITY) Then
Error MsgGet(0, 0, "Please fill in the City ...");
End-If;
If None(NS_ONB_PERS_STG.STATE) Then
Error MsgGet(0, 0, "Please fill in the State ...");
End-If;
If None(NS_ONB_PERS_STG.POSTAL) Then
Error MsgGet(0, 0, "Please fill in the Postal Code ...");
End-If;
End-If;

No comments: