RE: UPDATE statement help / MS Access db

Here is the original SQL Statement that correctly executes in Access:

UPDATE TBLPID SET TBLPID.f_TBLPID_PID = Left([f_TBLPID_PID],4) & "-" &
Mid([f_TBLPID_PID],5,2) & "-" & Mid([f_TBLPID_PID],7);


"jamesfreddyc" wrote:

VB6 app

Trying to setup an UPDATE statement to modify all records in a single column
(Access db). Everything works fine until it hits the UPDATE statement (no
errors, but no updates made to the table).

Connection is fine, table is fine, field is fine, just not updating.

Dim sql_updPid As String
sql_updPid = "UPDATE TBLPID SET TBLPID.f_TBLPID_PID = Left([f_TBLPID_PID],4)
& "" - "" & Mid([f_TBLPID_PID],5,2) & "" - "" & Mid([f_TBLPID_PID],7);"

.

Relevant Pages

  • RE: UPDATE statement help / MS Access db
    ... Trying to setup an UPDATE statement to modify all records in a single column ...
    (microsoft.public.vb.database.ado)
  • Re: UPDATE statement help / MS Access db
    ... Trying to setup an UPDATE statement to modify all records in a single ... Everything works fine until it hits the UPDATE statement (no ...
    (microsoft.public.vb.database.ado)
  • UPDATE statement help / MS Access db
    ... Trying to setup an UPDATE statement to modify all records in a single column ... Everything works fine until it hits the UPDATE statement (no ...
    (microsoft.public.vb.database.ado)
  • Re: JTable editor doesnt stop the first time
    ... > I create my select statement or update statement for the database. ... except for the first time. ... (I modify a date in the table ...
    (comp.lang.java.gui)
  • JTable editor doesnt stop the first time
    ... I create my select statement or update statement for the database. ... except for the first time. ... (I modify a date in the table ...
    (comp.lang.java.gui)
Loading