Syntax error of select statement

Question

1.00/5 (1 vote)

See more:

.Open("select * from tbllocation where ID like tblclient2 like NUMBER where expiration = '" & Label4.Text & "' and status = '" & "not expired" & "'", cn, 2, 3)

Posted 2-Sep-14 16:02pm

Member 10791395

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 9992980 · Answer 1 · 2014-09-02T16:19:00

Solution 1

You have included 2 where clauses, only 1 is allowed

Should be

select * from tbllocation where ID like tblclient2 like NUMBER or expiration = '" & Label4.Text & "' and status = '" & "not expired" & "'"

or

select * from tbllocation where ID like tblclient2 like NUMBER and expiration = '" & Label4.Text & "' and status = '" & "not expired" & "'"

Posted 2-Sep-14 16:19pm

Member 9992980

Comments

Member 10791395 3-Sep-14 23:54pm

this is the table i have,
and i want to select the ID = NUMBER where the number expiration = label4.text and status = not expired.

im using vb.net and MS access for table.

tblclient2
NUMBER
clients
location
quantity
installation
expiration
size
status

tbllocation
ID
location
no_unit
avai_unit

thank you,

Maciej Los 11-Dec-14 16:17pm

Yeah! Only one Where statement is allowed.
+5!

MuhammadUSman1 · Answer 2 · 2014-09-02T19:24:00

Solution 2

Here is Query Syntax please add your columns name and values according to your requirements.

SQL

select * from tbllocation where ID like '%GIVE ANY ID HERE%' --PLEASE USE [AND OR] HERE 
OR tblclient2 like '%GIVE NUMBER HERE%' 
AND expiration = 'YOUR TEXT HERE' and status = 'not expired'

if any issue then please let me know.

Thanks

Posted 2-Sep-14 19:24pm

MuhammadUSman1

Comments

Member 10791395 3-Sep-14 23:55pm

this is the table i have,
and i want to select the ID = NUMBER where the number expiration = label4.text and status = not expired.

im using vb.net and MS access for table.

tblclient2
NUMBER
clients
location
quantity
installation
expiration
size
status

tbllocation
ID
location
no_unit
avai_unit

thank you,

MuhammadUSman1 4-Sep-14 1:20am

SELECT * FROM tblclient2 t1 join tbllocation t2 on t1.Number = t2.ID and t1.expiration = lable4.text and status = 'not expired'

//it will select all data from both tables where id is equal Number and expriation is equal your give value and status is equal 'not expirde'.

if any issue in query understanding then let me know.
Thanks
->M.U

MuhammadUSman1 4-Sep-14 1:19am

SELECT * FROM tblclient2 t1 join tbllocation t2 on t1.Number = t2.ID and t1.expiration = lable4.text and status = 'not expired'

//it will select all data from both tables where id is equal Number and expriation is equal your give value and status is equal 'not expirde'.

if any issue in query understanding then let me know.
Thanks
->M.U

Member 10791395 4-Sep-14 2:01am

sir its Syntax error in FROM clause.

MuhammadUSman1 4-Sep-14 3:13am

Please post error here.