Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Specifying update when key is modified – PB Docs 90 – PowerBuilder Library

Specifying update when key is modified – PB Docs 90

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 9.0
  5. Specifying update when key is modified – PB Docs 90

Specifying update when key is modified

The Key Modification property determines the statements PowerBuilder generates
whenever a key column–a column you specified in the Unique
Key Columns box–is changed. The options are:

  • Use DELETE then INSERT (default)
  • Use UPDATE

How to choose a setting

Consider the following when choosing the Key Modification
setting:

  • If multiple rows
    are changed, DELETE and INSERT always
    work. In some DBMSs, UPDATE fails if the user
    modifies two keys and sets the value in one row to the original
    value of the other row.
  • You might choose the setting here based on your
    DBMS triggers. For example, if there is an Insert trigger, select
    Use Delete then Insert.
  • If only one row can be modified by the user before
    the database is updated, use UPDATE because it
    is faster.
Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 9.0
PB Docs 90 Powerbuilder Documentation Powerbuilder Documentation 9.0 Powerbuilder Documentation Older Powerbuilder User Guide
August 3, 2023
Was this article helpful?
2
0
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x