U++ framework
Do not panic. Ask here before giving up.

Home » Community » Newbie corner » A trouble with "select" from Oracle DB
Re: A trouble with "select" from Oracle DB [message #29418 is a reply to message #29416] Tue, 19 October 2010 14:28 Go to previous messageGo to previous message
porto is currently offline  porto
Messages: 51
Registered: March 2007
Member
I thought if I will reduce length of the column with this code:
sql.Execute("select substr(IAN_NAME1, 1, 30) from IKIS_ERS.INSUR_ANKT_A");
int i = 0;
while(sql.Fetch())
i++;
Cout() << i;

it will help, but somehow it does not work. I get: i == 0. But it works if I get numberic value from the table:
sql.Execute("select substr(IAN_NUMIDENT, 1, 3) from IKIS_ERS.INSUR_ANKT_A");

Although normally works in the SQLPlus.

[Updated on: Tue, 19 October 2010 14:34]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon7.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: tar library for u++
Next Topic: Maybe stupid qustions for UPP developers...
Goto Forum:
  


Current Time: Fri Jun 19 06:35:20 GMT+2 2026

Total time taken to generate the page: 0.00673 seconds