These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#32980 - 06/11/10 07:29 AM OBJECT_EMPTY always returns TRUE
Peter Hebbinckuys Offline
OL Newbie

Registered: 05/26/10
Posts: 6
Loc: Sint-Niklaas, Belgium
Since I use PSM 7 and tried to use OBJECT_EMPTY, it always returns TRUE on all records.
When I move with my cursor above the expression, a yellow infobox is shown with following text:

Function result: TRUE

With 'fieldcontent' the correct content of the field shown for that record.
So PSM sees it is not empty, but it returns TRUE as a result for every record.

Is anyone having the same problem?

#32981 - 06/11/10 08:03 AM Re: OBJECT_EMPTY always returns TRUE
Sander vd Berg Offline
OL Expert

Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL

You're not meant to pass a variable data field to OBJECT_EMPTY. It should be the name of an object. For example: OBJECT_EMPTY("Text 1")

OBJECT_EMPTY will return True if "Text 1" is empty, but it will also return True if no object called "Text 1" can be found. If that happens you should see a warning in the Warnings pane.

To determine if a data field is empty you could do: TRIM([Field]) = ""