Worksheet Style 101: Synchronize store database

Posted by Raymond Cheok on August 27, 2005, 1:35 pm

Please log in for more thread options

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

Posted by Antonio Mazzeo on August 29, 2005, 11:39 am

Please log in for more thread options

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

Posted by Raymond Cheok on August 29, 2005, 7:13 pm

Please log in for more thread options

On 8/29/05 5:39 PM, in article ehjzLyHrFHA.3016@TK2MSFTNGP12.phx.gbl,

> 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

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?

Posted by Antonio Mazzeo on August 29, 2005, 3:34 pm

Please log in for more thread options

> 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?

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