Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack issue on large DBF
Message
De
17/03/2015 22:33:45
 
 
À
17/03/2015 16:45:05
Denis Filer
University of Oxford
Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01616914
Message ID:
01616922
Vues:
54
Hi Denis,

Sometimes the PACK statement failed, but I don't know the reasons,
So I use the following code instead of the PACK statement:
=f_packdbf()

PROC f_packdbf

IF DBF()==""
RETU .F.
ENDI

IF !isexclusive()
RETU .F.
ENDI

PRIVATE m.q_alias
m.q_alias=ALIAS()

SELECT * FROM &q_alias WHERE !DELE() INTO CURSOR packdbf_tmp_&q_alias nofilter
SELE &q_alias
ZAP
APPEND FROM (DBF("packdbf_tmp_&q_alias"))
USE IN packdbf_tmp_&q_alias

RETU .T.

* END OF PROC F_PACKDBF.

Best regards.

Chen
2015.3.18
Welcome to VFP C++ Compiler: http://www.baiyujia.com/vfpcompiler
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform