Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
It does not reindex/refresh???
Message
From
21/05/1999 10:48:23
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
 
 
To
21/05/1999 10:33:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00221361
Message ID:
00221379
Views:
13
After appending data from Excel to the table, the Master tag is not indexed. It have to be manually reindex?

>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 = " "
Today is tomorrow's yesterday.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform