Ask a Question related to ASP Database, Design and Development.
-
James #1
Trigger
I have three tables:
class - table of classes
----------
classID
className
classtypeID
classtype - table of class types
--------------
classtypeID
classtype
desc
ctrlClass - control table to combine class and class type
-----------
classID
classTypeID
Say a person adds a class through an ASP page with these
values:
2,'Intro to Computers', 1
Can a trigger automatically fire and add these values to
the ctrlClass table after it adds the above record to the
class table?
2,1
Or will I have to incorporate that into my stored
procedure? Any help would be appreciated.
James Guest
-
XML.TRIGGER
Hello. I have an XML connector that I'm using a tigger event on. I was wondering if anyone knows a way for me to check when this completes. I... -
Events don't trigger
In my C# code I am finding all of the open IE windows in a loopand assigning their HWND to an object or this: ... -
An trigger question
Hi,all: I want to create some trigger on an important database,my database is IDS2000. My question is: If exist a way to limit me only can create... -
Trigger Help
I have a trigger (code below). Where do I put in IF statements to kick off the CASE? I put in a commented out example of the IF I want to do in... -
Trigger key
Hi, I need to create a insert trigger so that when a new row is inserted in table A then the same row is inserted in table B on a remote server.... -
Pawel Janowski #2 Re: Trigger
"James" <anonymous@discussions.microsoft.com> wrote in message
news:0df201c47b1e$54982930$a401280a@phx.gbl...find in (BOL) books online : from inserted> I have three tables:
>
> class - table of classes
> ----------
> classID
> className
> classtypeID
>
> classtype - table of class types
> --------------
> classtypeID
> classtype
> desc
>
> ctrlClass - control table to combine class and class type
> -----------
> classID
> classTypeID
>
> Say a person adds a class through an ASP page with these
> values:
>
> 2,'Intro to Computers', 1
>
> Can a trigger automatically fire and add these values to
> the ctrlClass table after it adds the above record to the
> class table?
>
> 2,1
>
> Or will I have to incorporate that into my stored
> procedure? Any help would be appreciated.
-------
Pawel Janowski
[url]www.sunrise-tm.com[/url]
[url]www.koluszki.net[/url]
Pawel Janowski Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
