What I am trying to do is download a table from hq to the stores. I have set up the the table on hq and the stores. The table contains and id identity,hqid int and dbtimestamp. The table does not require any links to other tables in the store db so i have set options to 0. Do I need to populate the HQID field with anything or is that taken care of. I tried making the hqid field the same as the id field and that did not work, also tried hqid field as 0 and that did not work.
HQLog HQ-entering processworksheet_dataupload_synctables HQ-entering processworksheet_dataupload_synctables-Download updated records from table TabPromotions Store-Recieving message from HQ Store-CStateMachine:ExecuteState error -2147217862: Precision is invalid(unhandled error , state ='9') Store-connection will be aborted
the table sync row looks like this id TableName ToHQ ToStore options dbtimestamp
2 TabPromotions 0 1 0
thanks mark