Events. Check if specific record exists

Check if specific record exists action uses Database API  to check if a Specific Value exists in the table.

Insert your code into the conditional statement instead of the comments to determine what happens if the Specific Value already exists or if it doesn't.

This action is available at any event except JavaScript onload events.

'**********  Check if specific record exists  ************
Dim rs,data
Set rs = DB_Query("select * from AnyTable where SomeColumn='Specific Value'")
doAssignmentByRef data, rs.fetchAssoc()
If bValue(data) Then
  ' if record exists do something
Else
  ' if dont exist do something else
End If

See also:

•Database API:Query()

•Database API: fetchAssoc()

•JavaScript API: getSelectedRecords()

•JavaScript API:getSelectedRecordKeys()

•Database API:Select()

•Update multiple records on the List page