FoxPro Trivia Quiz



How well do you know the obscure corners of Foxpro? Try this quick quiz.
  1. If the Customers table is open, what does this command do: ? [company]
    1. Displays the value of the company field
    2. Displays the characters 'company'
    3. Displays the value of the variable whose name is stored in the variable named 'company'

  2. What happens if you hold the Shift key down then click on File in the main menu?
    1. The Close option becomes Close All
    2. The current window closes
    3. The menu undocks and can be moved

  3. What date is given by Gomonth({^2000-01-31}, 1)?
    1. February 28th 2000
    2. February 29th 2000
    3. March 2nd 2000

  4. What does the command 3+8 do if you are on the first record of the Customer table?
    1. Stores 11 in the primary key of the current record
    2. Moves to record 11
    3. Displays the numeric value 11.

  5. If x is 'X ' and y is 'Y ' then what is the result of x - y ?
    1. A type-mismatch error
    2. -1
    3. 'XY '

  6. What happens if you redefine a field type from Numeric to Float?
    1. All values in the field are truncated to 4 decimal places
    2. All values in the field are lost
    3. Nothing changes

  7. Can you enter duplicate values in a field with a Unique index?
    1. Yes
    2. Yes, but you get a warning message
    3. No, any duplicate value is rejected

  8. What does ?_screen->backcolor do?
    1. Displays the value of the screen's background colour.
    2. Sets the background colour of the current control to the screen's background.
    3. Displays the colour-picker dialog

  9. Can you use a #DEFINE on a Foxpro keyword?
    1. Yes.
    2. Yes but the redefinition is ignored.
    3. No.

  10. What is the result of Proper('MCKAY')?
    1. 'McKay'
    2. 'MCKAY'
    3. 'Mckay'.

Follow this link for the answers.

Hints & tips

The textbox class in Visual FoxPro 9 has a new Autocomplete property which shows the user the previous values that have been entered in that textbox.
Autocomplete in VFP 9

Your Access database will look more impressive if you add custom toolbars...
Custom toolbars

FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions

More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.

Site Map