/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

1 vote156 views1 answer
Show indices in mysql table
SQL
14 votes159 views3 answers
Delete all records from table except sql
SQL
6 votes157 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote163 views1 answer
How to find top 3 salary in sql
SQL
5 votes151 views1 answer
List foreign key oracle
SQL
3 votes163 views2 answers
Coalesce mysql
SQL
4 votes189 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote564 views2 answers
Zsh: command not found: mysq
SQL
0 vote175 views1 answer
Sql shell psql cannot enter password
SQL
2 votes181 views1 answer
Show max_allowed_packet mysql
SQL