I am using oracle 8.1.6 and vb
6.0 and win 2k in my home
when I try to insert into date in my table(feild has date datatype) using DTpicker control in vb6.0
it gave me error (differant at differant times)
Error # 1
a numeric value was encountered where a nonnumeric value was expected
literal do not match the format string
not a valid month
then some how these error removes but start giving me error
"accessor is not parameter accessor"
when I assign date retreived from db to DT poicker e.g
this is my query select dbirth from student where student_id = 100099
dtp1.value = rs.feilds(0).value
this line generate the above error
I've asked many ppl about this but didnt get any answer so changed my date type to string.
but now it is causing me problem while retreiving data when my where clause have anything other than equal sign
like if I have select ..... where dbirth = '31-12-88'
and If am using any other operator (other than = ) it gives unexpected result now how I can retreive data with the desired results
Unfortunately I dont have time to change back to date type.............
So if there is any possible solution with this scenerio
all the date (that are string)have format 31-12-99 means dd-mm-yy