Connecting Tech Pros Worldwide Forums | Help | Site Map

Problems with empty sets?!

Newbie
 
Join Date: Aug 2008
Posts: 1
#1: Aug 13 '08
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!

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 293
#2: Aug 13 '08

re: Problems with empty sets?!


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?
Reply