|
 |
access_asp thread: Need help with Stored procedures
Message #1 by "Frode" <fstroemm@o...> on Sat, 11 Aug 2001 22:52:47
|
|
Hi.
I have 3 tables, with Table1 using auto number.
How would I do a stored procedure/query in Access 2000
where I insert data into Table1, get the auto number and
using this number in Table2 and Table3.
Thanks.
- Frode.
Message #2 by =?iso-8859-1?Q?R=E9my_MARICIC?= <remind@n...> on Sun, 12 Aug 2001 14:20:17 +0200
|
|
There's only one method to get the auto number when inserting a new row in
access2000.
You must use the recordset.AddNew method and not a stored procedure to get
it.
There's no other way. Sorry.
Regards,
Rem
-----Message d'origine-----
De : Frode [mailto:fstroemm@o...]
Envoyé : samedi 11 août 2001 22:53
À : Access ASP
Objet : [access_asp] Need help with Stored procedures
Hi.
I have 3 tables, with Table1 using auto number.
How would I do a stored procedure/query in Access 2000
where I insert data into Table1, get the auto number and
using this number in Table2 and Table3.
Thanks.
- Frode.
Message #3 by "Frode" <fstroemm@o...> on Sun, 12 Aug 2001 15:16:54
|
|
ok, thanks.
Is it possible to update more than one table with one stored proc then?
example:
INSERT INTO table1 (test1) values ([@forminput1]);
INSERT INTO table2 (test2) values ([@forminput2]);
INSERT INTO table3 (test3) values ([@forminput3]);
This gives me a 'Characters found after end of SQL statement.
- Frode.
> There's only one method to get the auto number when inserting a new row
in
> access2000.
> You must use the recordset.AddNew method and not a stored procedure to
get
> it.
>
> There's no other way. Sorry.
>
> Regards,
>
> Rem
>
>
> -----Message d'origine-----
> De : Frode [mailto:fstroemm@o...]
> Envoyé : samedi 11 août 2001 22:53
> À : Access ASP
> Objet : [access_asp] Need help with Stored procedures
>
>
> Hi.
>
> I have 3 tables, with Table1 using auto number.
>
> How would I do a stored procedure/query in Access 2000
> where I insert data into Table1, get the auto number and
> using this number in Table2 and Table3.
>
>
> Thanks.
>
> - Frode.
>
>
|
|
|
View Cart
