Subject | Re: [firebird-support] updating blob field with stored procedure |
---|---|
Author | Simeon Mitev |
Post date | 2004-10-21T12:29:04Z |
this works fine ! :)))))))
DataSet.CommandType := ctStoredProc;
DataSet.CommandText := 'SP_DO_USER_PICTURE';
DataSet.Params.ParamByName('fk_user_id').AsInteger := CurrentUserID;
DataSet.Params.ParamByName('user_picture').LoadFromFile(GetPictureDlg.FileName,
ftGraphic);
DataSet.ExecSQL;
DataSet.Close;
Alan McDonald wrote:
DataSet.CommandType := ctStoredProc;
DataSet.CommandText := 'SP_DO_USER_PICTURE';
DataSet.Params.ParamByName('fk_user_id').AsInteger := CurrentUserID;
DataSet.Params.ParamByName('user_picture').LoadFromFile(GetPictureDlg.FileName,
ftGraphic);
DataSet.ExecSQL;
DataSet.Close;
Alan McDonald wrote:
>>this is ok, then how can i store into that .asBlob field a bitmap object ?
>>
>>Alan McDonald wrote:
>>
>>
>>
>
>I use IBO and use the Assign method.
>Alan
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>