Re: select * from events - only today's events

[Ken Long]

Thanks... I was just coming to that conclusion myself

I finally got Crystal Reports to understand the timestamp fields (requires
the TSM 4.1.3 ODBC driver, TSM 4.2.1 ODBC driver doesn't work with Crystal
Reports 8.0).  Crystal could see all of the data, where select * couldn't.

I understand the desire to make it work like Q Events does, but for those
of us new to using select/SQL it is unexpected.  Select * should select all
records, like it does for other tables.

Thanks again to the extremely valuable resources using this forum!





                    "Rushforth, Tim"
                    <[EMAIL PROTECTED]        To:     [EMAIL PROTECTED]
                    PEG.MB.CA>                  cc:
                    Sent by: "ADSM: Dist        Subject:     Re: select * from events 
- only today's events
                    Stor Manager"
                    <[EMAIL PROTECTED]
                    U>


                    11/21/2001 04:49 PM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"






Ken:

Select * from events only shows events for the current day.

See http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html for an explanation.

Tim Rushforth
City of Winnipeg

To:   [EMAIL PROTECTED]
cc:
Subject:  select * from events - only today's events


Am I missing something?

I have Eventretention set to 90 days.  I can use "query event" to see event
data from days past.

But if I use "select * from events" I only get events from today, no
historical data.

Shouldn't the Events table have previous days results in it?

Thanks... Ken