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

Update Column Values dialog box – PB Docs 150 – PowerBuilder Library

Update Column Values dialog box – PB Docs 150

Update Column Values dialog box

Description

Specify column values for an UPDATE statement.

Options

Column Name

Click the name of the column you want to update in the table representation
at the bottom of the dialog box. To specify values for additional columns,
click in the empty box at the bottom of the Column Name list and then
select another column name from the table representation. Use the
Insert button to add a column elsewhere in the list.

Value

Enter the variable or value you want to use to update the
column. You can select variables from the list in the Program Variables
drop-down list. The Value can be an expression (for example, :salary_amt * .07).

Operator buttons

Click an operator button to paste it into the expression in the
Value box.

Program Variables

Double-click a variable to paste it into the expression in the
Value box.

Null

Click to make the value an explicit NULL.

Clear

Click to clear the values specified for all columns.

Delete

Click to delete the selected column from the list.

Insert

Click to insert a new column in the Column Name list above
the currently selected name. A blank box opens for the new column
name.

See also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x