Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack
Message
De
30/03/2004 09:15:21
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
30/03/2004 03:06:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Pack
Divers
Thread ID:
00890674
Message ID:
00890739
Vues:
19
>Hello,
>
>if you can help me, how i can make (pack) for my table in the midnight

Mohammed,
Sorry but I think it's early for you to attempt to use pack programmatically. Don't get this wrong, I'm just trying not to cause irreversibl damages.

Instead of a direct pack, you might :

use myTable exclusive && Error check if you can
Set deleted off
select deleted() as _deleted, * from myTable into table _Backup
set deleted on
select * from myTable into table _Temp
select myTable
zap
append from _temp
use in '_temp'
erase _temp.dbf

It's almost identical to a single pack but you take 2 backups (one with deleted ones marked witha flag) and in case a power failure occurs, you've at least 1 copy of good data.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform