Symptoms
Is there a way to capture the user submitting data through a SmartObject and save the information to a column in the back-end table. When trying to use SQL system_user, this function always returns NULL.
Diagnoses
The SQL Service doesn’t have the ability to use SQL Default values, as it’s currently by designed that when the input value is not provided, it will be seen as NULL and will update with blank in the SQL table.
Resolution
Issue was logged to be addressed in future release. A suggestion is to wrap the table in a stored procedure.
For example,
create PROCEDURE [dbo].[SPROC_NAME]
@ID int,
@Value int
AS
BEGIN
insert into [SQL_Serv].[dbo].[Table_Name]
(ID, Value) Values (@ID, @Value)
END