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 [email protected], "Anu Rang" <[EMAIL PROTECTED]> wrote: > > 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 > http://totallyfreeenergy.freehoxt.com > > --- In [email protected], "Anu Rang" <totallyfreeenergy@> > wrote: > > > > 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 > > http://totallyfreeenergy.freehoxt.com > > > > > > --- In [email protected], "iqbal_delphidev" > > <iqbal_delphidev@> wrote: > > > > > > 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: > > > TBlobField(Form1.ADOTable1.FieldByName(`Picture')).LoadFromFile > > > > (filename); > > > > > >
