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 #29428 is a reply to message #29425] Tue, 19 October 2010 16:21 Go to previous messageGo to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

porto wrote on Tue, 19 October 2010 16:34

I replaced original text whih "sometext" string.
connection time: 0.141
 total rows: 14600, timer: 0.000
1. sometext1
2. sometext2
3. sometext3
................
343. sometext343
344. sometext344
345. sometext345





Please, change the class constructor code like this:
OracleTest::OracleTest(){
	CtrlLayout(*this, "Window title");
	Sizeable().MaximizeBox().MinimizeBox().Maximize();
	String result;
	TimeStop v_timer;
	if(oracle_conn.Login("user", "pass", "host:port/SID", true)){
		result << "\n connection time: " << v_timer;
		v_timer.Reset();
		Sql sql(oracle_conn);
		if(sql.Execute("SELECT COUNT(*) FROM IKIS_ERS.INSUR_ANKT_A")){
			while(sql.Fetch())
				result << "\n total rows: " << sql[0];
			result << ", timer: " << v_timer;
			v_timer.Reset();
		}else result << "error: " << sql.GetLastError();
		
		if(sql.Execute("SELECT IAN_NAME1 FROM IKIS_ERS.INSUR_ANKT_A")){
			int i = 0;
			while(sql.Fetch()){
				++i;
				result << "\n" << i << ". " << sql[0];
			}
			
			result << ", timer: " << v_timer;
			v_timer.Reset();
		}else result << "error: " << sql.GetLastError();
	}else
		result << "error to connect";
	LogCtrl.Set(result);
}


replace connection parameters!

Write your result and attach the log file.

ADDED: change the code. add GetLastError().

[Updated on: Tue, 19 October 2010 16:26]

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: Wed Jul 16 18:31:23 CEST 2025

Total time taken to generate the page: 0.02898 seconds