Control of rows in a Master/Details

Applications Forms
#1

Dear all,

I need to check that rows within a master/details form have to be controlled (number or other parameters).
For istance I need that the number or rows for a “date” must be unique (in order to do not have duplication for the same date).
Is there a trick ? I think to use SELECT (*) COUNT … WHERE but probably there is something smarter.
Thanks
Giovannino

#2

Re: Control of rows in a Master/Details

Hi Giovannino.
One suggestion: I’ve seen you use for your solutions SELECT COUNT (*) to identify if there are records of something. Instead I recommend to use: SELECT COUNT (1), thereby improving performance and response time.
Regards.
JG

#3

Re: Control of rows in a Master/Details

OK thanks for suggestion.