Delete items from table VIEWITEMMOVEMENTHISTORY.

My database is getting rather large and I am deleteing old records. There is one table, VIEWITEMMOVEMENTHISTORY, that has numerous records but when I try to delete the old records I get the error: UNION ALL view 'VIEWITEMMOVEMENTHISTORY' is not updatable because the definition contains a disallowed construct.

Does anyone know how to go about deleteing the records from this table?

Reply to
HankSmart
Loading thread data ...

That's not a table. It's a VIEW, which is sort of a stored query. A view does not contain actual records - it is a query that returns records from other table(s).

The best place to start reclaiming space is usually the journal table. I believe there are Knowledge Base articles on archiving available on Customer Source and Retail Realm has an archiving utility that will take care of it for you.

Glenn Adams Tiber Creek C> My database is getting rather large and I am deleteing old records. There is

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.