[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference rocks::dec_edi

Title:DEC/EDI
Notice:DEC/EDI V2.1 - see note 2002
Moderator:METSYS::BABER
Created:Wed Jun 06 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3150
Total number of notes:13466

3118.0. "%SQL_F_SYNTAX_ERRfrom Cockpit" by CSC32::B_ALTMIRE () Wed Apr 30 1997 23:56

Hi,

When  using Cockpit 2.1A with a VMS server I get an %SQL_F_SYNTAX_ERR from
the following action:
1. Select the summary icon
2. Enter a date range from 1 march 1997 to 1 april 1997.
   A summary display of docs and tranmissions appears.
3. Double click on one of the graph bars and get a "choose summary category"
   window.
4.If the applid or doctype category is selected I get the
  %SQL_F_SYNTAX_ERROR message. If I select the all category it works ok. Also
  if I dont specify a date range for the summary, applid and doctype work ok.
  Also seems to work with only a since date/time and leaving the before
  date/time blank.

Is this operator error or a bug?

This is with windows 95 on the PC and Oracle ODBC drivers

Thanks,
Bill
T.RTitleUserPersonal
Name		DateLines
3118.1Known probMETSYS::POADhttp://www.digital.com/info/ediThu May 01 1997 01:2912
    Bill,
    
    This is a bug that has been found in Cockpit V3.1A (which now has a
    patch on our web site - #5). This is the same problem exhibited in
    Cockpit V2.1A.
    
    It is fixed in Cockpit V3.2 where the V2 & V3 Cockpits have been merged
    into one image.
    
    It occurs when you enter both Since and Before filter dates.
    
    	Chris