Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

null query 2

Status
Not open for further replies.
Mitch38

Mitch38

MIS
Sep 11, 2002
5
0
0
US
How can a field in a form be queried for null or blank values?
 
Sort by date Sort by votes
You may process this condition by specifying DEFAULT_WHERE block property in pre-query trigger . Don't forget to reset it in post-select. As form embedded feature - the answer is NO.

Regards, Dima
 
Upvote 0 Downvote
It can ! User can query :X in this field. A pop-up appears and there you enter ->
:X is null.
 
Upvote 0 Downvote
Or you can enter the condition "# is null" in the field (double quotes not included), provided its query length allows for that.

HTH - Didier
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gleeb
  • Locked
  • Question
Bind Variable with Null value
Replies
1
Views
64
BJCooperIT
BJCooperIT
ChrisHunt
  • Locked
  • Question
Detecting Query Mode
Replies
2
Views
43
ChrisHunt
ChrisHunt
bean1234
  • Locked
  • Question
Concatenate the column values in query result as a single string 1
Replies
2
Views
61
lewisp
lewisp
rinjet
  • Locked
  • Question
change nls_language within query?
Replies
0
Views
27
rinjet
rinjet
ihda
  • Locked
  • Question
One To Many - Single Row Query Selection
Replies
1
Views
37
BJCooperIT
BJCooperIT

Part and Inventory Search

Sponsor

Back
Top