Details of "Frequently Asked Questions" (FAQ) dealing with common problems.

Q1. How does FoxPro handle the Year 2000 issue ?

FoxPro stores the date correctly in a date field if the environment has SET CENTURY ON and the century is explicitly entered or replaced into that field. If the CENTURY switch is OFF then a 2 digit year will default to 19xx even if you use the current date function DATE( ).

http://microsoft.com/technet/year2k/product/product.htm

Q2. How big should a .CDX file be, because I have one that is larger than the table?

The size of the .CDX file is going to depend on the length of the index keys and the number of records and the number of unique index entries, so it is difficult to determine in advance!. There is a problem that when an index tag is deleted the space is not released from the .CDX file even if the REINDEX command is used. The solution is to have a housekeeping routine which deletes the entire .CDX file e.g. with a DELETE TAG ALL statement, and then recreate all the index tags in code.

Q3. The Query Wizard creates an updateable query, how can I make my query updateable?

You can't. The Query Wizard really creates a global fieldlist and uses code to set relations between the underlying tables.

Q4. My screen won't generate, but I get no errors displayed.

This could be that you are not closing the screen designer, or that the screen program is still running. Another scenario is that you have added the screen as a program (i.e. the .SPR file) into your project.

Other recommended sources for FoxPro FAQs

http://support.microsoft.com/support/default.asp?SD=MSDN&PR=fox (for FAQ and Highlights for FoxPro)

http://msdn.microsoft.com/vfoxpro/technical/techfaq.asp for Microsoft technical advice)

http://www.cfdrc.com/FOX/faq.html (fox from an engineering standpoint)

http://www.vfug.org/ (the Virtual FoxPro users Group)

http://www.advisor.com/www/FoxProAdvisor (a useful US based Magazine)

The public newsgroups listed below are also useful sources for help.

Chatter
(microsoft.public.fox.chatter)

Events
(microsoft.public.fox.events)

Help Wanted
(microsoft.public.fox.helpwanted)

Internet
(microsoft.public.fox.internet)

Microsoft Visual FoxPro Crossplatform
(microsoft.public.fox.vfp.xplat)

Microsoft Visual FoxPro DBC
(microsoft.public.fox.vfp.dbc)

Microsoft Visual FoxPro for Macintosh
(microsoft.public.fox.vfp.mac-specific)

Microsoft Visual FoxPro Forms
(microsoft.public.fox.vfp.forms)

Microsoft Visual FoxPro Grids
(microsoft.public.fox.vfp.grids)

Microsoft Visual FoxPro Language Menus
(microsoft.public.fox.vfp.language-menus)

Microsoft Visual FoxPro LCK API
(microsoft.public.fox.vfp.lck-api)

Microsoft Visual FoxPro OOP
(microsoft.public.fox.vfp.oop)

Microsoft Visual FoxPro Reports/Printing
(microsoft.public.fox.vfp.reports.printing)

Microsoft Visual FoxPro Setup
(microsoft.public.fox.vfp.setup.environment)

Microsoft Visual FoxPro SQL Query
(microsoft.public.fox.vfp.queries-sql)

Microsoft Visual FoxPro Web
(microsoft.public.fox.vfp.web)

Programmer Exchange
(microsoft.public.fox.programmer.exchange)

Setup-Environment
(microsoft.public.fox.fox2x.setup.environment)

X Plat
(microsoft.public.fox.fox2x.xplat)

If you still have problems please complete the Technical Support Form        and email or fax it to us.