Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++,
I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
