Two questions

Scriptcase 7 Discussion
,
#1

Hello,

  1. Is there any inbuilt method to check duplicate entries. The form should prevent duplicate entry

  2. How to refer form fields in macro. For example, to verify content of a form field with a table and notify the result

Thanks

#2

[QUOTE=omonm;27168]Hello,

  1. Is there any inbuilt method to check duplicate entries. The form should prevent duplicate entry

  2. How to refer form fields in macro. For example, to verify content of a form field with a table and notify the result

Thanks[/QUOTE]

  1. If you design your database correct then it will not be possible to enter duplicate values as the database will refuse that (you get an errormessage). Just define your primary key ok.
  2. Verification of fieldinformation can be done in different ways. By reference, which is a matter of defining the field as a look-up and make the field required (will force that a correct value will be selected). Other option is to add code to the onvalidate event. Formfields can be accessed by putting them between {}, i.e. {myformfield}. On error you can display the errormessage.
#3

For first questions SC has a way for do it.
Form Settings - Unique key : You define your fields.