Easy to Create, Easy to Change - Easy to use!

Support::

blank



Parameters


Returns/Result


Examples


Reference

blank

Purpose

The blank keyword is used to assign a null value to a field or variable, or to compare a null value to the value in a field or variable.

Syntax

blank

Usage

A blank value is a null value, not a zero. When statistics are calculated on a field, blank values are not included in the calculation. Zero field values are included when generating statistics.

Field or variable values can be compared to blank, and blank can be assigned as a value to any field or variable.

Example

 for MEMBERS with TOTAL DUE = blank ;

   delete records .

 end

 

This script tells DataEase: Delete the MEMBERS records that have a blank value in the TOTAL DUE field. It might be used to delete inactive MEMBERS records.

See Also


On the forum about blank

Fill string to length with blanks

I am creating a txt file using the TextOut and textoutln functio and would just like to know if there is a way to fill a field with blank until its length. Ex: Name (defined text 40) value = "Marco"...

Product: DataEase 6.x. Written by Marco 13/11/13 at 10:32:04

Re:Fill string to length with blanks

These functions are CDFs and there might be CDFs that do this but that is outside our "purview".In DE8 there is internal functions for all of this.http://www.dataease.com/dg3_HelpView/?PageID=13698&field1;=*FixedWidth*http://www.da...

Product: Dataease [{8}]FIVE. Written by DataEase 13/11/13 at 10:32:48

FixedWidth() - Return a blank padded, positioned String doesn't appear

Hello, I'm trying to use FixedWidth function but it doesn't appear on the function list. Why? I'm using Dataease version 8.0.0.1375. Thanks....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 14/11/13 at 13:50:29

Re:FixedWidth() - Return a blank padded, positioned String doesn't appear

Download SampleJust had to check, but FixedWidth was implemented in 8.0.0.1325 so if you are running 1375 you should be safely within t...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/13 at 17:02:34

Reference of blank on a currency field ..

Hello DataEase forum community .... I have since discovered a difficulty and therefore do not get ahead. When I query a currency field to blank I get no response. With all other field types the query working properly ... Is there a goo...

Product: Dataease [{8}]FIVE. Written by Markus 23/09/15 at 18:12:44

Re:Reference of blank on a currency field ..

Just tested this and it works fine.1) Is the currency field actually blank or is it 0.00?2) If there is a derivation in the currency field it will result with 0.I think you need to make a "non-working" sample and upload it to show...

Product: Dataease [{8}]FIVE. Written by DataEase 23/09/15 at 18:32:16

Re:Re:Reference of blank on a currency field ..

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Markus 23/09/15 at 19:03:58

Re:Re:Re:Reference of blank on a currency field ..

Here the simpl app....no User/passwordKind regardsMarkus...

Product: Dataease [{8}]FIVE. Written by Markus 23/09/15 at 19:11:40

Re:Re:Re:Re:Reference of blank on a currency field ..

OML is not as the rest. It read the text in the GUI control and not the column value.As you see here (simply did a Message Field 1.value window . in the action clicked on the Button to the...

Product: Dataease [{8}]FIVE. Written by DataEase 23/09/15 at 19:45:11

Re:Re:Re:Re:Re:Reference of blank on a currency field ..

Oh yes I understood .... As always, thank you for the fast and accurate help! Sometimes a small change can have a big impact .... Thanks again! Markus...

Product: Dataease [{8}]FIVE. Written by Markus 23/09/15 at 20:11:35

How can I right pad a text field with blank spaces

Good MorningQuick question:How can I right pad a text field with blank spaces? I want to export a number of fields in that way.Thank you...

Product: Dataease [{8}]FIVE. Written by Clare Bush 16/10/18 at 10:07:57

Re:How can I right pad a text field with blank spaces

Hi Clare.There is a number of ways to achieve this.As you are still using DataEase 8.2 I have to be a little careful as a lot of the best features just came in 8.5 (free upgrade).It also depends on which method you are using fo...

Product: Dataease [{8}]FIVE. Written by DataEase 16/10/18 at 10:11:40

How to stop DataEase to autostart when username/password is blank.

Security ;-)DataEase 8.5 opens the application directly if there is a blank/blank username/password combination. This is achieve exactly the effect you want.There is a couple of ways to work around your problem.1. Create a Shor...

Product: DataEase 8.5 Runtime. Written by DataEase 07/10/19 at 14:50:07

On the blog about blank

New Function in 8 - FixedWidth() - Return a blank padded, positioned String (Ver. 8.0.0.1325)

The DOS retro implementations in DE8 is not yet over. Today we released FixedWidth() which is a string function to help build text documents easier. FixedWidth(Value,Position,Length) will return a string Length long with Value positio...

Product: Dataease [{8}]FIVE. Written by DataEase 08/07/13 at 12:20:13