This discussion is archived
2 Replies Latest reply: Oct 8, 2010 5:38 AM by mlov83 RSS

oo4o and query field datatyped timestamp

mlov83 Newbie
Currently Being Moderated
Hello guys I have never crossed this issue in the past but when i query an oracle table with oo4o with a field datatyped as timestamp. i get an error. I think this is a limitiations of oo4o but i like to hear from anyone who has have this issue or how they overcomed the issue.
any help is greatly appreciated.


the error i get when i run the below code is

application define error or object define error.



here a vb code spinet of what im trying to do.
Sub timestampTest()
    

Coon
    
    Sql = "select activity_date from ftcractg"
       
    Set OraDynaset = OBJDATABASE.DBCreateDynaset(Sql, 0)

    If OraDynaset.RecordCount > 0 Then
        OraDynaset.MoveFirst
        For x = 0 To OraDynaset.Fields.count - 1
            Cells(1, x + 1) = OraDynaset.Fields(x).Name
            
        Next

        For Y = 0 To OraDynaset.RecordCount - 1
            For x = 0 To OraDynaset.Fields.count - 1
                Cells(Y + 2, x + 1) = OraDynaset.Fields(x).Value
            Next
            OraDynaset.MoveNext
        Next
    End If

   
 Cells.EntireColumn.AutoFit
        Rows("1:1").Select
            Selection.Font.Bold = True

End Sub

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points