Board index » delphi » Updating Blob field

Updating Blob field

Hi

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????

Thanks

 

Re:Updating Blob field


Quote
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.

        HTH,

        -Craig

--
Craig Stuntz (TeamB)       Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog:   http://delphi.weblogs.com
Use Borland servers; posts via others are not seen by TeamB.
For more info, see http://www.borland.com/newsgroups/genl_faqs.html

Other Threads