/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 vote342 views1 answer
Mysql current time
SQL
1 vote339 views1 answer
Sql sort column by date
SQL
0 vote383 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote328 views1 answer
Find largest table in mysql database
SQL
0 vote449 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote375 views3 answers
Mysql keyword search
SQL
0 vote344 views2 answers
Postgresql change user role grant
SQL
1 vote313 views1 answer
Find logged in users mysql
SQL
0 vote328 views1 answer
Uncomment listen_address=localhost
SQL
0 vote374 views3 answers
Java hide mysql login credentials
SQL