Board index » delphi » Updating Blob field

Updating Blob field


The database to this test is Employee.gdb

I try do:

update project
set Proj_Desc = 'My project'
where Proj_ID='VBASE'

But the error 'Invalid modify request.' is displayed, what it means???

How I do to update a Blob field????



Re:Updating Blob field

Adriano Rodenbusch wrote:

> How I do to update a Blob field????

        You cannot assign a string constant to a Blob column in SQL.  You must
either use a parameterized query (this is what I recommend) or use a UDF
to translate your string constant into a Blob type.



Craig Stuntz (TeamB)       Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog:
Use Borland servers; posts via others are not seen by TeamB.
For more info, see

Other Threads