Help with SQL String from Access Query
- From: jamesfreddyc <jamesfreddyc@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 9 Apr 2008 10:58:05 -0700
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);"""
.
- Prev by Date: Re: multiple query problem
- Next by Date: VB.NET ADO Recordset DataGridView and Access not in sync w/other c
- Previous by thread: multiple query problem
- Next by thread: VB.NET ADO Recordset DataGridView and Access not in sync w/other c
- Index(es):
Relevant Pages
|
|
