RE: Oracle Computed column datatype

Hi,

First of all, I would like to confirm my understanding of your issue. From
your description, do you mean that after opening the Recordset, Print
rs.Field("weight").Type and Print rs.Field("tons").Type return different
values? If there is any misunderstanding, please feel free to let me know.

Could you let me know which data type the column weight is using? It works
fine if I use SQL server. So I will try to do some research if I use it on
Oracle. Will this also happen if you use other numeric types?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Re: Type mismatch
    ... > select the lowest date field in a specific recordset, ... >> The third argument of the DateAdd function must be a date data type. ... the SQL statement that you have posted will not work as you intend. ...
    (microsoft.public.access.formscoding)
  • Re: Null
    ... In my vb code I return a recordset from a sql database. ... > string and some are integers. ... > My client now wants to import that text file into their own SQL database. ... attempt to assign a Null value to it (DON'T change the variable's data type ...
    (microsoft.public.vb.syntax)
  • Re: Mismatched Data Type in an Expression
    ... (No private e-mails, please) ... > message on the SQL statement that says the data type is ... > Private Sub Requested_Docs_Received_Click ... > Dim M As Recordset, D As Database, C As Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: DoCmd.RunSQL
    ... So I used recordset as a data type and kept everything else the same. ... > Dim MasterP As Integer ... > Exit Sub ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO-Excel Data Type Problem
    ... It appears that Excel is setting the data type of a field to be either ... When the first few lines of the recordset ... > Try adding the IMEX argument to your connection string: ...
    (microsoft.public.vb.database.ado)