Extended Procedures question
-
If I create and XP, and I want to connect to my XP. How do I go about doing that? Will i do an execute from my app? Right now I do all my selects and updates using a connection pointer like this: m_pConnection->Execute(_bstr_t(mySelect),NULL, NULL); Will I also connect to my XP this way? I'm making an XP that will alert me to a trigger in a table that I have set. So that any new record placed in there will alert me so that I do not have to loop every 3 seconds to see if there's new data. Thanks Tom Wright tawright915@yahoo.com
-
If I create and XP, and I want to connect to my XP. How do I go about doing that? Will i do an execute from my app? Right now I do all my selects and updates using a connection pointer like this: m_pConnection->Execute(_bstr_t(mySelect),NULL, NULL); Will I also connect to my XP this way? I'm making an XP that will alert me to a trigger in a table that I have set. So that any new record placed in there will alert me so that I do not have to loop every 3 seconds to see if there's new data. Thanks Tom Wright tawright915@yahoo.com
As far as TSQL is concerned, an XP is the same as a normal SP. If you can execute SPs using this method (I don't see why you can't), then you should be able to execute XPs also.
-
As far as TSQL is concerned, an XP is the same as a normal SP. If you can execute SPs using this method (I don't see why you can't), then you should be able to execute XPs also.
cool I'll try it. Just gotta write my XP and find out how to return a value. I'm going to assume that, that is the same as SP's too? Thanks Tom Wright tawright915@yahoo.com
-
cool I'll try it. Just gotta write my XP and find out how to return a value. I'm going to assume that, that is the same as SP's too? Thanks Tom Wright tawright915@yahoo.com
I've written an article about XPs (http://www.codeproject.com/database/extended_sp.asp[^]). You may find this helpful.