- Sivaprakash BKR
- PowerBuilder
- Friday, 21 September 2018 11:35 AM UTC
Hello,
Need to execute 'update .... ' statement, when data found while 'inserting data...', from datawindow
PB 2017, Postgresql 10.
Giving facility to import records from XML and Excel. While importing records, few records might already available in database and need to be either excluded or updated. This query is available in Postgres.
Can we use this
INSERT ... ON CONFLICT DO NOTHING/UPDATE
Support for UPSERT functionality which allows either no action to be taken when a conflict is encountered, or convert the INSERT to an UPDATE.
facility from datawindow ?
https://www.postgresql.org/about/featurematrix/detail/275/
Happiness Always
BKR Sivaprakash
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.