This was discussed on the list only once since I am subscribed but much more in the past. You can dig into www.adsm.org archives and find it. It might be interesting to read an answer Andrew Raibeck was posted more than year ago (http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html). Yes, I know this is not standard-compliant SQL implementation, does implement just subset of SQL commands. However such select behavior is too proprietary from my point of view. Is there anyone tried to open PMR on this (even just to get "Works as designed") ?
Zlatko Krastev IT Consultant Ken Long <[EMAIL PROTECTED]> on 22.11.2001 01:47:05 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: select * from events - only today's events 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