Data Connections

Re: Verify if data entered from a form already exists in the database

gt1021 — Wed, 23 May 2007 18:16:39 GMT

Thanks again for the quick reply. Everything works fine now.

Re: Verify if data entered from a form already exists in the database

Clay Fox — Wed, 23 May 2007 18:10:58 GMT

you would just do whatever logic you needed in your form. I would probably reject their input and reset the field when a duplicate is detected but you could also pop an alert and use conditional formating to disable submit.

If you are using the toolbar submit, I would use validation. You could use an existing field or create one just for this purpose.

Re: Verify if data entered from a form already exists in the database

gt1021 — Wed, 23 May 2007 18:00:41 GMT

Thanks, your View suggestion did work correctly and give me an error message if the Data is duplicated, but it still allows me to Submit the form. is there a way to dissable the submit button if the error message appears?

Re: Verify if data entered from a form already exists in the database

gt1021 — Wed, 23 May 2007 17:12:45 GMT

Thanks for the reply. I am supposed to finish this project without the use of webservices, will the 2nd view suggestion permit this? or do i need to use webservices?

Re: Verify if data entered from a form already exists in the database

Clay Fox — Wed, 23 May 2007 17:08:40 GMT

Welcome to the forum.

You would need to query the database with a secondary data connection. I would create a view in SQL that just showed the field you need to check. Then in your form you can have a rule check this data connection if there is a duplicate when data is entered by the user.

If you are working with databases a lot you should check out the Database Accelerator Webservices Download. It makes working with databases much easier and removes the limitations of database type forms.

Qdabra Database Accelerator Suite Version 2.0 - Developer

Verify if data entered from a form already exists in the database

gt1021 — Wed, 23 May 2007 16:12:28 GMT

Hi,

I would like to know how to verify if a certain field already exists in a table before I submit it to a database. I would like to make sure there are no duplicate names. Thanks