Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this DELETE is so slow?
Message
From
22/02/2005 14:25:57
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988740
Message ID:
00989364
Views:
49
Hi Andrew,

Go into VFP9 Locking Data section.

For DELETE - SQL you can read Current record

Now, a DELETE SQL command is a command where the operation
is set based.
Then, what is it a "Current record" ?
- It is any scanned record
- it is any matched record
...

Every time i read the documentation,
this comes me in mind:
I say something to you,
if you have already understood it then you understand,
otherwise you will not understand nothing


Another example on the same page:
TABLEUPDATE( )   Depends on buffering
much clear one!

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform