Hello,
we have created a table and the table has a column like below.
StartDateTime] datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL,
>EndDateTime] datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL,
These both generate automatic so we don't need to pass by SMO but k2 object is taking as mandatory to this feild and when I pass this value to SQL, SQL throw error as this generates by SQL.
How can we handle this in k2?
Hi,
If you have a field that are autogenerated, you have to edit the SmartObject in Designer, and uncheck the required property for that particular field, and save the changes.
sorry this doest work, I tried.
In that case, please upload a copy of the full error message you are getting.
I solved it by own. you have to make the field hidden on SQL side to avoid in SMO.
Thank you thank you
I was wondering how I was going to get around this, and your solution worked perfectly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.