Hi,

Could someone please help me with this code ? I am trying to paramterize the code and passing the feild name from another table but this is not working Px.vtype.Field_Name__c

​    public PageReference Submit() {
    //----------------------- Code to validate Patient Sevice file ---------------------    
        for(PatientServices__c Px: PSUpload )
        {    
            for (PHI_Configuration__c PC :[Select Field_Name__c,Validation_Type__c, Order__c from PHI_Configuration__c where Table_Name__c ='PHI__c' ])
            {
                for( String vtype :PC.Validation_Type__c.split(';')){
                    if(vtype='Null Value Check')
                        isNullValue(Px.vtype.Field_Name__c);    
                }
            }    
        }
        return null;
    }

 

We are building a solution on the Force.com platform with AWS as the backend. The data is uploaded on the Force.com environment and has to be pushed to the SQL server hosted on AWS. I am looking for different ways to achieve data integration between Salesforce and SQL servers on AWS.  

Could you please recommend your options. I would prefer to use native APEX code to call the SQL Server API's .


 

Hi,

Could someone please help me with this code ? I am trying to paramterize the code and passing the feild name from another table but this is not working Px.vtype.Field_Name__c

​    public PageReference Submit() {
    //----------------------- Code to validate Patient Sevice file ---------------------    
        for(PatientServices__c Px: PSUpload )
        {    
            for (PHI_Configuration__c PC :[Select Field_Name__c,Validation_Type__c, Order__c from PHI_Configuration__c where Table_Name__c ='PHI__c' ])
            {
                for( String vtype :PC.Validation_Type__c.split(';')){
                    if(vtype='Null Value Check')
                        isNullValue(Px.vtype.Field_Name__c);    
                }
            }    
        }
        return null;
    }