Access Input Variable SQL to MS Access Project ????

A

abaxt

Joined
Jun 8, 2005
Messages
5
Reaction score
0
Hi

I am just starting out on SQL and I'm builbing a SQL database with MS Project front end.
Within Project I have a form that references a table with customer details on it and I have written a small piece of SQL code that will bring back customer details if I manually pass the command
exec stp_find_customer home

this will bring me back all the customers with home in their names on my SQL database but I want the results to display on a form within MS Project. Is there anyone that can point me in the right direction of setting this up ????

My procedure code is listed below;
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE find_customer @cust_name char(20)
AS
SELECT @cust_name = RTRIM (@cust_name)+ '%'
SELECT c.cust_name, c.cust_num
FROM tbl_customer_master_file c
WHERE c.cust_name LIKE @cust_name


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


I'm really new to the programming side of things so please point me in the right direction if any of the code should be re-written a bit differently.

Many thanks
Regards
Angie
 
Back
Top