Webdev and MS SQL stored procedure

Hi,

How easy it is to implement webdev and the interaction with the DB via MS SQL stored procedure?

I have no experience in running MS SQL stored procedure.

Regards,

Peter zhou

If you use the native access you can see some samples of the use of stored procedures in MSSQL in this help page [doc.windev.com]

Regards

Paulo Oliveira

Hi,

Is it possible to execute ms sql stored procedures without the native driver from windev/webdev (using ole db) ?

Regards,

Peter Zhou

Peter

try something like this where I run a procedure called SP_Journal with 3 parameters. I'm not sure how to retrieve a value from that procedure.

ds1 is Data Source
sSQL is string
bResult is boolean

sSQL = StringBuild("EXEC " + "SP_Journal %1, %2, %3 ", "Test1",123,2)
bResult = HExecuteSQLQuery(ds1,gctYourConnection,hQueryWithoutCorrection,sSQL)

Arie

ArieM Wrote:
-------------------------------------------------------
> Peter
>
> try something like this where I run a procedure
> called SP_Journal with 3 parameters. I'm not sure
> how to retrieve a value from that procedure.
>
> ds1 is Data Source
> sSQL is string
> bResult is boolean
>
> sSQL = StringBuild("EXEC " + "SP_Journal %1, %2,
> %3 ", "Test1",123,2)
> bResult =
> HExecuteSQLQuery(ds1,gctYourConnection,hQueryWithoutCorrection,sSQL)

Hi Arie,

Thank you for the sample code, I got it working.

Hi,

How to execute insert stored procedure with the following in windev

INSERT_ITEM @CODE, @ITEMNAME

ds1 is date source
sSQL is string = stringbuild("EXEC INSERT_ITEM %1, %2", "ABC","Item ABC")

HexecuteSQLQuery(ds1, "MyConnection",hQueryWithoutCorrection, sSQL)


Returns OLE DB access error 170129

Peter,

I think you need single quotes around ABC and Item ABC

Otherwise the statement is interpreted wrong resulting in an error.

Arie

ArieM Wrote:
-------------------------------------------------------
> Peter,
>
> I think you need single quotes around ABC and Item
> ABC
>
> Otherwise the statement is interpreted wrong
> resulting in an error.

Hi Arie,

ds1 is data source
sSQL is string = stringbuild("EXEC INSERT_ITEM %1, %2", " 'ABC' "," 'Item ABC' ")
HexecuteSQLQuery(ds1, "MyConnection",hQueryWithoutCorrection, sSQL)


With the single quotes around 'ABC' and 'Item ABC' , it still return same error code.


Regards,

PETER ZHOU

Did you try with:

sSQL is string = stringbuild("EXEC INSERT_ITEM @CODE=%1, @ITEMNAME =%2", "ABC","Item ABC")

Regards

Paulo Oliveira