Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery, Index and Transaction
Message
De
21/02/2002 06:09:03
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
21/02/2002 03:35:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00622396
Message ID:
00623035
Vues:
53
Gregory,

have seen all those CDX() - DBF() problems.
try
USE ..
INDEX ... TAG T1
REQUERY([...])
INDEX ... TAG T1
?dbf()
?cdx(1)
?cdx(2)
Or use debugger - its easyer to read. <s>


Let's say I run into erratic problems

I do testing on command window no matter if in VFP7.0 SP1 or VFP6.0 SP5.

Doing code like you suggest to
*Code 1
USE ..
INDEX ... TAG T1
do this do that
REQUERY([...])
DELETE TAG ALL
INDEX ... TAG T1
INDEX ... TAG T2
BEGIN TRANSACTION
may run if. May not. I change a little bit
*Code 2
USE ..
INDEX ... TAG T1
INDEX ... TAG T2
do this do that
REQUERY([...])
DELETE TAG ALL
INDEX ... TAG T1
INDEX ... TAG T2
INDEX ... TAG T3
BEGIN TRANSACTION
it fails.
If I immediate repeate
CLEAR ALL
*Code2
...
SUCCESS!

Now I clean up each and everything (QUIT?)
*Code2
...
success

Now I start playing in number of tags.

Sometimes it fails, but I can never repeat error.

Except one: Allways in SortIt <~@#€#!>

I can't close my view's ...

It's like running in circles.

Could be some cache?

Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform