You need to sign in to do that
Don't have an account?
VinH
Cannot select Probability from Opportunity table in sforce.
I have the following query in sforce explorer:
Select Probability from Opportunity
The query results in an error: "Query failed: Input string was not a correct format."
Can someone tell me why this error occurs, and how I can get the Probability from the Opportunity table?
- thanx
Try:
Select Probability from Opportunity Where Probability > 20.0
Or some other such where clause.
Gareth.
Thanx for the response.
It tried it, and other similar statements with different 'Where' clauses.
Still got the same error
However the following statement does work:
Select Id from Opportunity where Probability < 60
So it seems I can select records based on the Probability, but cannot retrieve the Probability itself.
- V
.
Hi
I'm using .NET directly and I can execute a query that returns "Probability". I have not tried it in the sforce explorer.
Cheers
Gareth.