Hi All,
I am using a subquery to take a value inside a insert query. But it is saying "[HY000:-3035: on SQLHANDLE] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query."
insert into SC_789
(User_ID,Date_Time,Store_ID,Period_txt,Role,Role_F unctionality,Comment_Category,Comment_Subcategory, Remarks)
values
( 'Administrator', getdate(), 'BE1001','2014S1','CFO',
Select ([Role_Functionality]) from Transaction_Dropdown where [Comment_Subcategory] = 'Close down',
select ( [Comment_Category]) from Transaction_Dropdown where [Comment_Subcategory] = 'Close down',
'Close down', 'No Comments' );
Please help me to identify the issue and provide a sloution if possible
Thanks,
Sitakant