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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy