delphi clears access data

Executed in one data control.

alter table name alter column id counter (1, 1).

That's it. sql_str:='alter table name alter column id counter (1, 1).';

false;;;

except

* Error emptying database. '),'Warning',mb_ok);

exit;end;

with aquery do

beginclose;;'delete from the table name');execsql;

end;When this is done, the contents of the table will be cleared without damaging the structure of your table.

Clear access data with **. For example, delete from your table name, etc.

Directly connected tables can be directly updated to the data in access.

If you are using ClientDataset, you can compare whether it has been changed row by row and update the data in the database if the amount of data is not too large. If the volume of large data. Generally, it is necessary to set an update field or variable, and only the changed records are updated when updating.

access can also use the update statement.,It's okay to really use update.。

A very convenient way to do this is the db control, which can modify the data directly!

In'drop table'+sghz);This sentence is followed by a sentence execsql;

procedure : tobject);

varsghz:string;

beginsghz:='Puzzle table';

with adoquery9 do

beginclose;

drop table'+sghz);

open;showmessage('The problem table in the database has been deleted! ')end;end;

What kind of way to look at this?

Executed in one data control.

alter table name alter column id counter (1, 1).

That's it. sql_str:='alter table name alter column id counter (1, 1).';

false;;;

except

* Error emptying database. Warning',mb_ok);

exit;end;

Why take the first row and the first column?

You can compensate for a condition to get a record (i.e., a row in **) and then take a field of that record (i.e., a column in **).

Add a user field to the data table.

When a user logs in, a global variable is used to record the user name, and when the user opens the database table, a condition is used to query the data entry entered by the user.