General

Re: Data Validation ?

AmyRayNai — Wed, 25 Nov 2009 15:48:46 GMT

Thanks for the response. What I ended up doing was made that field a unique one in sql. Easy enough.

Re: Data Validation ?

chhaya singh — Fri, 06 Nov 2009 06:16:22 GMT

Make a receive data connection for your sql table, Take one more textBox field and name it as result field and by default make its value false.

Then write a rule on you previous field. In rule conditition select a specific column from your sql table and then check if your sql table column contains your field value, If yes then set your result field values as true.

So now by your result field value you can know whether your entered text is already in the sql table or not.

Data Validation ?

AmyRayNai — Thu, 05 Nov 2009 19:00:31 GMT

Hi all. I'm starting to use IP 03. How can I verify that a value in a field is unique? Basically, making sure that the value being submitted isn't already in the sql table.