ravikumar00008
New Member
Hi All,
I want to catch the ID comming from the sqlTable like this but i am not succeeded
~
ColA = shtSheetToWork.Cells(lRow, 1)
ColB = shtSheetToWork.Cells(lRow, 2)
SplitMonth="Jun"
SplitYear="2012"
SQLSelect = "select ID from Test where Country= ' " & ColA & " ' and Name=' " & ColB & " ' and Month=' " & SplitMonth& " ' and Year=' " & SplitYear & " ' "
Cn.Execute SQLSelect
~
Here how can i catch the result in a variable.
Please help me to achieve this.
Regards
Kumar
I want to catch the ID comming from the sqlTable like this but i am not succeeded
~
ColA = shtSheetToWork.Cells(lRow, 1)
ColB = shtSheetToWork.Cells(lRow, 2)
SplitMonth="Jun"
SplitYear="2012"
SQLSelect = "select ID from Test where Country= ' " & ColA & " ' and Name=' " & ColB & " ' and Month=' " & SplitMonth& " ' and Year=' " & SplitYear & " ' "
Cn.Execute SQLSelect
~
Here how can i catch the result in a variable.
Please help me to achieve this.
Regards
Kumar