I'm trying to update data in SQL Server with a Patch Statement and I'm getting a "Network error when using Patch function: The specified record was not found."
The database table is pretty simple as is the patch statement:
Patch(
NA_BusinessUnit,
LookUp(NA_BusinessUnit, RecID =hKey.RecID),
{
BusnsUnit:"Consumer"
}
);
When I select the Lookup statement, the IntelliSense does show me the value from the database.
I've tried a Set statement above to set a variable to the record and then tried to use that as opposed to the lookup in the patch but that gives me a totally different error.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.