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

From: Reena <reena(dot)rekha(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Type of value has a mismatch with column typeCouldn't store <True> in viewimages_yn Column. Expected type is BitString.
Date: 2011-09-15 12:00:21
Message-ID: 1316088021681-4806517.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-09-15 13:24:42 Re: Cryptic Error Message Importing Table Dump
Previous Message Marc Mamin 2011-09-15 11:29:50 What do you like to get ?