delphi ADO Blob Parameter InSize 5009 OutSize 5008 Problem

Article View: borland.public.delphi.database

Article #159

Back to borland.public.delphi.database Previous Next

#159

From: Linkage
Date: Wed, 20 Dec 2006 08:57

17 lines
1592 bytes

LParameter:=TestAQY.Parameters.AddParameter;
LParameter.Name:='DATA';
LParameter.DataType:=ftBlob;
LParameter.LoadFromFile('CRW');  // Data Size 5009
TestAQY.SQL.Text:='UPDATE TEST SET DATA=:DATA WHERE ID=1';
TestAQY.ExecSQL;

TestAQY.SQL.Text:='SELECT ID, DATA FROM TEST WHERE ID=1';
TestAQY.Open;
TBlobField(TestAQY.FieldByName('DATA')).SaveToFile('CRO'); // DataSize
5008 Size -1 


Size is not 2Byte Code Auto Resize ? 


plz... Help Me

Technical Details

Message-ID: <1166605072.444920.26220@f1g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!f1g2000cwa.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,c91f5eaf6a9b61e5,start
X-Google-Attributes: gid115d96,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!f1g2000cwa.googlegroups.com!not-for-mail
From: "Linkage" <linkage8055@hotmail.com>
Newsgroups: borland.public.delphi.database
Subject: delphi ADO Blob Parameter InSize 5009 OutSize 5008 Problem
Date: 20 Dec 2006 00:57:52 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <1166605072.444920.26220@f1g2000cwa.googlegroups.com>
NNTP-Posting-Host: 125.189.138.28
Mime-Version: 1.0
Content-Type: text/plain; charset="euc-kr"
X-Trace: posting.google.com 1166605078 20965 127.0.0.1 (20 Dec 2006 08:57:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 20 Dec 2006 08:57:58 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f1g2000cwa.googlegroups.com; posting-host=125.189.138.28;
   posting-account=E1DKrQ0AAAAMfj151ILkuNIS_XqwJ1gY