October 12, 2001 at 9:13 am
friends,
i have come up with one more question to clarify.....
i have got 3 tables machines, beverages and machine_beverages...
1. machine table has got machine_id, machine_name etc....
2. beverage table has got beverage_id, beverage_name
3. machine_beverage table has got machine_id, beverage_id, bev_key, gram_settings etc....
Now i have done the following programming for the data entry in 3 tables....
a. A data entry page for beverage table using ASP and stored procedure(SQL)
b. A data entry page for machines tables. This page receives the machine details and beverage settings for that machine and save it in corresponding tables.
if there are 5 beverages, it adds 5 entries in machine_beverage table when adding new machine to the machines tables.
In future, if new beverage gets added to beverage table, i want the SQL server to add beverage gram settings and beverage key (default to 0) in machine_beverage table for all the machines present in that.
I know this could be done using Trigger statement for the beverage table after every new insert.
could u please tell me how this trigger could be written
many thanks in advance
October 15, 2001 at 12:56 pm
Try and take a stab at it first...post the code you have and we can go from there.
October 15, 2001 at 10:19 pm
ok i will do that and come back...
thanks
thiru
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply