Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread How to save binary data using sql...
Tue, Feb 10 2009 2:31 PMPermanent Link

Uli Becker
Roy

> OK - fuller version.

Now I got it. Smiley

I didn't see that your post was an answer to Tim's reply - I thought it
was for me Smile

Uli
Tue, Feb 10 2009 6:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Out of interest could you do something like
ParamByName('Contents').AsString := ' X''01F21028''; >>

The problem is the data type of the parameter.  If you use AsString, you
will end setting the data type to a string.  What you need is the
TParam.AsBlob property, and you cannot format the binary data as an SQL hex
string constant.  A parameter expects the data in its "raw" binary format,
not formatted as a constant.

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image