-
Date value mistakes on Visualbasic
It is the first time I used VB to set up a oracle-based application to mamage my Insurance Activities. I graduated from a economic university so that I don't have any experience on programming. Could you help me update a new record from Ado recordset into Oracle table. My problems occured due Date data type.
I can update normally most of fields except the Date-defined Fields. all of input values (ex: '12/2/2002') update or addnew into above date Fields becomed '00/00/0000'
********************
My VB Code (in brief): That code run normally but outgoing values was mistake
Dim rs as new recordset
rs.open "select * from table1", ODBC-based activedConnection, adOpenDynamic, adLockOptimistic
with rs
!custommername= " name1"
!birdDay="12/2/1980"
' the Birdday field have Date data type
rs.update
***********on Ora SQLWorksheet*****************
alter session set NLS_date-format='dd/mm/yyyy';
Statement processed.
select * from table1
Custommername Birdday
__________________________________
name1 00-00-0000 (outgoing values)
****************************************************
Could you tell me What is my mistakes and how to resolve its
Thank your assistance
vptoan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|