Passing Date to a FoxGraph Graph as a Subtitle

Last reviewed: April 17, 1995
Article ID: Q99605

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SUMMARY

The system date can be passed as a parameter to GENGRAPH.FXP so that the current date will be displayed as the subtitle on a FoxGraph graph.

MORE INFORMATION

GENGRAPH.FXP is a program called by the RQBE tool when a query is output to a graph. It has two optional parameters: Subtitle and Column Title. The syntax for calling GENGRAPH with these parameters is:

   DO (_GENGRAPH) WITH <subtitle>, <column title>

The RQBE window does not have any options for specifying these parameters, so a statement similar to the following will be produced when outputting a query to a graph:

   SELECT test.age, test.num;
      FROM test;
      INTO CURSOR query
   DO (_GENGRAPH)

To modify the commands generated by the RQBE tool, choose the See SQL button, select (highlight) the commands in the window, and choose Copy from the Edit menu. These commands can then be pasted into a program file and modified to look like the following:

   SELECT test.age, test.num;
      FROM test;
      INTO CURSOR query
   DO (_GENGRAPH) WITH DTOC(DATE())

NOTE: In FoxPro version 2.0 for MS-DOS, the DO command produced by the RQBE tool is:

   DO c:\foxpro2\gengraph.fxp

which can be pasted into a program and modified to read:

   DO c:\foxpro2\gengraph.fxp WITH DTOC(DATE())

FoxGraph is supported by Three D Graphics at (310) 459-7949.

REFERENCES

"Using FoxPro Version 2", Slater & Arnott, page 231, Que, 1992

Additional reference words: FoxDos 2.00 2.50 2.50a today's relational query
by
example
KBCategory: kbprg
KBSubcategory:

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.