ftempest / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 0 forks source link

Query for null (blank cell) in double fields fails with Error 5077 #75

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Build a query with a condition CurrencyFieldName equals [empty cell]
2. run Query Table
3.

What is the expected output? What do you see instead?
I see the following error message:

Error Generated by request::
Opportunity where Type = 'Renewal' and Original_Renewal_Value__c =''

ERROR at Row:1:Column:56
value of filter criterion for field 'Original_Renewal_Value__c' must be of type 
double and should not be enclosed in quotes
ExceptionCode : 5077

What version of the product are you using? On what operating system?  With
what Salesforce.com edition?
version 1603, Windows 7, Office 2010, Enterprise Edition

Please provide any additional information below.
This has been asked and solved for dates (example here: 
http://forums.sforce.com/t5/Other-Salesforce-Applications/Date-in-Query-gives-Er
ror-Generated-by-request-ExceptionCode/m-p/160107), but for doubles it seems to 
be different. I digged through the quotes trying to get NULL into the query 
string, but with no luck.

Original issue reported on code.google.com by arnt.haering@gmail.com on 16 Nov 2012 at 7:58

GoogleCodeExporter commented 8 years ago
I meant to say "digged through the code", not quotes

Original comment by arnt.haering@gmail.com on 16 Nov 2012 at 8:00