Worksheet Style 101: Synchronize store database

Aug 27, 2005 3 Replies

Anybody knows exactly what style 101 does? I accidentally deleted an item in HQ, but the item still exists in Store, can I run 101 to restore the item in HQ?



TIA



Raymond


no, you can't!...

if you work with latest release of HQ the item isn't removed.. but only marked how DELETED ITEM..

your db and hq version? antonio

"Raymond Cheok" ha scritto nel messaggio news:BF390EC5.15A4B% snipped-for-privacy@fareastflora.com...

or a wrong reference from so/hq..

from hq administrator|database|query

SELECT * FROM HQRecordDeletedLog WHERE TableName = 'Item'

they are all items deleted from item table.

or SELECT * FROM Item WHERE Inactive = 1

antonio

HQ and Store is version 1.2.0186 Item in HQ is missing, so I guess its removed, its not marked deleted. Could it be data corruption?

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required