Mercea Paul wrote: > FbCommand cmdGetSypParam = new FbCommand(); > > cmdGetSypParam.CommandText = "SYS_GET_PARAM";
Try to use here select * from SYS_GET_PARAM(@param, ...). > cmdGetSypParam.CommandType = CommandType.StoredProcedure; > > cmdGetSypParam.Parameters.AddWithValue("PCODE", cod); > > cmdGetSypParam.Parameters.AddWithValue("PSUBSYSTEM", ss); > > cmdGetSypParam.Connection = fbsyspar; > > fbsyspar.Open(); > > > > val = cmdGetSypParam.ExecuteScalar().ToString(); -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider