On Tuesday 24 June 2008 17:18:22 Shavonne Marietta Wijesinghe wrote:
> Hello
>=20
> Is there a way to find out if the EXECUTE of a UPDATE, INSERT has been
co=
mpleted successfully?
>=20
> Here is an example of what I do:
>=20
> Set conn =3D Server.CreateObject("ADODB.Connection")
> conn.Open "Form_Store_PSQL"
>=20
> Set oRs =3D Server.CreateObject("ADODB.Recordset" )
> strSQL =3D "INSERT INTO TABLE_TEMP (ID) VALUES ('1')"
> conn.Execute strSQL
If no Exception is thrown, the execution of the query was successfull.
Note that usually INSERT, UPDATE and DELETE return an integer > 0,
indicati=
ng affected rows, but not always. There might be 0 affected rows, which is
=
not nessesarily an error.
--=20
Andreas Joseph Krogh <andreak@[EMAIL PROTECTED]
>
Senior Software Developer / Manager
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Karenslyst All=C3=A9 11 | know how to do a thing and to watch
|
PO. Box 529 Sk=C3=B8yen | somebody else doing it wrong, without
|
0214 Oslo | comment. |
NORWAY | |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
