SQL Function run from VBA (1 Viewer)

Tupacmoche

Registered User.
Local time
Today, 04:31
Joined
Apr 28, 2008
Messages
291
Hi Code Masters,

I have the following SQL function that, I would like to execute from Access vba code. Can someone give me direction. :confused: The function takes one parameter and checks the status of the code and returns active or inactive.

DECLARE @ret tinyint;
EXEC @ret = [dbo].[fn_JointFlag_Status]
@Donor_id_Number = 0009999999;
Select @ret as FlagStatus
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 04:31
Joined
Apr 27, 2015
Messages
6,331
Others more familiar with SQL Server can answer with the details, but I am fairly certain you will need a Pass-Thru Query to accomplish this.
 

Users who are viewing this thread

Top Bottom