Menu

#3 No 0x in front of binary field

open-fixed
nobody
None
1
2003-07-07
2003-07-04
Andy Joiner
No

Nice piece of software!

Relates to v2.2.1

This is a minor bug. Binary fields should be prefixed with
0x when inserting.

Thanks for listening,
Andy

Export was:
INSERT INTO [htbInk] ([tablekey], [Ink],
[DeviceTablekey], [DeviceName], [SyncNo])
VALUES(57,
494e4b000000000000a1002d00170017808c000e008c000d
008e000c0091000c0094000d0097000f0097001100970014
009600180093001b0091001e0090001d0091001c0095001b
009a001b009b001d009b001e009a00210098002500970028
0096002b808e002a008c0029000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000, 1, 'MVSS1 ', 229)
GO

should have been

INSERT INTO [htbInk] ([tablekey], [Ink],
[DeviceTablekey], [DeviceName], [SyncNo])
VALUES(57,
0x494e4b000000000000a1002d00170017808c000e008c00
0d008e000c0091000c0094000d0097000f00970011009700
14009600180093001b0091001e0090001d0091001c009500
1b009a001b009b001d009b001e009a002100980025009700
280096002b808e002a008c00290000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
00000000000000000000000000000000, 1, 'MVSS1 ',
229)
GO

FYI:
-- Table structure for table 'htbInk'
CREATE TABLE [htbInk] (
[tablekey] int IDENTITY NOT NULL,
[Ink] binary,
[DeviceTablekey] int,
[DeviceName] char(10),
[SyncNo] int)
GO

Discussion

  • Andy Joiner

    Andy Joiner - 2003-07-07
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Andy Joiner

    Andy Joiner - 2003-07-07

    Logged In: YES
    user_id=813704

    Sorry - it works in 3.0b1

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.