Click to See Complete Forum and Search --> : ADO.NET in managed c++


Lars_V_J
October 28th, 2009, 06:51 AM
First I have

CmySQL = new SqlCommand (CommandStr,singleton->GetCon());

where CommandStr is
SELECT sekv_nr FROM sekvens WHERE tabel_id = @tabid

Then I have
CmySQL->Parameters->Add(Field,SqlDbType::SmallInt,sizeof(Value),System::Int16(Value).ToString());
Where Field is "@tabid" and Value has the value 71

And finally I have
SqlDataReader *r = CmySQL->ExecuteReader ();

And I get the SQL error 8178: Prepared statement '%.*ls' expects parameter %.*ls, which was not supplied.

Edit: it is written as: Prepared statement '(@tabid smallint)SELECT sekv_nr FROM sekvens WHERE tabel_id
= @' expects parameter @tabid, which was not supplied.

Any idea what is wrong?
Thanks in advance

cilu
October 30th, 2009, 05:49 AM
What is Field? Is must be "@tabid".

You could also try this:

CmySQL->Parameters->Add(L"@tabid", SqlDbType::SmallInt);
CmySQL->Parameters[L"@tabid"]->Value = Value;