Re: My Binary Experience

From: Scott Ferrett <surf_at_topspeed-dc.demon.co.uk>
Date: 1997/06/10
Message-ID: <VA.0000007f.00569117@surf.topspeed>#1/1

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) Received on Tue Jun 10 1997 - 00:00:00 CDT