Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
14 Points
8 Posts
Mar 13, 2012 09:58 PM|LINK
This is driving me crazy! I keep on getting an error at the date part of the insert statement
The data type in the oracle table is Date(7)
how do I fix this?
Thanks
oConnection = New OracleConnection("Data Source= ;User ID=;Password=;") oConnection.Open() oCommand.Connection = oConnection oCommand.CommandText = "INSERT INTO MAPS.GIS(ENTRYDATE,USERID,JOB_NUMBER,ENTRY_TYPE,CHANGE_DESCRIPTION) VALUES(" & Today & ",'" & "USERID', " & txtJO.Text & ",'" & txtType.Text & "','" & txtDesc.Text & "')" oReader = oCommand.ExecuteReader()
greenheck1
Member
14 Points
8 Posts
Insert Today into an oracle table
Mar 13, 2012 09:58 PM|LINK
This is driving me crazy! I keep on getting an error at the date part of the insert statement
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
The data type in the oracle table is Date(7)
how do I fix this?
Thanks
oConnection = New OracleConnection("Data Source= ;User ID=;Password=;") oConnection.Open() oCommand.Connection = oConnection oCommand.CommandText = "INSERT INTO MAPS.GIS(ENTRYDATE,USERID,JOB_NUMBER,ENTRY_TYPE,CHANGE_DESCRIPTION) VALUES(" & Today & ",'" & "USERID', " & txtJO.Text & ",'" & txtType.Text & "','" & txtDesc.Text & "')" oReader = oCommand.ExecuteReader()