/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 vote209 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote202 views1 answer
Xamarin sql lite create table if not exist
SQL
48 votes193 views3 answers
Psql create database
SQL
2 votes187 views2 answers
Sql query to copy data from one column to another
SQL
1 vote189 views1 answer
Postgresql datetrunc too slow
SQL
0 vote196 views1 answer
Add sqlcmd to path linux
SQL
2 votes198 views1 answer
How to insert string variable into sqlite database
SQL
0 vote197 views1 answer
Oracle sql developer closed connection
SQL
1 vote180 views1 answer
Set mysql mode global query
SQL
4 votes195 views1 answer
Add constraint fk
SQL