FiveTech Software tech support forums • View topic - call vs callsp?

call vs callsp?

6 posts • Page 1 of 1

call vs callsp?

by goosfancito » Tue Dec 19, 2023 5: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/

goosfancito: Posts: 1954; Joined: Fri Oct 07, 2005 7:08 pm

Re: call vs callsp?

by karinha » Tue Dec 19, 2023 3: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

Posts: 7824

Joined: Tue Dec 20, 2005 7:36 pm

Location: São Paulo - Brasil

Re: call vs callsp?

by goosfancito » 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/

goosfancito: Posts: 1954; Joined: Fri Oct 07, 2005 7:08 pm

Re: call vs callsp?

by karinha » Wed Dec 20, 2023 11:40 am

goosfancito wrote:
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

¡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

Posts: 7824

Joined: Tue Dec 20, 2005 7:36 pm

Location: São Paulo - Brasil

Re: call vs callsp?

by karinha » 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

Posts: 7824

Joined: Tue Dec 20, 2005 7:36 pm

Location: São Paulo - Brasil

Re: call vs callsp?

by nageswaragunupudi » Tue Dec 26, 2023 3:17 pm

Code: Select all Expand view: oCn:CallSP( "procedurename", aParams )

aParams should be an array.

Code: Select all Expand view: 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

nageswaragunupudi

Posts: 10643

Joined: Sun Nov 19, 2006 5:22 am

Location: India

YIM

6 posts • Page 1 of 1

Return to FiveWin para Harbour/xHarbour

Jump to:

Who is online

Users browsing this forum: No registered users and 31 guests