Re: My Binary Experience

From: Werner <werner.smit_at_baps.com>
Date: 1997/06/12
Message-ID: <33A05D73.663E@baps.com>#1/1

Scott Ferrett wrote:
>
> In article <33973D8C.4194_at_baps.com>, Werner wrote:
> > TmpSql = 'INSERT INTO "WERNER"."TEMPVAR" ' & |
> > '("Number","Name","Minutia") ' & |
> > 'VALUES(' & |
> > '''' & Enr:Pin_No & ''' ,' & |
> > '''' & Enr:Name & ''' ,' & |
> > Clip(TmpSql)
> > TmpSql = Clip(TmpSQL) & ')'
>
> All you need to do is use the function ADD() rather than writing your
> own SQL. This will then send your data as binary, not as part of an
> SQL statement.
>
> SuRF Down Under
> (TopSpeed R&D)

Unfortunately this is not true.

I was using an ADD, and it did not work - this is why I had to resort to using my own SQL.
I you try to add the string 'Scott<0>Ferret' it will NEVER work. You will always add 'Scott'... Received on Thu Jun 12 1997 - 00:00:00 CDT