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   


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