By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Problems with empty sets?!

P: 1
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!
Aug 13 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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?
Aug 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.