Ten things that we all know are wrong but which keep catching
us out.
Include your database in the project and wonder why you
cannot create a new view.
Put a SKIP inside a SCAN loop. SCAN performs an implicit SKIP
so that you process every alternate record.
Write an expression in the View or Query Designer and run the
query. Fox won't remind you to press the 'Add' button.
Use a COPY TO without having specified a path and lose your files.
Fox will probably put them in C:\Program Files\Visual Studio\VFP.
Declare the array as LOCAL laTemp[1] before executing a COPY TO ARRAY
and just get a single field in the array. Unlike most other array
commands, COPY TO ARRAY doesn't resize the array automatically. Use
SELECT ... INTO ARRAY instead.
Concatenate the FirstName and LastName fields and forget to trim
the spaces so you get 'John_____Smith_____'
Concatenate the trimmed FirstName and LastName fields and forget
to put a space between them so you get 'JohnSmith'
Use an SQL SELECT statement as the RowSource for a Combo or ListBox
but forget an 'INTO CURSOR Dummy' clause. The SQL will display its
output in a Browse window because that's the default destination.
Type SELECT Customer IN 0 and start processing Customer records.
You aren't in the Customer work area.
Use LIST TO FILE and forget the NOCONSOLE option. You'll get all
the information streamed to the active form.
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