|
|
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>EasiReporter.Dialogs.WhereItem</title>
<link rel="stylesheet" type="text/css" href="EasiReports.css">
</head>
<body>
<h1>Where Item Properties Dialog</h1>
<p>You can access this dialog by choosing "New" or "Edit" from
the "Where" Tab of the <a href="EasiReporter.Dialogs.Report.htm">Report
Properties Dialog</a>.</p>
<p><img border="0" src="images/Dialogs.WhereItem.jpg" width="640" height="384"></p>
<p>Use this dialog to create or edit Where Criteria clauses.</p>
<p>First, select <b>Auto</b> or <b>Text</b> on the left for the whole clause.
<b>Auto</b> creates the clause automatically from your selections. <b>Text</b>
is just a free text entry that you write.</p>
<p>If you select <b>Auto</b>, then you use the three groups of controls in the
centre - <b>Left</b>, <b>Function</b> and <b>Right</b>. The <b>Left</b> and <b>
Right</b> groups are similar and correspond to the left- and right-hand sides
of the clause. They are joined by the <b>Function</b> you select.</p>
<p>In both the <b>Left</b> and <b>Right</b> groups of controls, you have three
choices - a <b>Table.Field</b>, <b>Data</b> from the database, or <b>Text</b>.
A <b>Table.Field</b> entry just adds the name of a Table.Field to the clause. A
<b>Data</b> entry adds a constant value from the database. A <b>Text</b> entry
is any free text that you write.</p>
<p><b>NOTE:</b> The complete clause as it stands always appears in the text box
at the bottom of the dialog box - use this to help you build Where Criteria
Clauses.</p>
<p><b>NOTE:</b> Dates must be in American format if specified as numbers - i.e.
month/day/year - e.g. 12/31/1999. It is clearer to use the form 31-Dec-1999.
This is done automatically if you are using Select Data.<br>
</p>
</body>
</html>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I discovered C# and .NET 1.0 Beta 1 in late 2000 and loved them immediately.
I have been writing software professionally in C# ever since
In real life, I have spent 3 years travelling abroad,
I have held a UK Private Pilots Licence for 20 years,
and I am a PADI Divemaster.
I now live near idyllic Bournemouth in England.
I can work 'virtually' anywhere!
Submit an article or tip