Drop the semicolon at the end of the string. In this context, it's not needed
to tell where the end of the statement is.
You might want to use a parameterized stored procedure that does multiple
updates inside a transaction. You would invoke the stored procedure via
mdb.Execute, as per your example.
--Wes
Neal Lindsay <neal.lindsay%peaofohio.com@interlock.lexmark.com> on 07/15/2001
06:31:24 PM
To: pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Using PostgreSQL transactions through MS Access?
I am trying to update my database with a big transaction so I don't get
an invalid state. My front end is in Access 97. Is there anyone out
there who does this that could tell me what I'm doing wrong? Here's my
code:
queryString = "BEGIN TRANSACTION;"
mdb.Execute queryString, dbSQLPassThrough
It tells me that it's an "Invalid SQL Statement". It seems like Access
is trying to parse it instead of sending it on to the DB server. I
thought that the dbSQLPassThrough was supposed to stop that. Does
anyone know where I went wrong?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html