Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
XiaoyongLin
Contributor
Contributor

Don't update primary key

my target database don't support update primary key

how can I set to filter primary key column.

eg:

the table has three columns: col1,col2,col3,the column col1 is primary key 

when one update sql is running,replcate generate update sql like this

update test set col1=?,col2=?,col3=? where col1=?;

but I want to the sql like this:

update test set col2=?,col3=? where col1=?;

How should I set the table selectings

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @XiaoyongLin ,

 

Can you please describe the requirement in detail?

The tabular format will be eaiser to understand.

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!