GenerateEqualsNull – PB Docs 126

GenerateEqualsNull database parameter

Description

Specifies how DataWindows generates =null and <> null expressions
in retrieval arguments.

Controls

All database interfaces

Syntax

Parameter

Description

value

  • Yes

    Does not change =null or <> null expressions.

  • No

    Converts =null expression to IS
    NULL
    , <> null to IS
    NOT NULL
    .

Default

GenerateEqualsNull=’No’

Usage

When to use

When a DataWindow retrieves data from tables that contain
null columns, most DBMS interfaces expect expressions of the form, IS
NULL
and IS NOT NULL. Expressions that
reference null data as values, such as Where column = NULL,
can cause the DBMS to reject the retrieval. For this reason, such
expressions in DataWindows are normally converted to the standard ANSI
syntax during retrieval.

If your DataWindow retrieves null data from a DBMS that supports expressions
of the =null or <> null form,
and you want to suppress the conversion of those expressions to
standard syntax, you can set the GenerateEqualsNull DBParm to true.

Examples

Consider these two statements:

If GenerateEqualsNull is set to false, the statements are
generated as:

If GenerateEqualsNull is set to true, the statements are generated
as:


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