How does FoxPro update the data?

Before operating, back up the two ab tables in case of any eventuality, assuming that the ID of the table is a character attribute.

The command window enters modi comm pro to create an executable program, assuming the program is named.

modi comm pro

At this time, a new window opens, and the content entered in this window is the detailed content of this pro program, and the program content is as follows: (my method is applicable to both Windows and DOS versions of FoxPro).

After all the content of the following program is entered, please press Ctrl+W to save, and then double-click the pro file to execute, note that this program must be under the folder where the ab table is located, otherwise the path of the table must be added to the following program.

Open Table A in Zone 1 and queue it by ID.

sele 1

Use Ainde on ID to x1 to open table B in Zone 2.

sele 2

use bstore reccount() to nni=1do while i<=nn

sele 2

go istore trim(id) to bidstore class to bclasssele 1

find &bid

if .repl class with bclassendifsele 2

i=i+1endd

close all

Data update between data table files

Format: update on "Key Field" from "Alias" replace "Field Name1> with "Expression1>[, Field Name2> with "Expression2>.."

Example: Add the post salary in the RSDA library to the post salary in the RSDAGL library: (two database operations).

close databases &>Close all databases.

use rsda alias gwgz01 &> open rsda database and alias gwgz01

index on Name to xm01 &&& with name as keyword, index name xm01

Select B > Select Zone B.

use rsdagl alias gwgz02 &&& open the file management in zone B and add alias gwgz02

Sele A && Select the first opened RSDA alias A.

Update on Name from GWGZ01 Repl GWGZ with GWGZ+ > Add the GWGZ in the current library plus the alias GWGZ01 (RSDA) GWGZ in the library. It has been verified and feasible. **。

I said, you're updating a field, why are you looking up two values?

update a set = (select from b where ;

Alas, I don't know if you will give extra points, but I also wish you good luck

driver_temp='sql server'

server_temp=''

database_temp='biocclock'

uid_temp='sa'

pwd_temp='sa'connect_temp="driver="+driver_temp+";server="+server_temp+";uid="+uid_temp+";pwd="+pwd_temp+";database="+database_temp

con=sqlstringconnect(connect_temp)

if con<=0

messagebox( "Failed to connect to data! Please set it up again! ",0+16,"Prompt information")

return

endif data query text to cmd noshow

select * from user

endtext

if used('dsk')

select dsk

use endif

n1=sqlexec(con,cmd,"dsk")

if n1<0

messagebox('Command error!! '0+48,'System prompts')

return

endifselect DSK data storage transactions error=.f.

sqlsetprop(con, 'transactions', 2) & Start a manual transaction.

n1=sqlexec(con,"update gly set password = ?txt2 where number=?grbh")

if n1<=0

transactions_error=.t.

endifif transactions_error=.t.

sqlrollback(con)

chr(13)+chr(13),0+16,"Error message")

return

elsesqlcommit(con)

chr(13)+chr(13),0+48,"Prompt information",3)

endifsqlsetprop(con, 'transactions', 1) & Resume automatic transaction processing!

In the init event of this form, you write down the data source of this gird as the view, that is, you can get the data in the view again when the form is initialized.

The name of the view'Then you write the above ** in the getfocus event of the form, or in the chick event of the grid'The name of the view'

use aa

scan &> loops through each piece of data in the AA table.

select b1,b2,b3 from bb where b3= into array m

Find b1, b2, b3 that are equal to the current a3 of table a, and store them in the array m repl all a1 with m(1) a2 with m(2) while a3=m(3).

Replacement. endsuse

update table.

set date field ='This can be a fixed value, or a variable'

where (under what circumstances you need to update the field).

This method is called SPT mode, which refers to the SQL Pass Through function, referred to as SPT, that is, a form of sending SQL background commands to the SQL database for execution through this type of function, and then receiving the returned data.

There are generally two ways to use VFP to do C S programs, one is to use the remote view mode, and the other is to send the SPT mode of SQL commands directly.

The SPT method is more suitable for advanced users who are very familiar with SQL operations and SQL syntax, and it is better to use views for those who like to be lazy and do not know much about SQL, so that you can avoid thinking about many problems.

You can modify the temporary table, but if you want to delete or add it, you must use SQL commands to operate, and it is definitely possible to use the function sqlexec() to complete the operation on the SQL data table, and the commands used are generally SQL commands, such as delete and insert to add, and you can find answers to other questions. You can also find mine.

update a from Table 1 a, Table 2 b set where and <

VFP9 works, there is no guarantee that VFP6 will work.

Longer, huh? Big Big Big Big Daddy Daddy, is the turtle telling me really?

If the date field in the data table is named "Date", you can use the following command:

repl date with date() all

Of course, the date here is the current date of the system, if the system date of your machine is incorrect, you have to calibrate the system date before executing this command.