RE: Use of TSQLServer

Hi,

This new oracle plugin is still very much in development. GetRowCount is indeed not yet implemented. The rest should have worked :(. We will look into it as soon as possible.

Thanks for reporting this problem.

Cheers,
Philippe.

-----Original Message-----
From: owner-roottalk_at_pcroot.cern.ch [mailto:owner-roottalk_at_pcroot.cern.ch] On Behalf Of Marina Giunta
Sent: Wednesday, April 06, 2005 10:55 AM To: Roottalk
Subject: [ROOT] Use of TSQLServer

Hello,
I am trying to use ROOT with data stored in an Oracle db.

I perform a query using:
TSQLResult *res=db->Query(SELECT element_id, element_name FROM elements); I know the query returns the right number of rows, because by looping over them I get the right total number,but using:

int rowNr = res->GetRowCount();

I obtain as result -1.

Then, res->GetFieldCount() gives as result 2, but then, if I try to get the contents of the fields using TSQLRow::GetField(Int_t field), if I use row->GetField(0)
root crashes without any error message, with row->GetField(1)
I get a result that I tried to convert to a string, but I get only strange outputs and with
row->GetField(2) I get the message:
Error in <TOracleRow::IsValid>: field index out of bounds

How do I get the contents of my two fields?

Thanks

              Marina

-- 
Marina Giunta 


-----------------------------------------------

Department of Physics,   | At CERN
UC Riverside,            | OFF: 28-2-006
Riverside CA92521 USA    | TEL: +41-22-76-78178   


-----------------------------------------------