By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,157 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,157 IT Pros & Developers. It's quick & easy.

SQL Statement

100+
P: 134
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
Jul 5 '08 #1
Share this Question
Share on Google+
2 Replies


QVeen72
Expert 100+
P: 1,445
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
Jul 6 '08 #2

100+
P: 134
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
Jul 6 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.