[RESOLVED] Sql Statement issue

Can anyone tell me.why this sql statement is not working.Any help would be highly appreciated.
here is the following statement.

Code:

---

strsql = " SELECT *" & _
  " From ALRAJHIBANK " & _
 " WHERE (((ALRAJHIBANK.ID)= & itemID & ))"

---

Meanwhile this is working properly.

Code:

---

strsql = " SELECT *" & _
  " From ALRAJHIBANK " & _
 " WHERE (((ALRAJHIBANK.ID)=3))"

---

strsql = " SELECT *" & _
" From ALRAJHIBANK " & _
" WHERE (((ALRAJHIBANK.ID)= " & itemID & "))"

When you use some variable inside one SQL statement, you should close quotes and concat with it.

"SELECT * FROM " & sTESTE & " WHERE X = 1"

Post number 2 has the correct solution. The second statement is not formated properly and as a result instead of placing the content of the itemId var into the statement it is placing & itemId &

@firoz.raj When you run into an issue such as this you should either set a break point and look at the content of the strsql, or add a line to display this var in a message box or a debug.print statement. If you would have done any of these you would have most likely found your error in seconds.

Also when dealing with SQL Statements within your VB code, it is always better to use parametrized queries. They give you more control and are compiled and secure.

Take a look at this sample
http://www.codeguru.com/forum/showpo...53&postcount=4