|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
March 11th, 2004, 03:15 PM
|
|||
|
|||
|
using variables in SQL
I am trying to figure out how the proper way to use variables defined in vs.net code in the sql statement that I pass to the DataReader...
Example: strDCNumber (global var defined in earlier code) cmdSelect = New OleDbCommand("SELECT distinct E214TRUK.EH_SCAC FROM E214TRUK INNER JOIN E214SHIP ON e214truk.eh_nid = e214ship.es_eh_nid WHERE (E214SHIP.ES_DCODE= strDCNumber)", conPubs) I have tried using E214SHIP.ES_DCODE Like strDCNumber E214SHIP.ES_DCODE Like "& strDCNumber &" and i have tried flipping the statment to strDCNumber Like E214SHIP.ES_DCODE etc. Can someone please explain how I need to use variables in this SQL ? Thanks
|
|
#2
March 11th, 2004, 04:25 PM
|
|||
|
|||
|
Code:
sqlstr = "SELECT distinct E214TRUK.EH_SCAC FROM E214TRUK INNER JOIN E214SHIP ON e214truk.eh_nid = e214ship.es_eh_nid WHERE (E214SHIP.ES_DCODE='"& strDCNumber &"'" cmdSelect = New OleDbCommand(sqlstr, conPubs) Try the above.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > .Net Development > using variables in SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
