firebird-net-provider

[Firebird-net-provider] question ExecuteScalar

[Pavol S. <pa...@st...>]

hi,

i have question:

what object is result of fbCommand.ExecuteScalar()???

directly how to cast this???

string genQuery = "SELECT GEN_ID(GENARTICLEID, 1) FROM RDB$DATABASE";
FbCommand dbCmd2 = new FbCommand(genQuery, dbConn, dbTran);
int fID = dbCmd2.ExecuteScalar(); <- ?????? cast to (int) is not working

p.

Re: [Firebird-net-provider] question ExecuteScalar

[<car...@te...>]

Hello:

> string genQuery = "SELECT GEN_ID(GENARTICLEID, 1) FROM RDB$DATABASE";
> FbCommand dbCmd2 = new FbCommand(genQuery, dbConn, dbTran);
> int fID = dbCmd2.ExecuteScalar(); <- ?????? cast to (int) is not working


Test with this:

	int fID = Convert.ToInt32(dbCmd2.ExecuteScalar());



Best regards
Carlos Guzmán Álvarez
Vigo-Spain