Thank you for the reply, unfortunately, this still hasn't worked. I'll just rewrite the issue for abit more sense.
- We're trying to join a Server Name/Server UID & App Name/App UID in table
- When we Patch the 4 items together they shall be placed in 1 row with a ROWID at the end.
- ROWID is a primary key and a uniqueidentifier, this has (newid()) in the default value or binding.
The idea is to press a button and the 4 fields application_name, application_uid, server_name, server_uid will be added to the table with a new autogenerated primary key uniqueidentifier in the ROWID column.
Button Code (this returns ROWID: Field is required)
Patch('[dbo].[Apptable]', Defaults('[dbo].[Apptable]'), {Application_Name: AppName_Return.Text, Application_UID: AppUID_Return.Text, Server_Name: ServerName_Return.Text, Server_UID:ServerUID_Return});
Button Code (with ROWID set as ROWID: Blank() returns ROWID: field is required)
Patch('[dbo].[Apptable]', Defaults('[dbo].[Apptable]'), {ROWID: Blank(), Application_Name: AppName_Return.Text, Application_UID: AppUID_Return.Text, Server_Name: ServerName_Return.Text, Server_UID:ServerUID_Return});
Button Code (with ROWID set as ROWID: GUID() returns server response: clientrequestid: a value must be provided for item then gives a unique identifier number)
Patch('[dbo].[Apptable]', Defaults('[dbo].[Apptable]'), {ROWID: Blank(), Application_Name: AppName_Return.Text, Application_UID: AppUID_Return.Text, Server_Name: ServerName_Return.Text, Server_UID:ServerUID_Return});
- Application_name, Application_UID Server_Name, and Server_UID, ROWID are columns in the table
