problem with startTime for footy matches via COM

[HiArt99]

It could be that I can't get the startTime for footy (soccer) matches via the COM interface, because I only seem to return "00:00:00".

The code is a simple loop, populating cells.

Code: Select all

    event1 = ba.getEvents(14)                                       'SportID 14 = "Soccer - Fixtures"
   
    For Each evnt1 In event1
   
        event2 = ba.getEvents(evnt1.eventId)
   
        For Each evnt2 In event2
            diff = DateDiff("s", Now(), evnt2.startTime)
            'If diff >= 0 Then
                'Match not yet started
                ActiveCell.Offset(0, 0).Value = CDate(Mid(evnt1.eventName, 10, 99))
                ActiveCell.Offset(0, 0).NumberFormat = "dd mmmm"
                ActiveCell.Offset(0, 0).HorizontalAlignment = xlLeft
                ActiveCell.Offset(0, 1).Value = evnt2.eventName
                ActiveCell.Offset(0, 2).Value = "'" & CStr(evnt2.eventId)
                ActiveCell.Offset(0, 6).Value = evnt2.startTime
                ActiveCell.Offset(1, 0).Select
            'End If
        Next
    Next


I have tried evnt1.startTime and this also returns "00:00:00"

Does anyone know/have suggestions on how to get to the start time of a footy match?

Thanks

Art

[GaryRussell]

I will look into it and get back to you.

[HiArt99]

Thanks Gary.

Just to confirm. I know evnt2 not a market so I have also tried

Code: Select all

        mDate = #1/1/1901 1:01:01 AM#

        For Each evnt2 In event2
            If InStr(evnt2.eventname, "Match Odds") >= 0 Then
                event3 = ba.getEvents(evnt2.eventId)

                For Each evnt3 In event3
                    If mDate = #1/1/1901 1:01:01 AM# Then
                        mDate = evnt3.startDate
                        Exit For
                    End If
                Next
            End If


This bring up the match Odds, or Match odds Unmanaged markets, and isMarket is True for event3. Still returns "00:00:00" though.

Regards

Art

[GaryRussell]

The problem is that the times are not returned by the getEvents API call. I am updating the COM interface code to recognise this and do a getAllMarkets call internally to get the times when they are missing. I will be releasing an update in the next few days.

[HiArt99]

Thanks Gary.

A a professional software tester, I know there is no substitute for real life

Art

[GaryRussell]

Version 1.1.0.64z2 contains this fix. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link.