Here's my SQL Statement:
SELECT * FROM tblHeader WHERE Requestor='"&label1.text&"'
Why doesn't it work?
Alphard
0
Newbie Poster
Recommended Answers
Jump to PostHere's my SQL Statement:
SELECT * FROM tblHeader WHERE Requestor='"&label1.text&"'
Why doesn't it work?
Hi Alphard,
may be becuase of last comma issue...
SELECT * FROM tblHeader WHERE Requestor='" & label1.text & "'"
Jump to Postthen please post the exact error. so that we can find out where the problem lies.
Jump to PostPost your code. Use following syntax if column type is non-numeric,
str="SELECT * FROM tblHeader WHERE Requestor='" & Text1.Text & "'"For numeric type,
str="SELECT * FROM tblHeader WHERE Requestor=" & Text1.Text
All 10 Replies
Piya27
4
Junior Poster
Here's my SQL Statement:
SELECT * FROM tblHeader WHERE Requestor='"&label1.text&"'
Why doesn't it work?
Hi Alphard,
may be becuase of last comma issue...
SELECT * FROM tblHeader WHERE Requestor='" & label1.text & "'"
Alphard
0
Newbie Poster
Hi Alphard,
may be becuase of last comma issue...
SELECT * FROM tblHeader WHERE Requestor='" & label1.text & "'"
I did that but it doesn't seem to work..
Piya27
4
Junior Poster
then please post the exact error. so that we can find out where the problem lies.
Alphard
0
Newbie Poster
then please post the exact error. so that we can find out where the problem lies.
Hi Piya!
Here's the error:
Invalid text or symbol.
Error in WHERE clause near'"
Unable to parse query text.
kvprajapati
1,826
Posting Genius
Team Colleague
Post your code. Use following syntax if column type is non-numeric,
str="SELECT * FROM tblHeader WHERE Requestor='" & Text1.Text & "'"For numeric type,
str="SELECT * FROM tblHeader WHERE Requestor=" & Text1.Text
Alphard
0
Newbie Poster
Post your code. Use following syntax if column type is non-numeric,
str="SELECT * FROM tblHeader WHERE Requestor='" & Text1.Text & "'"For numeric type,
str="SELECT * FROM tblHeader WHERE Requestor=" & Text1.Text
I'm doing it through Query Builder is it possible to that there?
Piya27
4
Junior Poster
no it is not possible there you have to specify the exact string or text instead of Label1.Text.
kvprajapati
1,826
Posting Genius
Team Colleague
Piya: no it is not possible there you have to specify the exact string or text instead of Label1.Text.
Why not? There is no problem with Label's Text with value.
Piya27
4
Junior Poster
Hello Sir,
I am not saying that there's any problem with Label's Text with value
I wrote this because Alphard is using Query Builder which I don't think takes values from Label or TextBox.(I may be wrong, but I have suggested what I have practised). I use Query Builder for testing my queries and that never takes values from Labels etc.
Alphard
0
Newbie Poster
no it is not possible there you have to specify the exact string or text instead of Label1.Text.
Thanks Piya! Its already working...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.