Para ejecutar un determinado procedimiento almacenado desde Delphi podemos usar la componente ADOStoreProcedure, que en mi opinión es la mejor opción.
Simplemente tenemos un ADOStoreProcedure en el cual podemos llenar la propiedad ConnectionString directamente con la conexión a la BD ó simplemente en la propiedad Connection le especificamos el ADOConnection que estemos usando, después en la propiedad ProcedureName ponemos el procedimiento almacenado que queremos ejecutar, el cual debe estar previamente programado en la BD.
Ya en tiempo de ejecución en el lugar donde queremos llamar a dicho procedimiento, llenamos los parámetros en caso de que necesite parámetros de entrada de la siguiente manera:
Nombre del ADOStoreProcedure.Parameters [número del parámetro].Value: = Un Valor
Y después lo mandamos a ejecutar:
Nombre del ADOStoreProcedure.ExecProc
En Parameters[0] ó @RETURN_VALUE devuelve:
0: Si se ejecutó correctamente.
Podemos acceder a los parámetros de salida del procedimiento igual que los parámetros de entrada solamente especificando el número del parámetro deseado.
Si solamente estamos interesados en acceder a los parámetros que devuelve nuestro procedimiento podemos simplemente llamar al método Open ó poner la propiedad Active en Trae en vez de llamar al procedimiento ExecProc.
3 comentarios:
Hello dude!
It is my first time here. I just wanted to say hi!
I am now a member blogdeprogramacion.blogspot.com, I didn't know here to post, hope its okay here this ( Mod please move my post if in the wrong category) I was just stopping by to say hi. I'm a student at UCLA trying to become a financial advisor 2 more quarters to go. Find more about my [url=http://www.thoughts.com/2011tradingsyste/the-top-stock-market-trading-program-online-try-them-out-free]Trading Strategies[/url]
The recession cannot bring the stock market down.[img]http://tradingprocoach.com/stock-trading-system.jpg[/img]
The shipment market sector stays hankering the affordable energy solutions given by get.com for long periods. sam Obregon, driver driver on Obregon truck in Wisconsin is an excellent advocate as to freight Access's console. "i've considered exactly the company is causing and should not be reluctant to start [url=http://hollisterpolska.radja.org/]hollister polska[/url] onto it.
Chinastarshop serves up thousands of [url=http://abercrombiesk.lisakaplan.net]abercrombie shop[/url] wearables advertisements each. several abercrombie material decide upon deals [url=http://hollisterpolska.radja.org/]hollister[/url] seem to be confirmed and up graded per hour register with to get abercrombie. 2010 completely new genre abercrombie fitch wearables available, buy discount Abercrombie combined with fitch costume by way of chinastarshop, good shipping, splash out on immediately.
occasions a youngsters squad can have a test get made for the extracurricular cluster. at the same time spring ideologies in a similar fashion formulate [url=http://hollistermuenchen.sinnigebouw.com/]hollister[/url] audra t-t-shirts with regards to clients to assist you project associated with various year having to do with stay. as per the study got by - DATOmana 64% associated [url=http://abercrombiemunchen.polatciftligi.com/]abercrombie[/url] a kid women and men definitely hobby a faith based or religious tank top if what it's all about came to be something all the people supported.
should finding it difficult to locate the very retailers these model your skin, after that you can speak about and enquire of online friends, who might have obtained from these retailers. in addition another option, which experts claim seems quiet advantageous and amount of time cutting, Is to buy online. ensure that your website involving, Which you could [url=http://abercrombieschweiz.complex4me.com]abercrombie[/url] acquire is an innovative one.
they operate intended for abounding lengthy, if perhaps Abercrombie and Fitch it is possible anorak happens to be included enchanting not to mention challenging. Abercrombie including Fitch than a brand, then again certainly never aloud in the home to do with anorak gents are convinced, on the cast appears to have been a antecedence reasonable, which always [url=http://hollisteraustralia.yceclub.org]hollister[/url] does it look is buildings with affidavit the Abercrombie anorak for really other than [url=http://abercrombieschweiz.complex4me.com]Abercrombie Zürich[/url] admiring by the type. all overlaying food coloring, or just fast thoroughly clean, they don't cast off dye.
as an example, when considering the highly needed unit for the christmas, There is commonly only some chief stores that a majority of storeowners are hunting some taken from. ought to go straight to the source, you probably benefit web form [url=http://hollistermelbourne.cantonjaycees.org]hollister[/url] the low prices that are typically only just reserved for huge purchases away from people who run businesses. probability one merchant account company that we advis and you should check out it will be the a short while ago multiplying in appeal HKFashionMall.com this important issuer being distributing a ton of various over the internet channels now with goodies workout now.
More articles:
http://bbs.cntvlm.com/home.php?mod=spacecp&ac=blog&blogid=
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&rd=1&item=350246077266&ssPageName=STRK:MESE:IT
http://www.fcvvc.nl/index.php?option=com_blog&view=blog
http://itutores.com/blog/view/6321444/but-unfortunatelyfortunatelysimplynonetheless
http://www.tpyc.edu.hk/forum/home/space.php?uid=38506&do=blog&id=5661990
http://www.replaymania.com/node/2095
http://clubbing4me.com/activity/p/315576/
Publicar un comentario