function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
alex_from_75015alex_from_75015 

Dynamic query with large number (more than 10 digits) : System.QueryException

Hi

I need to build a dynamic query with large number

ipt__c and ipf__c are number with 18 digit

 

This request works

list <ip__c> mycompany_list= Database.query('select id, ipt__c, ipf__c from IP__c where  (ipf__c<=1932520400 and ipt__c>=1932520400)');

 

This request does not work

list <ip__c> mycompany_list= Database.query('select id, ipt__c, ipf__c from IP__c where  (ipf__c<=19325204002 and ipt__c>=19325204002)');

System.QueryException: For input string: "193252040024"

 

Can you please help ?

I have tried : "ipf__c<=19325204002L" with no success

Regards

 

alex_from_75015alex_from_75015

Hi

According to premium support, this is a bug !

Regards