If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Delphi, C etc > May (or CAN) I use triggers ?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-06-03, 11:29
ralf_davi ralf_davi is offline
Registered User
 
Join Date: Oct 2003
Posts: 5
May (or CAN) I use triggers ?

I need to call a procedure/function in VB when my DB is modified
with insert, update or delete. I know that its possible to do
something called Trigger, put how can my Triggers (in SQL Server or
MSDE) call a procedure in VB ?

Just to understand, this database catch information of users
connected to a support chat and I need to know when this user get
logged in (thru the rows of my table). When I notice that a new user
have logged in, I need to support him.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 10-17-03, 11:32
vextout vextout is offline
Registered User
 
Join Date: Jan 2003
Location: New York
Posts: 160
just to clarify soomething,

Trigger gets activated when something happens to the table (form sql server), you don't do it manually.

Therefore, you don't put call trigger in vb.

If i understand you correctly, you want a trigger to call a vb procedure ?

Is the vb app already running ?
When you say "support him", you mean you are using vb to chat ?

I have an idea what you need, i just need a little more information.
__________________
Beyond Limitation
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On