I'm attempting to patch a data card value to a INT SQL column and I receive the following error.
"The type of this argument 'clarityPersonalID' Does not match the expected type number. found type error"
The record I'm attempting to patch is a data card in a form set up using the following. Also when I hove over the value it says data type number.
Value(ClarityPersonalID_DataCard1_value.Text)
Here is the full patch statement.
//SubmitForm(frmPersonal);
If(
IsEmpty(
Errors('[dbo].[tblClientID]',Patch('[dbo].[tblClientID]',If(varFormMode="New",Defaults('[dbo].[tblClientID]'),LookUp('[dbo].[tblClientID]',ClientID = var_CurrentClientID)), {FirstName: dcvPersonal_ClientFirstName_Value.Text, LastName: dcvPersonal_ClientLastName_Value.Text,ClarityPersonalID:ClarityPersonalID_DataCard1_value.text ,MiddleInitial: dcvPersonal_ClientMiddleInitial_Value.Text, Alias: dcvPersonal_ClientAlias_Value.Text, DateOfBirth: dcvPersonal_DateOfBirth_Value.SelectedDate, UpdateBy: varStaffID, LastUpdateDate: Now(), CreateBy: If(varFormMode = "New",varStaffID,dcvAddress_CreateBy_Value.Text), CreatedOnDate: If(varFormMode="New",Now(),dcvAddress_CreatedOnDate_Value.SelectedDate)}))
),
Notify("Data saved successfully",NotificationType.Success),
Notify("There is an error with your request",NotificationType.Error)
);
//Patch('[dbo].[tbl_ClientDemographic]',Defaults('[dbo].[tbl_ClientDemographic]'),{ClientID:var_CurrentClientID});
ResetForm(frmPersonal);
