>HI All,
>
>AS USAUAL I'M A BIT STUCK SO AM TURNING TO YOU GUYS FOR SOME HELP.
>
>I'm using a view and need to import from an external file. The Import is no problem.
>
>My Issue is that before i import i need to clear out ALL the records in the table. I am trying to stick with views and not use the actual tables. Now i know that i cant use Zap on the view, and delete all followed by tableupdate(.t.) has two problems
>
>1. it takes a long time ( about 2 mnutes for 6.5K records )
>2. i still have to access the actual tables at some point and do a pack
>
>
>Can someonme please tell me what i should be doing ?
>
>Regards
>
>TIA
>
>Colin
If You have to clear all records in Table (not the View) why not ZAP the table and then REQUERY() the view?
Or If You have to delete only theese records are in view You can just DELETE FOR/WHILE in Table and again REQUERY() the view.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.