SQL Request value validation

Have you tried just saying not(Customer Existing)? Or Customer Existing == ""?

Since it's a selection field (even though it's populated by SQL), I believe the 'Select a Value' is only the displayed text and not the actual value that's used to test against.

Thanks chaddavis

the vallues in the sql boxes do not appear to be coming through as strings and when I try to query the value, it alwas comes back as blank so I can't get a rule to do anything with it. I gave up on this.

Thanks anyway.

I'm sorry I wasn't able to help more. 

If you would like to continue looking into it, I would suggest posting some print screens of the form, its fields, and even your rules. It wouldn't hurt to even do an Inspect in the browser on the selection field to see what's being populated as the value vs text of each option.

hi guys , i had the same problem and I fixed it with a trick, I add to the responsive form a label control without any title or text, just empty and in the rules I created the validation rules for the SQL database in this label control and it works!!!!, when I submit the form if the SQL request control is empty the the label triggers the validation and the user can't save the form.

then I put the label control just below the SQL control so when the error message appears to look like is from the SQL control because the label control is empty without any text to show.

My rule : and( isNullOrEmpty(ItemDescriptionSQL) , not(IsNewItem)) 

IsNewItem is a Yes/No control

thank you