Re: Text searches in LONGRAWs / Delphi environment

Greg Felice wrote:
>
> To all,
>
> I'm converting a system from Interbase to Oracle.
> Interbase supports string searches in BLOB fields using the CONTAINING
> SQL expression. I don't have the time/money to use the Oracle con/text
> text search system, and need this functionality. I can't realistically
> change my data structure. What options do I have?
> Performance is not the key issue here; I just need the functionality,
> as our Interbase version worked very slowly anyway.
>
> Help!
>
> -Greg Felice
> www.compchannel.com

In Delphi, Oracle LONG RAWS are implemented as TBlobField. So, if you use a TTABLE, you can scan that table and for every row, scan the contents of the TBobField using the method GetData.
From the Delphi help example :

Example

{ Retrieve the "raw" data from Field1 }
with Field1 do
  begin
{ Allocate space }
  GetMem(Buffer, DataSize);
  if not Field1.GetData(Buffer) then
    MessageDlg(FieldName + ' is NULL', mtInformation, [mbOK], 0)   else { Do something with the data };
{ Free the space }
  FreeMem(Buffer, DataSize);
  end;

Just a possibility

Marc Received on Thu May 22 1997 - 00:00:00 CDT