BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

Logical operators

When you type criterias in more than one Criteria cell in Grid pane, the program combines them using either the And or the Or operator. If the expressions are in different cells in the same row, the And operator will be used, which means only the records that meet the criteria in all the cells will be returned. If the expressions are in different rows of the design grid, the program uses the Or operator, which means records that meet criteria in any of the cells will be returned.

Operator

Meaning

NOT

Logical opposite of condition

AND

Both conditions must apply

OR

Either condition can apply


Related Topics:

How to create a view

About SQL Query Builder

SQL Query Builder Layout

Add or remove a table

Add a column

Customize the table and view names

Customize the column names

Using criteria to retrieve certain records

Expression Builder

Using wildcard characters

Comparison operators

Mathematical operators

Show or hide a column in a view's results

Group Rows in query results

Results Pane

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.

 

 

News
7/13/2004
COMDLG32.OCX error at startup
6/29/2004
Opening FoxPro and dBase databases
1/11/2024
Version 1.1.7 Relased (1/11/2024)
11/18/2002
Version 1.1.0 Relased (11/16/2002)
10/20/2002
HotFix 1 for Windows XP SP1

Forums
8/10/2024
removing duplicate records
8/8/2024
data validation and BaseNow
1/24/2007
Outlook 2003
1/12/2024
BASENOW AND FOXPRO DATE FORMATS
11/6/2024
Need help in Sybase Anywhere database
10/19/2006
need help! mysql query
6/21/2006
Compare SQl fields
6/8/2024
Error