Microsoft KB Archive/99605

{| = Passing Date to a FoxGraph Graph as a Subtitle =
 * width="100%"|

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 , 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.