/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

0 vote333 views1 answer
Longtext sql
SQL
7 votes288 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
9 votes361 views3 answers
Where clause sql
SQL
0 vote355 views1 answer
Mysql update all record removing 2 hours from column
SQL
2 votes327 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote330 views1 answer
Normalization in database 2nd normal form
SQL
0 vote360 views1 answer
Sql to search who modified
SQL
0 vote321 views1 answer
Equi joins in oracle
SQL
0 vote318 views2 answers
Postgresql get last day of month
SQL
7 votes336 views1 answer
Return insert results in POSTGRESQL
SQL