Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » Community » Newbie corner » A trouble with "select" from Oracle DB
Re: A trouble with "select" from Oracle DB [message #29403 is a reply to message #29396] Tue, 19 October 2010 09:28 Go to previous messageGo to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

porto wrote on Mon, 18 October 2010 16:52

I have a problem with selecting data from the DB (Oracle ver. 10.2). The database has a table that contains 14,124 rows. When I try to fetch data with this code:
Oracle8 oracle;
oracle.Open("user/pass@server/db", false));
Sql sql(oracle);
sql.Execute("select * from IKIS_ERS.INSUR_ANKT_A");
while(sql.Fetch())
Cout() << sql[0] << "\n";

I get only 345 rows.


I fetched from a table more than 1000 rows. it was not problems.
I will try to fetch more than 10 000 rows to test your problem.
The problem can be:
If you run in terminal with non GUI then in terminal you can view only last 3XX rows.
Try to put your output in file and count rows.
porto wrote on Mon, 18 October 2010 16:52


When I try to select data from the database using the same SQL query with "SQLPlus Worksheet" (its a tool from Oracle), I get 14,600 (why not 14,124 I don't know).



seems your oracle db or client has problems. Check it twice.

[Updated on: Tue, 19 October 2010 09:35]

Report message to a moderator

[Message index]
 
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:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu May 16 04:07:41 CEST 2024

Total time taken to generate the page: 0.02551 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.5.
Copyright ©2001-2013 FUDforum Bulletin Board Software