Conversion from string to type 'Double' is not valid.

Posted by Adnan Badar on Stack Overflow See other posts from Stack Overflow or by Adnan Badar
Published on 2010-03-23T07:07:21Z Indexed on 2010/03/23 7:13 UTC
Read the original article Hit count: 244

Filed under:

query

|

oledbcommand

|

ms-access

Hi,

I am getting the following error while running a select statement (using OleDbCommand).

My query is

SELECT CME 
  FROM Personnel 
 WHERE CME = '11349D'

If objOleDbCom.ExecuteScalar() > 0 Then

When i execute the above statement i got this error

Conversion from string "11349D" to type 'Double' is not valid.

My field CME data type is Text

My database is Access 2007

I tried by running my query directly inside database and it is running fine.

Please suggest.

Thanks.

© Stack Overflow or respective owner

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More

Related posts about oledbcommand

VB.Net: exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, im getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath &… >>> More
Exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath… >>> More
Reading from excel using oledbcommand

as seen on Stack Overflow - Search for 'Stack Overflow'
In the below code instead of specifying the tab name.. Is there anyway we can just say "select * from [tab1]"? what ever the tab name might be.. OleDbCommand excelOledbCommand = new OleDbCommand("Select * From [Sheet1$]", excelOledbCon); >>> More
Does the Microsoft SQL Server native client support IDBAsynchNotify?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on some OLE DB code that runs queries on MS SQL Server via ICommand::Execute. I'm converting this code to operate asynchronously by setting the DBPROPVAL_ASYNCH_INITIALIZE property on the command before executing. I'd prefer to register a IDBAsynchNotify sink so that my code can be notified… >>> More
ADO.NET Command Classes - ExecuteNonQuery Method

as seen on Stack Overflow - Search for 'Stack Overflow'
I've heard that Microsoft accepts that the name of ExecuteNonQuery method of command classes was given inappropriate. Is there any official information about it, or it is just a rumour? >>> More