Subject | Re: [IBO] |
---|---|
Author | IB Objects |
Post date | 2003-08-01T23:25:36Z |
> I have a table which stores images . I have a blob and some other fields .I'm guessing you could write a program where you have an update statement:
> The other fields are already filled (I did not use IBO). The blob field
> which stores images has to be filled. I am using ib_image component, but I
> failed to update or insert the field. Can any one help me to to this.
UPDATE TABLE
SET MYBLOBCOL = :ABLOBPARAM
WHERE MYKEY = :AKEYPARAM
Prepare it and then loop through your records and call ExecSQL for each
record to be inserted.
MyUpdateQry.Prepare;
<start transaction>
while not <EndOfRecordsToProcess> do
begin
...
MyUpdateQry.Params[ 0 ].LoadFromFile( AFilename );
MyUpdateQry.Params[ 1 ].AsString := KeyValueAsString;
MyUpdateQry.ExecSQL;
...
end;
<commit transaction>
HTH,
Jason Wharton