| |

VerySource

 Forgot password?
 Register
Search
View: 2038|Reply: 4

Use the mchk->Delete() command to delete the contents of the data table mchk.dbf in the file directory, but it cannot be

[Copy link]

1

Threads

3

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-12-18 09:00:01
| Show all posts |Read mode
I use the Table control in C++BUILDER to connect to the data table mchk.dbf in the file directory, and then use the code Delete() to delete the record after retrieving the data in the table, but a problem is that although it is deleted (normal state I can’t find the deleted content, such as opening it with EXCEL), but I opened the data table with visual foxpro and found that the deleted records were just marked. How can I delete these data completely with the code~! Thanks in advance~!
Reply

Use magic Report

0

Threads

27

Posts

24.00

Credits

Newbie

Rank: 1

Credits
24.00

 China

Post time: 2020-12-18 09:15:01
| Show all posts
The essence of database deletion seems to be like this
Anyway, if an ACCESS library is simply deleted, the file will not be reduced at all
Reply

Use magic Report

1

Threads

3

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-12-19 12:15:01
| Show all posts
The problem is that I want to import the data table into the inventory gun. If there is such data, it will cause the inventory program to retrieve the deleted ones. At present, I can only use the pack command to purify the data table, but it causes the inventory program to start up. It runs slowly, so I want to solve this problem from the source~!
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-12-19 17:00:01
| Show all posts
The DELETE of the DBF table is just to delete the mark by itself. It must be PACK to be completely deleted. I haven't used DBF for a long time.
Reply

Use magic Report

1

Threads

3

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-12-19 18:15:01
| Show all posts
Does the Table control in C++BUILDER have the corresponding code to realize the function of PACK?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list