OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

how to use the conditional statement if else?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
un-kindhearted
Newbie
Newbie


Joined: 19 Sep 2008
Posts: 1
Location: Philippines

PostPosted: Fri Sep 19, 2008 2:18 am    Post subject: how to use the conditional statement if else? Reply with quote

please help me. our school has just started to use Ubuntu, and with regards to making databases, we are using openoffice freeware products.. please help me. and happy programming to all. ^_^

how to use the conditional statement if else in the coding? thats my question... ^_^
_________________
we are all programs.
Back to top
View user's profile Send private message
brian4m
OOo Enthusiast
OOo Enthusiast


Joined: 13 Feb 2006
Posts: 162
Location: Bath, England

PostPosted: Wed Oct 01, 2008 12:41 pm    Post subject: Reply with quote

I think you need to consider the CASE expression.

A condition such as
If a= b then action 1, if a<b then action2 else action3
becomes, in sql,
CASE WHEN a=b THEN action1 WHEN a<b THEN action2 ELSE action3 END

Brian
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group