Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Error with binary string literal
Sun, May 27 2007 1:05 PMPermanent Link

"Ole Willy Tuv"
Tim,

I'm getting the following error:

ElevateDB Error #1011 An error occurred with the value  (A conversion error
occurred)

when using large binary string literals (bmp images) in insert statements.

I've posted a text file with the DDL for the Northwind.Employees table with
images in the binaries group.

Ole Willy Tuv

Tue, May 29 2007 5:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ole,

<< I'm getting the following error:

ElevateDB Error #1011 An error occurred with the value  (A conversion error
occurred)

when using large binary string literals (bmp images) in insert statements.

I've posted a text file with the DDL for the Northwind.Employees table with
images in the binaries group. >>

The issue is the CRLF pairs that are inserted by the TMemo control since the
literal value is so long.  I'll have to think about this some more since I'm
not sure how to work around this in the EDB Manager since the TMemo
functionality is "set in stone" and I really can't just strip out CRLFs
since sometimes they are actually desired and intentional.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, May 29 2007 7:37 PMPermanent Link

"Ole Willy Tuv"
Tim,

<< The issue is the CRLF pairs that are inserted by the TMemo control since
the literal value is so long.  I'll have to think about this some more since
I'm not sure how to work around this in the EDB Manager since the TMemo
functionality is "set in stone" and I really can't just strip out CRLFs
since sometimes they are actually desired and intentional. >>

Ah - I understand the TMemo problem. Is there any other control you can use
in EDB Manager ? The TMemo functionality makes the binary string literal
useless.

Ole Willy Tuv

Tue, May 29 2007 8:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ole,

<< Ah - I understand the TMemo problem. Is there any other control you can
use in EDB Manager ? The TMemo functionality makes the binary string literal
useless. >>

Well, I intend to replace the TMemo with something that supports syntax
highlighting, so I'll have to address this issue at the same time.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, May 30 2007 9:28 AMPermanent Link

"Ole Willy Tuv"
Tim,

<< Well, I intend to replace the TMemo with something that supports syntax
highlighting, so I'll have to address this issue at the same time. >>

Good idea. Syntax highlighting would be very nice.

Ole Willy Tuv

Image