Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-12 : 07:28:39
|
| Rajesh writes "I have a trigger for delete on a particular table that checks the validity of stock. If stock goes negative, I have a raiserror function that notifies the user for negative stock. This trigger works absolutely fine from SQL Server but it does not fire from the frontend (VISUAL BASIC 6.0). Please help me asap." |
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-03-12 : 10:37:16
|
| Hi,Pls confirm ur VB code having any Error Handler method or not. if u use this method, u can trap that back-end error messgae using this VB's "Err.Number" method.IT Knowledge is power |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-03-12 : 15:57:13
|
quote:
but it does not fire from the frontend ...
It might have fired, but the front-end might not have been able to capture the error. Look at the ADO Connection.Errors collection, it might have what you need.OS |
|
|
|
|
|
|
No response from Raiserror of SQL Server in Frontend VB