Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
It does not reindex/refresh???
Message
De
21/05/1999 10:33:42
 
 
À
21/05/1999 10:19:09
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00221361
Message ID:
00221370
Vues:
13
What do you mean by "is not reindexed after APPEND"?

>The follow are the coding I have created... the question is how come the WORKPO.DBF is not reindexed after APPEND?
>
>leavenow=.F.
>SET ESCAPE OFF
>SET MULTILOCKS ON
>ON ERROR DO getout
>LOCAL laTables, lcTableName, lcKey
>OPEN DATABASE encum EXCLUSIVE
>DIMENSION laTables[1]
>ADBOBJECTS(laTables, "TABLE")
>FOR EACH lcTableName IN laTables
> USE (lcTableName) EXCLUSIVE IN 0
> IF leavenow=.T.
> CLOSE ALL
> EXIT
> ENDIF
> SELECT (lcTableName)
> lcKey=DBGETPROP(lcTableName, "TABLE", "PrimaryKey")
> SET ORDER TO &lcKey
>ENDFOR
>
>IF leavenow=.T.
> RETURN
>ENDIF
>SET ESCAPE ON
>ON ERROR
>
>*the remaining of the program starts right here...
>SELECT poencr
>APPEND FROM poencr.xls TYPE XLS
>GO TOP
>DELETE
>PACK
>SELECT workpo
>APPEND FROM poencr
>REPLACE ALL date WITH DATE()
>REPLACE blanket WITH "40" FOR blanket = "GEN"
>REPLACE blanket WITH "43" FOR blanket = "BLK" OR blanket = " "
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform