Re: How to make the spaces be gone?

From: Alex Vinokur <alexander.vinokur_at_telrad.co.il>
Date: Mon, 18 Oct 1999 08:39:41 GMT
Message-ID: <7uemcd$69q$1@nnrp1.deja.com>

In article <7ue4do$qkq$1_at_nnrp1.deja.com>,   jdufour_at_home.com wrote:
> Alex,
>
> Try this in your ListRecords()function.
>
> . . .
> . . .
> . . .
> char col_value5[15];
>
> EXEC SQL VAR col_value1 is string;
> EXEC SQL VAR col_value2 is string;
> EXEC SQL VAR col_value3 is string;
> EXEC SQL VAR col_value4 is string;
> EXEC SQL VAR col_value5 is string;
> . . .
> . . .
> . . .
>
> This assumes you have stored the data as varchar2 in the DB and it
does
> not contain trailing spaces.
>

[snip]

---

Thank tou for yor answer.
It works OK.

---

It turns out that we don't have to add these statements

---

EXEC SQL VAR col_value1 is string;
EXEC SQL VAR col_value2 is string;
EXEC SQL VAR col_value3 is string;
EXEC SQL VAR col_value4 is string;
EXEC SQL VAR col_value5 is string;

---

It is enough to use the precompiler option CHAR_MAP=STRING.

Thanks,

        Alex

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 18 1999 - 03:39:41 CDT