Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Exclamation Unanswered: URGENT***Update Openquery (linkedserver, 'select...) Set Field = #

    After running the following OpenQuery...

    UPDATE OPENQUERY(LINKEDSERVER, 'SELECT START_ORDER_NO FROM "OECTLFIL" WHERE "FILE_KEY" = 1')
    SET START_ORDER_NO = 0

    ----The START_ORDER_NO field contains a 48

    SET START_ORDER_NO = 1~9

    ----The START_ORDER_NO field contains 49~57 respectively.

    SET START_ORDER_NO = 10
    ---The START_ORDER_NO field contains 12337
    SET START_ORDER_NO = 11
    ---The START_ORDER_NO field contains 12593
    SET START_ORDER_NO = 12
    ---The START_ORDER_NO field contains 12849

    incrementing by 256 as I increase the value passed...

    ASCII 48-57 are the characters 0-9. The string '10' consists of the two bytes with the values 49 (0x31) and 48 (0x30). It is being viewed in reverse byte order as the value 0x3031 which equals 12337 (48*256 + 49).

    The LinkedServer is Pervasive SQL 2000i using 'OLE DB Provider for ODBC'

    The START_ORDER_NO field is a Numeric(8,0)

    I'm thinking some kind of Unicode, or translation or code page issue, but I haven't had any luck yet.

    I'm not sure how difficult this is, I don't think I'm a neophyte but I'm feeling like one...
    Last edited by BobKaine; 09-23-04 at 17:26.

  2. #2
    Join Date
    Sep 2004
    Posts
    4

    Question Nobody has a clue????

    Doesn't anybody have any idea what is going on here????

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •