Passing Date to a FoxGraph Graph as a Subtitle

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:

Last Reviewed: April 17, 1995