[DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy Coulter
Hi All. I am just working thru converting a D2007 app to D2010. Its taken me most of the moring to get updated controls, install them, convert strings etc.etc. but this one has stumpted me. I am inserting some data into a blob field in Interbase like so (or similar)

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Colin Johnsun
Sounds like a Unicode issue. The default string in D2010 is a unicode string. Can you use: IBQuery1.ParamByName('blobby').AsString := 'blah blah blah'; ? Colin On 4 March 2010 11:08, Jeremy Coulter jscoul...@gmail.com wrote: Hi All. I am just working thru converting a D2007 app to D2010.

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy Coulter
well, the thing is, this IS a blob field not a string field. but I will give it a try Jeremy On Thu, Mar 4, 2010 at 2:17 PM, Colin Johnsun colin.a...@gmail.com wrote: Sounds like a Unicode issue. The default string in D2010 is a unicode string. Can you use:

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Colin Johnsun
Well alternatively, you can try passing in an AnsiString into your blob field. I haven't tried it myself but it may be worth a go. Colin On 4 March 2010 12:21, Jeremy Coulter jscoul...@gmail.com wrote: well, the thing is, this IS a blob field not a string field. but I will give it a try

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy Coulter
yeah I tried that and it didnt like it. Jeremy On Thu, Mar 4, 2010 at 2:36 PM, Colin Johnsun colin.a...@gmail.com wrote: Well alternatively, you can try passing in an AnsiString into your blob field. I haven't tried it myself but it may be worth a go. Colin On 4 March 2010 12:21, Jeremy

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy North
Use the new BytesOf functions in the SysUtils unit. TBytes is just an array of TByte. There is also a PlatformBytesOf function that you could use. You may also want to investigate the TEncoding class while you are at it. On Thu, Mar 4, 2010 at 11:08 AM, Jeremy Coulter jscoul...@gmail.com wrote:

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Edward Koryagin
Can we do IBQuery1.ParamByName('blobby').Value := 'asdfdas'; Edward Koryagin --- On Thu, 4/3/10, Jeremy North jeremy.no...@gmail.com wrote: From: Jeremy North jeremy.no...@gmail.com Subject: Re: [DUG] Interbase Blobs in Delphi 2010 To: NZ Borland Developers Group - Delphi List delphi

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy Coulter
...@gmail.com wrote: From: Jeremy North jeremy.no...@gmail.com Subject: Re: [DUG] Interbase Blobs in Delphi 2010 To: NZ Borland Developers Group - Delphi List delphi@delphi.org.nz Received: Thursday, 4 March, 2010, 3:00 PM Use the new BytesOf functions in the SysUtils unit. TBytes is just

Re: [DUG] Interbase Blobs in Delphi 2010

2010-03-03 Thread Jeremy Coulter
...@yahoo.co.nzwrote: Can we do IBQuery1.ParamByName('blobby').Value := 'asdfdas'; Edward Koryagin --- On Thu, 4/3/10, Jeremy North jeremy.no...@gmail.com wrote: From: Jeremy North jeremy.no...@gmail.com Subject: Re: [DUG] Interbase Blobs in Delphi 2010 To: NZ Borland Developers Group