I need to get this UPDATE statement, which runs correctly as an Access
Query
and correctly use this as a string in my VB6/ADO application. Any help is
appreciated as I am not doing this correctly.
Existing Access Query:
UPDATE TBLPID SET TBLPID.f_TBLPID_PID = Left([f_TBLPID_PID],4) & "-" &
Mid([f_TBLPID_PID],5,2) & "-" & Mid([f_TBLPID_PID],7,4);
Need something like:
Dim sql As String
sql = "UPDATE TBLPID SET TBLPID.f_TBLPID_PID = Left([f_TBLPID_PID],4) & ""
-
"" & Mid([f_TBLPID_PID],5,2) & "" - "" & Mid([f_TBLPID_PID],7,4);"""
|
