J.M. ' If you are using a form just restrict any user from making any changes or entries by making sure the Field settings are not checked in the Form designer. I hope this is of some help to you.
RAStarkey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of J.M. GRATIAS Sent: Saturday, February 23, 2002 7:00 PM To: Rbase List server Subject: Looking for a rules Hi all, I have a table that contains the components for a receipt. Each row contains 3 columns : Receipt TEXT (8) Component TEXT (8) Weight_Percentage DOU Example : 'Cake','Egg',10. 'Cake','Butter',25. 'Cake','Flour',50. ... and so on. I am looking for a rule able to prevent user to enter new rows or change existing rows such as the sum of Weight-Percentage stay less or equal to 100 % I tryed : RULES 'Receipt incorrect' FOR composition SUCCEEDS + WHERE (100 -Weight_Percentage) >= (SELECT SUM(Weight_Percentage) FROM composition T1 + WHERE T1.Receipt = composition.Receipt) and RULES 'Composition incorrecte' FOR composition SUCCEEDS + WHERE Receipt NOT IN + (SELECT Receipt FROM composition GROUPED BY Receipt + HAVING (SUM(Weight_Percentage) > 100)) without any success .... Suggestions are welcomes .... TIA J.M. GRATIAS, Logimatique, France ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
