Designer error - Options strict On disallows implicit conversions from String to Long

What version are you using?

Where does this code snippet come from, a template?

Can you please post the complete code, otherwise it is near to impossible to help you out?

Hi Markus,

1) I'm using version 6.1 .
for prov2 instance , i want to update the uid_realperson in the person table of hr instance(version 8)

2) There is already an existing code that updates the first name, last name and personal number in the person table of hr instance when an entry is made in UNSROOT of prov2.

ColValues.Add(UID_RealPerson,Connection.GetSingleProperty("PersonTable","UID_Person", Connection.sqlformatter.Comparison("InternalName", "value",valType.String,CompareOperator.Equal,FormatterOptions.Ignorecase) and Connection.sqlformatter.Comparison("UID_PersonMasterIdentity", "value",valType.String,CompareOperator.Equal,FormatterOptions.Ignorecase)))

The above line of code i added to the existing code in order to update the UID_Realperson column in person table of hr instance.

After adding the above lines its throwing up an error.
Options strict On disallows implicit conversions from String to Long

If I remove the below line,
Connection.sqlformatter.Comparison("UID_PersonMasterIdentity", "value",valType.String,CompareOperator.Equal,FormatterOptions.Ignorecase)

I dont get this error, please let me know how can this be resolved, as i need to check the above condition too to update the uid_realperson value as hr will have 4 identities and i want only the hr instance identity value to be updated in the uid_realperson column of person table of HR Instance.

Please let me know if these information is enough.

Thanks,
Sangeetha

Hi Markus,

When I checked again, I can see the problem with joining the both the condition using AND.

Thanks

I was able to fix that issue using Connection.sqlformatter.AndRelation, where i can join both the condition to retrieve the uid_person