delphi ADO Blob Parameter InSize 5009 OutSize 5008 Problem

Thread View: borland.public.delphi.database

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Linkage Wed, 20 Dec 2006 08:57

#159

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads