Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aloadam
Starting Member
5 Posts |
 Posted - 2003-09-18 : 10:56:54
|
| Hi,How are you.Can you help me pleaseI would like to reference a "store procedure with a form"How can i do itThanks |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-09-18 : 12:30:25
|
quote:
I would like to reference a "store procedure with a form"
I'm assuming by that you mean something like........................Best way i've seen for executing a stored procedure is via a Passthrough query. i.e. create a passthrough query with something like Exec MyStoredProcedure variable1, variable2 etc in it. This will then obviously execute the SP and return a recordset or whatever.Search this site as i'm sure i asked this once upon a time.====Paul |
 |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-09-18 : 12:39:11
|
| If you are in an adp and want to base a form off a stored procedure, highlight the sp in the Stored Procedures window, click the Insert menu and choose Autoform.You can also design a form by hand and manually put the sp as the form data source.======Doug G====== |
|
|
|
|
|
|
reference between forms (ADP)