Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do i know how many records i have deleted?
Message
 
To
16/11/2004 11:48:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00961768
Message ID:
00961770
Views:
6
There are to methods that comes into my mind:
1. to use COUNT
COUNT TO nRecForDeletition FOR/WHILE delition_condition
? nD
2. to use SELECT
SELECT COUNT(*) FROM YourTable WHERE delition_condition INTO ARRAY aForDeletion
? aForDeletion[1]
In both cases You can use _TALLY


>Hello, i'd like to know how many records do i have deleted and the information within?
>
>thanks for the help.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform