Member Avatar for firoz.raj

Can anyone tell me how should i use variable to take different value.here is the following code which is working fine.

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

But i want to use integer variable name instead of integer value.
Can anyone tell me .How should i use.here is the code which is not
working.Kindly help me.Any help would be Highly appreciated.

strsql = " SELECT *" & _
  " From ALRAJHIBANK " & _
 " WHERE (((ALRAJHIBANK.ID)=itemID))"
  • 2 Contributors
  • 1 Reply
  • 97 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr 
"WHERE ALRAJHIBANK.ID = " & itemID

Good Luck

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.