How to Run a MS SQL Store Procedure and get the Value from it to a Variable

Hello everyone and Thank you in advance for the Help

I have this stored procedure inside a Microsoft Sequel Database which gets me the Date and Time of the Server.

Name of the Procedure: Get_The_Date_And_Time

Structure of the Procedute

CREATE PROCEDURE dbo.Get_The_Date_And_Time
AS
BEGIN
/* Procedure body */
DECLARE @Date_And_Time as date SELECT Date_And_Time = GETDATE();
END

The result of the Procedure if executed is the following:
Under the Column Name "Get_The_Date_And_Time" The result is the Following

2/8/2021 8:10:19 PM <-------- This is the Date and Time of the Server when the stored procedure is Executed

My question is: How can I run this store procedure from within WinDev or WebDev and put the result in a Variable, for Example varServerDate.

I have tried different things HExecuteProcedure() This does not work with ODBC Connection
I Have tried with HExecuteSQLQuery Get errors
I have tried SQLExec got errors too

Nothing works

I would really appreciate it you can give me a hand on this and perhaps a code Example can be provided since I have no clue where to start.

Thank you so Much

Best regards,
Carlos



Edited 2 time(s). Last edit at 02/09/2021 02:43AM by MPD_For_Life.

Hi we use that all the time. It is not realy complicated. I will see If I can get you some code . I can not copy past as the software is commercial stuff. ok

It is quite easy so no worries . I will get back at you as i will have to look at the source and make a bit of code for you ( none tracable to hou software . Ok


regards

Renko

PS PCSoft help should be able to help you out as well

Ok here goes,

You make a new connection and execute it see below:

datasourcemyprocedure is Data Source

if hopenconnection( your connectionvar) then
Hcanseldeclaration(dsMyProcedure)

IF HExecuteSQLQuery(dsMyProcedure,"MyConnection", hQueryWithoutCorrection, "dbo.sp_yourstored procedure @o_RKey out") THEN

//.o_RKey out is the variable you are gettting out of you sp
the key = dsMyProcedure.o_RKey out

hclose(dsMyprocedure)
Hcloseconnection(your connectionvar
else

end