Skip to Content
avatar image
Former Member

MI 7.1: Obtain SYNC_KEY from DB

Hi experts,

I have a problem, i want obtain the SYNC_KEY from DB, but if i do the SELECT SYNC_KEY FROM table the SYNC_KEY appear: "001E4F1D754C1DDD8CC9420C1C8E587E", it has char, and should be only number.

How can convert it?

Thanks in advance,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 10, 2008 at 10:43 AM

    Hi,

    SYNC_KEY always refers to CHAR32 data element. So, SYNC_KEY may contain characters also. Could you tell me why you need conversion to number.

    Regards,

    Siva.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes - that is correct - and you can not change the sync key and you can not create an item with a sync key - nor have an empty item and set the sync key manually. this will not do what you expect!

      So you know you want to change the item with sync key "abcde" - so you select the item from the Max DB with SyncKey "abcde". This item you have now - so you change the value of the property name in this item - for example - and save it again.

      I do not really get your problem here.

      Regards,

      Oliver