The LA Fox DeveloDer Newsletter

November 1997

SQL Views (Con't from page 3)

CHANGE LOG:

CHANGED TROUBLE CHANGES

a ON DATE REPORT# MADE BY DESCRIPTION OF CHANGES

parameters cFIIe

cExt = rlght(cFile,3)

cFile substr(cFile, 1, len(cFiIe)-4)

cCode = zxinlprs(’c:~wlndows~win’,’extensions’,cExt)

if empty(cCode)

=MESSAGEBOX(’The application required to view this document

has not been setup correctly’, 16, ‘Error’)

return

endif

cCode = strtran(cCode, “, cFile)

I/ni &ccode

PROGRAM: zxlniPrs

VERSION: 1.0 (Fox 2.6)

USAGE:

Parses and returns a parameter from an .INI file

CALLD FR: main.prg, and other places

INPUTS:

pcFlIe-name of the mi file (no extension, path optional: will

look in SET PATH)

pcSection the section name

pcTitle the parameter name

pcDefault a default value if any of the above fail to be found

RETURNS:

the string found in the mi file, or the default if not

Note: If no default value given, will return .F.

Hot Tips...

FoxPro Q&A

Q How can I replace the default “Microsoft FoxPro” title in an

executable?

A (This is applicable to Visual FoxPro as well.) To replace the

default ‘Microsoft FoxPro’ in the title bar of the main desktop of

your executable, include the following line in your Conflg.fpw file:

Title=Your Title

Note:

Do not use quotes (“) while specifying your title.

You can achieve the same effect by including the MODIFY

WINDOW SCREEN in your application and by using the

keyword TITLE followed by a character string expression for the

title. In this approach, however, the MODIFY WINDOW

SCREEN command changes the main desktop title only after

the executable program has complete control. This means that

the Microsoft FoxPro title is briefly displayed in the title bar

before it is replaced by the new title that you specified using the

MODIFY WINDOW command:

MODIFY WINDOW SCREEN TITLE ‘Mytitle’

U Is there a simple way of printing a variable number of copies

of a report in FoxPro, without running the report a number of

times?

A You can use either of the methods indicated below to print a

variable number of copies of a report.

Method I

1. .Issue the REPORT FORM TO PRINT PROMPT command

from the command window. <file name> is the name of the

report you want to print. The PROMPT option in the above

command opens a dialogbox

2.Specify the number of copies you want to print (the default is

one).

Method II

The system memory variable, _PCOPIES specifies the number

of copies you want to print. Here, _PCOPIES = where Expn is

the number of copies you want. You can print with this variable

only when you use it with PRINTJOB ... ENDPRINTJOB. As

such, this variable can be used only in FoxPro programs. All

you need to do is place the _PCOPIES assignment statement

before the PRINT JOB to set the number of copies to print.

(Con’t, page 5)

Page 4