use my_local_or_remote_view index on KeyID tag KeyID of addbs(getenv('temp')) + 'AnyName' index on Descript tag Descript of addbs(getenv('temp')) + 'AnyName' BEGIN TRANSACTION TABLEUPDATE(0,.T.) END TRANSACTIONIt errors on the BEGIN TRANSACTION with the error: Table "alias" has one or more non-structural indexes open. Please close them and retry the Begin Transaction (Error 1548)
>>>use my_local_or_remote_view >>>index on KeyID tag KeyID of addbs(getenv('temp')) + 'AnyName' >>>index on Descript tag Descript of addbs(getenv('temp')) + 'AnyName'>>>Create as many index tags as you want and get NO READ-ONLY ERRORS! As a bonus, when you close the view, the temporary CDX file is removed also. As for coming up with a name for the CDX name, you can use sys(3) or some other variation of creating a temp. You no longer have to do the USE DBF() AGAIN IN 0 trick.