Relate Record ID to a replicated record question..

thetallbloke

Hi guys,

I have no idea where to ask this question in the forums so lets try it here...

I have a situation where I'm using SQL replication to replicate tables out of my NAV database to a separate SQL database..

I want to be able to replicate the "Record Link" table... actually replicating the table shouldn't be hard, but I just looked at the raw table data... in a Nav client, it says the "Record ID" value is "Item: 100000"... but the raw table data is some binary data or hex string value..

Record ID
0x1B000000008906313030303030000000

I was thinking that this was an internal value that the database knows about... kind-of like ROWID in Oracle..

Is there any way to take this record id value and actually figure out what item or whatever it relates to...???

Or do I have to add code to add the Item number or whatever to a new field when there is a record inserted into the table... I'm guessing that that isn't going to be possible given the table number... I haven't tried, but I doubt my license will allow it..

Any ideas...???

Thanks

kine

There is blog post which will help you do decript the data on SQL if you need...

http://blogs.msdn.com/b/microsoft_dynam ... erver.aspx

thetallbloke

Thanks...!!! I think...

I read this once and was left with a headache... :oops:

I've just printed it out to see if I can make some more sense of it... surely having it on paper will reduce my confusion..

I'm sure it will get me out of trouble in the end... Thanks heaps..

thetallbloke

Thanks Kine,

That link was awesome.. It actually does make sense...

I managed to port all that logic into .net code, and it seems to work ok..

It certainly works for my limited number of cases...