From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using PostgreSQL transactions through MS Access? |
Date: | 2001-07-23 17:09:51 |
Message-ID: | 200107231710.NAA02958@interlock2.lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)lindsay%peaofohio(dot)com(at)interlock(dot)lexmark(dot)com> on 07/15/2001
06:31:24 PM
To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-07-23 17:26:26 | Re: AutoStart and AutoDown |
Previous Message | Marcelo Pereira | 2001-07-23 16:42:02 | Re: Language C - Console-based FrontEnd |