Formulas and Calculations
How can I implement a unique "logical" key for a table? For example, I have an Ingredient table whose logical key is IngredientName. How can I ensure there is only one row with a given IngredientName?
Given two tables: Recipe and RecipeIngredient, I am trying to modify all rows in RecipeIngredient for a given IngredientName whenever the Recipe changes. I started by setting up a trigger with loop following the examples in your manual. I started the trigger with the following line of code:
For p in (select RecipeIngredient where IngredientName=”Carrots”)
I got the error: Unexpected symbol column 55
First, am I one the right track to do what I want? Second, what is the syntax error?