Re: how to convert datatypes ?
Posted in 1996
Topics: Stored Procedures & SPL
Michael Agbaglo wrote:
>
> create procedure foo()> define i integer;
> define s string;
>
> let s = "asdfsa" + i + "dsgdfsg";
> end procedure;
>
> 1213: implicit character to numeric conversion
>
> REALLY NICE !
You are implying numeric arithmetric with the '+'. When in fact you require
string concatenation, such as:
LET s = "asdfsa" || i || "dsgdfsg";
I believe someone did suggest RTFM. If this doesn't translate into German,
then let me explain:
READ THE MANUAL!
Cheers,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+