Null Object

Hi,

Is there any way to create null object, which is not pointing to any table.


ravik (BOB member since 2004-06-02)

You can create a object containg ‘~’ in the select clause and in report you can treat this as null or can create a varibale with null value by using this object


JaiGupta (BOB member since 2002-09-12)

Certainly … for Oracle, just put “NULL” (without quotes) as the select statement. Other databases are probably the same (or at least similar). It may not parse, since it is not associated with a table, but when used with any other object it will work just fine. This is one example where the “does not parse” message in Designer is perfectly OK.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)