[shmitt]

Hi all!

So here is a problem refering at empty set:

How i can, first, verify if my column(respective table) is empty, has now rows in it, and, second, after the verification set a value to it.

Example:

Having table: tableA

with columns: id_tableA, columnA, columnB

and no value's in it, absolutly empty.

Need something like this(writing in text language)

IF IS_EMPTY(tableA.columnA)
THEN tableA.column = 0

Also, need to specify that: columnA is 'float' type.

Any help will be greatly apreciated.

Thx in advance!

[rski]

Expand|Select|Wrap|Line Numbers

1. IF IS_EMPTY(tableA.columnA)
2. THEN tableA.column = 0
3.  

how should it work if there some rows but in column A there are no values. Should it put zeros in all rows?