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" <[EMAIL PROTECTED]> 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); > > >
