A
Alexander Fowler
Using Access 2002 and SQL 2000
Please pardon what will seem like a stupid question to some - I'm a newbie
to stored procedures (having done everything through queries up until this
point), but thankfully my app is getting sophisticated enough that business
rules are coming into play and I need to adopt some better practices.
So far, I have created a stored procedure that inserts an inventory record,
returns the autonumbered primary key and writes a record in a supplemental
table if certain conditions are met. This works fine when I supply static
values in the SP. However, I have no idea how to supply the needed
information from my Access form to the stored procedure. Specifically:
How do I call the stored procedure from the form, and how do I tell it that
"@manufacturer" comes from the data in txtManufacturer, @partnumber comes
from the data in txtPartNumber, etc.
TIA,
Alex
Please pardon what will seem like a stupid question to some - I'm a newbie
to stored procedures (having done everything through queries up until this
point), but thankfully my app is getting sophisticated enough that business
rules are coming into play and I need to adopt some better practices.
So far, I have created a stored procedure that inserts an inventory record,
returns the autonumbered primary key and writes a record in a supplemental
table if certain conditions are met. This works fine when I supply static
values in the SP. However, I have no idea how to supply the needed
information from my Access form to the stored procedure. Specifically:
How do I call the stored procedure from the form, and how do I tell it that
"@manufacturer" comes from the data in txtManufacturer, @partnumber comes
from the data in txtPartNumber, etc.
TIA,
Alex