Table.sqlaction.property DataWindow object property

Description

The way data is updated in the database. When the Update method
is executed, it can send UPDATE, INSERT,
and DELETE SQL statements
to the DBMS. You can specify that a stored procedure be used instead
of the default SQL statement
for each type of data modification.

Controls

DataWindows

Syntax

PowerBuilder dot notation:

<span>dw_control</span>.Object.DataWindow.Table.<span>sqlaction</span>.<span>property</span>

1	<span>dw_control</span>.Object.DataWindow.Table.<span>sqlaction</span>.<span>property</span>

Describe and Modify argument:

"DataWindow.Table.<span>sqlaction</span>.<span>property</span> { = <span>value</span> }"

1	"DataWindow.Table.<span>sqlaction</span>.<span>property</span> { = <span>value</span> }"

Parameter	Description
sqlaction	The SQL statement that would ordinarily be executed as part of a database update. Values are: UPDATE INSERT DELETE
property	A property for sqlaction. Properties and appropriate values are listed in the table below.
value	The value to be assigned to the property.

Parameter

Description

sqlaction

The SQL statement
that would ordinarily be executed as part of a database update.

Values are:

UPDATE
INSERT
DELETE

property

A property for sqlaction.
Properties and appropriate values are listed in the table below.

value

The value to be assigned to the property.

Property for Table

Value

Arguments

A string specifying the arguments used
in the stored procedure. The string takes this format:

("<span>argname</span>", <span>valuetype </span>{ =("<span>valuesrc</span>" {, <span>datasrc</span>, <span>paramtype </span>} )

1	("<span>argname</span>", <span>valuetype </span>{ =("<span>valuesrc</span>" {, <span>datasrc</span>, <span>paramtype </span>} )

Argname is the name of the stored procedure
parameter.

Valuetype is one of the keywords described
below. Datasrc and paramtype apply
to the COLUMN keyword.

Valuesrc is the column, computed field,
or expression that produces the value to be passed to the stored
procedure.

Method

A string specifying the name of the stored
procedure. The stored procedure is used only if the value of Type
is SP.

Type

Specifies whether the database update
is performed using a stored procedure.

Values are:

SP – The update
is performed using a stored procedure.
SQL – The
update is performed using standard SQL syntax
(default).

Keyword for valuetype

Description

COLUMN

The argument value will be taken from
the table and column named in valuesrc. Valuesrc has
the form:

"<span>tablename</span>.<span>column</span>"

1	"<span>tablename</span>.<span>column</span>"

For COLUMN, you must also specify whether the data is the
new or original column value. Values for datasrc are:

NEW

The new column value that is being sent to the database.
ORIG

The value that the DataWindow originally read from the database.

You can also specify the type of stored procedure parameter. Values
for paramtype are:

IN

(Default) An input parameter for the procedure.
OUT

An output parameter for the procedure. The DataWindow will
assign the resulting value to the current row and column (usually
used for identity and timestamp columns).
INOUT

An input and output parameter.

A sample string for providing a column argument is:

("empid", COLUMN=("employee.empid", ORIG,<br>IN))

1	("empid", COLUMN=("employee.empid", ORIG,<br>IN))

COMPUTE

The computed field named in valuesrc is
the source of the value passed to the stored procedure.

A sample string for providing a computed field argument is:

("newsalary", COMPUTE=("salary_calc"))

1	("newsalary", COMPUTE=("salary_calc"))

EXPRESSION

The expression specified in valuesrc is
evaluated and passed to the stored procedure.

A sample string for providing an expression argument is:

("dept_name", EXPRESSION=("LookUpDisplay(dept_id)"))

1	("dept_name", EXPRESSION=("LookUpDisplay(dept_id)"))

UNUSED

No value is passed to the stored procedure.

Usage

In the painter

Set the values using Rows>Stored Procedure Update.
Select the tab page for the SQL command
you want to associate with a stored procedure.

In code

If you enable a DataWindow object to use stored procedures
to update the database when it is not already using stored procedures,
you must change Type to SP first. Setting Type ensures that internal
structures are built before you set Method and Arguments. If you
do not change Type to SP, then setting Method or Arguments will
fail.

When the values you specify in code are nested in a longer
string, you must use the appropriate escape characters for quotation
marks.

Examples

Each is all on one line:

dw_x.Describe("DataWindow.Table.Delete.Method")

1	dw_x.Describe("DataWindow.Table.Delete.Method")

dw_x.Describe("DataWindow.Table.Delete.Arguments")

1	dw_x.Describe("DataWindow.Table.Delete.Arguments")

dw_x.Modify("DataWindow.Table.Delete.Type=SP")

1	dw_x.Modify("DataWindow.Table.Delete.Type=SP")

dw_x.Modify("DataWindow.Table.Delete.Arguments=<br>&#160;&#160;((~"id~", COLUMN=(~"department.dept_id!~", ORIG)))")

1	dw_x.Modify("DataWindow.Table.Delete.Arguments=<br>  ((~"id~", COLUMN=(~"department.dept_id!~", ORIG)))")

dw_x.Modify("DataWindow.Table.Delete.Method=<br>&#160;&#160;~"spname~"")

1	dw_x.Modify("DataWindow.Table.Delete.Method=<br>  ~"spname~"")

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.6

August 14, 2023

Was this article helpful?

0 Comments

Inline Feedbacks

View all comments

Table.sqlaction.property – PB Docs 126

Table.sqlaction.property DataWindow object property

Description

Controls

Syntax

Usage

In the painter

In code

Examples

My Website Links