Can anyone help me summarize the VFP query, modify, delete the statement, the more complete the bett

Now set x as a variable.

2*(x*x)+5*x-3=0

The return value of the expression is. t.Or. f.

I don't understand your point, if it's capitalized, it makes no difference.

If there is no insert, it cannot be executed.

If the query is done by the query designer, modifying the query is done in the same way as modifying other objects in the database. Open the query designer, you can modify the query**, the fields required for the query, the criteria for the query, and so on.

If the query is completed by the query analyzer, you can also open the query designer again and modify it.

First, open the query analyzer and open the query file.

1. In the command window.

2. Enter modi query

3. Select the existing query file (the extension is qpr) in the query file selection box So far, the existing query is opened in the query analyzer, and you can do the following in the query designer

2. The following modifications can be made using the visual graphical interface.

Add or subtract from the data table.

Add or subtract query fields.

Make changes to the join keyword.

Modify the record filter.

Fix the sorting field and modify the grouping field.

In Miscellaneous, change whether there are duplicate records and whether or not to define the number of previous records to be displayed.

3. Directly modify the SQL statement.

In the query designer that you open, click SQL on the toolbar to open the SQL design window and directly modify the SQL statement.

4. Save the modification results

Click on the file to save it or press Ctrl+W on the keyboard to save the modification.

Table (.)dbf) database (..)dbc) form (..)

scx) tag (..)lbx) menu (..)mnx) project (.).

pjx) report (..)frx) program (.).PRG) text file (..)

txt） select ..from ..where...

update ..set...where...

delete ..from ..where...

insert...into...value...

The original VFP file extension is PRG

The extensions for other files used by VFP are as follows:

Documentation of the ACT Wizard operation diagram.

CDX composite index.

chm compiled html help

DBC database.

dbf table.

dbg debugger configuration.

DCT database notes.

DCX database index.

DEP-related files (created by the Setup Wizard).

DLL Windows Dynamic Link Library.

err compilation error.

ESL Visual FoxPro supported libraries. exe executable.

FKY macros.

FRX reports.

FXP compiled program.

idx index, compressed index.

lbx tags.

log range logs.

Documentation for the LST wizard list.

MEM memory variables.

MNT menu notes.

mnx menu.

MPR-generated menu program.

MPX Compiled Menu Program.

OCX ActiveX controls.

PJT Project Notes.

PJX Project.

The querier generated by PQR.

PRG Visual FoxPro program.

qpx compiled queryer.

SCT form notes.

SCX form.

TBK notes backup.

txt text.

Just save your select statement in the program.

Add a sentence do (database name) at the endqpr

1 I made a communication record by myself, but I didn't write any written report, I can give it to you if you want, but the written things won't help you.

Do you have a VFP design, address book management system? Can you send it to me, I have to hand in my homework too! My email address is.