/SQL/Sql stored procedure for access frontend

Sql stored procedure for access frontend

CREATE PROCEDURE getContact 
    -- Add the parameters for the stored procedure here
    @id int = 1
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT * FROM myContacts WHERE ID=@id
END

Source: stackoverflow.com

Sql stored procedure for access frontend

Sub spTest()
Dim qdf As DAO.QueryDef, rst As DAO.Recordset
Dim IdValueToProcess As Long

IdValueToProcess = 2  ' test data

Set qdf = CurrentDb.CreateQueryDef("")
qdf.ReturnsRecords = True
qdf.Connect = "ODBC;DSN=myDb;Trusted_Connection=Yes;"
qdf.SQL = "EXEC dbo.getContact " & IdValueToProcess
Set rst = qdf.OpenRecordset(dbOpenSnapshot)

Debug.Print rst!LastName  ' just to make sure we got a result

rst.Close
Set rst = Nothing
qdf.Close
Set qdf = Nothing
End Sub

Source: stackoverflow.com

Similar codes

8 votes330 views1 answer
My sql version
SQL
0 vote319 views1 answer
Add mysql database to power bi web
SQL
0 vote306 views1 answer
Sql alter table order by
SQL
0 vote307 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote322 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
11 votes328 views3 answers
How to get last row of table in sql
SQL
20 votes310 views3 answers
SQL query rename table
SQL
0 vote318 views1 answer
Const pool = mysql.createpool()
SQL
0 vote251 views1 answer
Mysql select top 2
SQL
0 vote311 views1 answer
Sql comand for removing data from table
SQL