I want to use XLGraph.vbs to create some bar charts from a simple Access database. Trying to minimize errors, I've created a table with the same data fields as the ini file came with. I get the following log lines when I execute XLGraph:
02/03/2005 15:40:41~!~Event Trigger~!~Trigger from menu (UnNamed)
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: <<=== Start Xlgraph -1.6 ===>>
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 0: Time
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 0: Time
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 1: Outside
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 1: Outside
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 2: Tstat
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 2: Tstat
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 3: MasterBedroom
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 3: MasterBedroom
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 4: ComputerRm
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 4: ComputerRm
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 5: Basement
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 5: Basement
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query Filter: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query Sort: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Query: Select Time, Outside, Tstat, MasterBedroom, ComputerRm, Basement FROM Tabla2 WHERE (DateValue(Time) >= #2005-03-02#) ORDER BY Time ASC
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Records returned by XlGraph (loop) : 0
02/03/2005 15:40:41~!~XLGRAPH~!~ERROR: No records returned on Query
Please, I need some advice !!
Daniel
02/03/2005 15:40:41~!~Event Trigger~!~Trigger from menu (UnNamed)
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: <<=== Start Xlgraph -1.6 ===>>
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 0: Time
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 0: Time
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 1: Outside
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 1: Outside
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 2: Tstat
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 2: Tstat
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 3: MasterBedroom
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 3: MasterBedroom
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 4: ComputerRm
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 4: ComputerRm
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: DB Field Name 5: Basement
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Record Name 5: Basement
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query Filter: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: User Query Sort: ''
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Query: Select Time, Outside, Tstat, MasterBedroom, ComputerRm, Basement FROM Tabla2 WHERE (DateValue(Time) >= #2005-03-02#) ORDER BY Time ASC
02/03/2005 15:40:41~!~XLGRAPH~!~DEBUG: Records returned by XlGraph (loop) : 0
02/03/2005 15:40:41~!~XLGRAPH~!~ERROR: No records returned on Query
Please, I need some advice !!
Daniel
Comment