Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack issue on large DBF
Message
From
17/03/2015 22:33:45
 
 
To
17/03/2015 16:45:05
Denis Filer
University of Oxford
United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01616914
Message ID:
01616922
Views:
55
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
Previous
Reply
Map
View

Click here to load this message in the networking platform