Hi guys, I wanted to knwo if it was possible to add a value to a
string, I have a field in my access table case_no which is of type
TEXT, and want to add a value, here is teh code,
Dim rs
rs = conn.Execute("SELECT MAX(case_no) AS num FROM tblEvent WHERE
LEFT(case_no, 4) = '" & TEMP & "' ")
'IF IT's NULL THEN MAKE IT = 1
if
(trim(convert.tostring(rs("num"))))="0" then
case_no = TEMP & "00001"
else
rs.Movefirst
case_no =trim(convert.tostring(rs("num")))
Response.Write (trim(convert.tostring(rs("num"))) & "<br>")
case_no = case_no+ 1
response.Write(case_no)
end if
rs.close
Now even if i change case_no to a number, it doesnt work , I am not
sure as to how to proceed, i am converting this asp app to asp.net. Any
help is appreciated.
PS: I tried posting the same topic but couldnt go thru , henc eif this
repeats, I apologise