[RESOLVED] Sql Statement issue

[firoz.raj]

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

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

Meanwhile this is working properly.

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

[d.paulson]

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

[Ash Katchup]

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

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

[DataMiser]

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.

[Shuja Ali]

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