U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Community » Newbie corner » A trouble with "select" from Oracle DB

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: A trouble with "select" from Oracle DB [message #29418 is a reply to message #29416]

Tue, 19 October 2010 14:28

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

[Message index]

		A trouble with "select" from Oracle DB By: porto on Mon, 18 October 2010 15:52
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 09:28
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 09:43
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 10:02
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 10:35
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 10:46
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 10:53
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 11:33
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 13:15
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 13:35
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 13:53
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 14:28
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 14:44
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 15:15
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 15:34
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 16:21
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 16:31
		Re: A trouble with "select" from Oracle DB By: tojocky on Tue, 19 October 2010 17:00
		Re: A trouble with "select" from Oracle DB By: porto on Tue, 19 October 2010 17:14
		Re: A trouble with "select" from Oracle DB By: tojocky on Wed, 20 October 2010 09:15
		Re: A trouble with "select" from Oracle DB By: porto on Wed, 20 October 2010 09:54

Previous Topic:	tar library for u++
Next Topic:	Maybe stupid qustions for UPP developers...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu May 16 01:15:17 CEST 2024

Total time taken to generate the page: 0.02863 seconds