Thread: Type of value has a mismatch with column typeCouldn't store in viewimages_yn Column. Expected type is BitString.

Type of value has a mismatch with column typeCouldn't store <True> in
viewimages_yn Column.  Expected type is BitString.


Iam getting this error when iam using bit field and assinging to datatable..

The code is below.....

 Dim sql As String = "select * from Users where UserName = @param1"
        Dim cmd As DbCommand = m_objDatabase.GetSqlStringCommand(sql)
        m_objDatabase.AddParameter(cmd, "@param1", DbType.[String], 30,
ParameterDirection.Input, False, 0, 0, [String].Empty,
DataRowVersion.[Default], "Steven")
        'm_objDatabase.AddInParameter(cmd, "param2", DbType.[String],
"Eastern")
        Dim ds As DataSet = m_objDatabase.ExecuteDataSet(cmd)


Iam getting error as
Type of value has a mismatch with column typeCouldn't store <True> in
viewimages_yn Column.  Expected type is BitString.

please help me to solve this error...


Thank and Regards
Reena







--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Type-of-value-has-a-mismatch-with-column-typeCouldn-t-store-True-in-viewimages-yn-Column-Expected-ty-tp4806517p4806517.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.