It took more than a day of tinkering with the code. I had to grope my
way around it without the ADO help installed on my pc. Update of Blob
can be easily done without using Parameters. The ADOTable component
has good inbuilt functionality for this. For more details on this
look out for the posting on the yahoo forum Shareware_Builders. I
should be able to get around to it in a day or two. This update is
for any future `Googlers' searching for ADOTable help

Thanks for all input on this.

Anu Rang, TotallyFreeEnergy
http://totallyfreeenergy.freehoxt.com

--- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "Anu Rang" <totallyfreeenergy...>
wrote:
>
&gt; It is probably a messy way to do it.
> I have to create the parameter in the ADOQuery object and then set
> the parameter value before executing the SQL statement. Another
day's
> tinkering with the code. Nearly there :(
>
> Anu Rang, TotallyFreeEnergy
&gt; http://totallyfreeenergy.freehoxt.com
>
> --- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "Anu Rang" <totallyfreeenergy>
> wrote:
&gt; >
>; > Thank you. Yes I have corrected this error. My main problem is
> infact
> > that I have absolutely no idea how to action SQL UPDATE on a
> TBlobField
> > object. I am thinking it may have to be passed in as parameter. I
> am
> > not sure which wrapper has this capability. ADOQuery has
> a 'Parameters'
> > which I think is a list. I am just not clear on this at all. I
will
> > have to search the net.
>; >
> > Anu Rang, TotallyFreeEnergy
&gt; > http://totallyfreeenergy.freehoxt.com
> >
> >
> > --- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "iqbal_delphidev"
> > <iqbal_delphidev> wrote:
&gt; > >
>; > > Anu,
>; > > This error raised when you try to make changes in 'TADOTable'
> when
> > its
> > > not in Edit or Append mode. To fix this problem just put a line
>; > >
> > > ADOTable1.Edit;
>; > >
> > > before this line:
&gt; > > TBlobField(Form1.ADOTable1.FieldByName(`Picture')).LoadFromFile
> > > > (filename);
> > >
>; >
>;

Messages in this topic (5) Reply (via web post) | Start a new topic

.