Procedural processing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to do procedural row processing in Access
similar to PL/SQL in Oracle?

If so, how would I go about it?

This would need to be accomplished using Access 2000.

I'm guessing I would need to write code using ADO, and I
can not simply create a stored procedure within Access.

Thanks
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you are using an .adp (Access Project) you can create stored
procedures (SP). In the SP you can use program flow control
(If..Then, loops) just like PL/SQL (with variations 'cuz they're not
exactly alike).

If you are using an .mdb (Access database - usually JET, but can us
ODBC to connect to other db types) you have 3 choices:

1. If you are connected to an ODBC SQL server that has SPs you can
create an SP in that db (if it supports SPs) & call it using ODBC pass
thru queries (in SQL'r: EXEC MySP 'param', param2).

2. If you are using JET (the Access db) you will have to use VBA to
process each record of a Recordset (using DAO or ADO, whichever lights
your fire).

3. It may be possible to write a query that does the update in one
fell swoop - depends on db design & requirements.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBA+mIechKqOuFEgEQKM3ACgksitk2GxfjY5iPObIMWNlhgkX+0An2xn
TPuUWRC9J1Z3dJR8QK6kuuxS
=4CWv
-----END PGP SIGNATURE-----
 
Back
Top