SQL Statement

[jamesnkk]

Hi,
I am not sure how to use the proper sql statement, those quote and double quote
very confusing.

Could somebody help me re-sentence the correct statement

rsDebug.Open "Select * from DebugProcess where SN=" & sn1.Text & " 'and failurecode ='VTT' ", conn

[QVeen72]

Hi,

Change it to :

"Select * from DebugProcess where SN='" & sn1.Text & "' and failurecode ='VTT' "

First Double Quote is for the String,
Single Quote to Wrap String Fields in tyhe Query..

REgards
Veena

[jamesnkk]

Hi,

Change it to :

"Select * from DebugProcess where SN='" & sn1.Text & "' and failurecode ='VTT' "

First Double Quote is for the String,
Single Quote to Wrap String Fields in tyhe Query..

REgards
Veena

Thank you so much it work