Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: If Then Else in SQL Command Crystal report 11 Post Reply Post New Topic
Author Message
ckreds
Newbie
Newbie


Joined: 24 Sep 2007
Location: Malaysia
Online Status: Offline
Posts: 16
Quote ckreds Replybullet Topic: If Then Else in SQL Command Crystal report 11
     Posted: 29 Nov 2007 at 12:05am
Just wonder whether we can use "If Then Else" in SQL Command Crystal report 11. Thks.
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 04 Dec 2007 at 10:21am
No.  SQL does not support IF..THEN structures.

Depending on the particular database type you are connecting to, the CASE function may work.
IP IP Logged
fusion
Groupie
Groupie


Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Quote fusion Replybullet Posted: 05 Dec 2007 at 5:55pm

Case statement definitely works
IP IP Logged
ckreds
Newbie
Newbie


Joined: 24 Sep 2007
Location: Malaysia
Online Status: Offline
Posts: 16
Quote ckreds Replybullet Posted: 09 Dec 2007 at 9:47pm
thks all
IP IP Logged
Printable version Printable version

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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.