Pro*C - extra space after variables

From: Clint Eastwood <cjundieseastwd_at_powerup.com.au>
Date: Tue, 07 Dec 1999 07:08:11 GMT
Message-ID: <82ibdf$1ac9_at_inetbws1.citec.com.au>

HiYa

[Quoted] [Quoted] wow ... getting some milage today ... :-)

I am finding that if I do something like this:

EXEC SQL SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')

         INTO :order_details_rec->p_element->order_place_date_time
         FROM dual;

that the output of a printf on the item is: IE

printf("--%s-- is the date\n",
  order_details_rec->p_element->order_place_date_time);

--07-DEC-1999 16:57:06 -- is the date

where is the extra space coming from?? I've even tried to rtrim it, and it still has the spaces...

thanks

Ohhh Pro*C/C++: Release 2.2.3.0.0

thanks :-)

See Ya
(when the bandwidth gets better ;-)

Chris Eastwood                            Please remove undies for reply

Photographer, Stunt Programmer
Motorcyclist and dingbat Received on Tue Dec 07 1999 - 08:08:11 CET