Subject Re: [firebird-support] can't append something to a field
Author Steve Wiser
try:

UPDATE Document
SET doc_data = doc_data || 'T'
WHERE doc_numb = 5638

(assuming doc_data is not null)

-steve

Roberto Freitas wrote:
> Hi,
> I've submited this sentence to other DataBases with success, but with
> WI-V1.5.2.4731 Firebird 1.5 I get ISC Error Message Dynamic SQL Error
> expression evaluation not supported:
>
> UPDATE Document
> SET doc_data = doc_data + 'T'
> WHERE doc_numb = 5638
>
> Is not possible to append something to a field with Firebird?
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>