insert → excute query(insert sysdate)
half success
but,
why not together
insert → excute query(insert sysdate)
half success
but,
why not together
Hi @S_Sim
If you want to insert systemdate in database means.
write insert query as below.
insert into your_table_name('DateColumn','otherColumns') values ('"+Now.Tostring(dd-MM-yyyy")+"','"+row("yourColumnName/Column index")+"');```
Regards
hi calvin,
I know how to query.
Used within ‘excute query activity’ and put into datable such as ‘insert activity’, but failed to operate.
tts ~ cab column = data scrapping
currency_id, currency_date = column I’m going to insert separately
Hi @S_Sim
I think you need to use update query here !
If the data has inserted already you need use update query.
Regards
ah ha i try update
thank you calvin
fast solution
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.