topic-44033

goosfancito

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

call vs callsp?
Posted: Tue Dec 19, 2023 05:31 AM

Hola.
Cual es la diferencia entre llamar a un procedimiento almacenado usando
call
y usando
callsp

gracias.

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

karinha

Posts: 8523

Joined: Tue Dec 20, 2005 07:36 PM

Re: call vs callsp?
Posted: Tue Dec 19, 2023 03:11 PM

CALLSP??

https://hmgforum.com/esgici/vivaclipper.wordpress.com/2013/07/18/c5_call/index.html

Regards, saludos.

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

goosfancito

Posts: 1956

Joined: Fri Oct 07, 2005 07:08 PM

Re: call vs callsp?
Posted: Wed Dec 20, 2023 11:23 AM

karinha wrote:CALLSP??

https://hmgforum.com/esgici/vivaclipper.wordpress.com/2013/07/18/c5_call/index.html

Regards, saludos.

Hola Karinha, si "callsp" se usa para los procedimientos almacenados en mysql, está el call y el callsp

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

karinha

Posts: 8523

Joined: Tue Dec 20, 2005 07:36 PM

Re: call vs callsp?
Posted: Wed Dec 20, 2023 11:40 AM

goosfancito wrote:
CALLSP??

https://hmgforum.com/esgici/vivaclipper.wordpress.com/2013/07/18/c5_call/index.html

Regards, saludos.
Hola Karinha, si "callsp" se usa para los procedimientos almacenados en mysql, está el call y el callsp

¡Ah ok! No uso MySql, así que no sabía que existía el comando.

Gracias por la info.

Regards, saludos.

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

karinha

Posts: 8523

Joined: Tue Dec 20, 2005 07:36 PM

Re: call vs callsp?
Posted: Wed Dec 20, 2023 11:44 AM

Interesante:

https://www.asprunner.com/forums/topic/21647-how-to-call-a-mysql-stored-procedure-with-output-parameters/

https://www.sqlshack.com/learn-mysql-the-basics-of-mysql-stored-procedures/

Regards, saludos.

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: call vs callsp?
Posted: Tue Dec 26, 2023 03:17 PM

Code (fw): Select all Collapse

oCn:CallSP( "procedurename",  aParams )

aParams should be an array.

Code (fw): Select all Collapse

oCn:Call( "function", aParams )
// or 
oCn:Call( "function", param1, param2, .... )
// or
oCn:Call( "procedure", aParams )
// or
oCn:Call( "procedure", param1, param2, ... )

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion