| Subject | Re: [firebird-support] can't append something to a field |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2006-02-23T01:17:35Z |
Roberto Freitas wrote:
Yes, it's possible, just use the string concat operator ||
UPDATE Document
SET doc_data = doc_data || 'T'
WHERE doc_numb = 5638
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hi,Roberto,
> 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?
>
Yes, it's possible, just use the string concat operator ||
UPDATE Document
SET doc_data = doc_data || 'T'
WHERE doc_numb = 5638
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br