• From: Belgium
  • Registered: 2014-02-22
  • Posts: 101

Topic: Report SQL error

Hello,

What's error in the code? How to fix?
Thanks, carlo


SELECT
members.Paid
,members.firstname
,members.lastname
,members.ClubID                < Report SQL = OK
,members.StartBet
,members.EndBet
,members.eMail
,members.GSM
,members.Comments,
members.id FROM members
<--------------------------------->    But with this Boolean convert = CASE= syntax error
CASE Paid WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END

FROM members

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Report SQL error

Hello,


Please paste your SQL query without any comments, because I don't understand, it's just comments or your SQL query looks like in your post.

Dmitry.
  • From: Belgium
  • Registered: 2014-02-22
  • Posts: 101

Re: Report SQL error

SELECT
members.Paid
,members.firstname
,members.lastname
,members.ClubID
,members.StartBet
,members.EndBet
,members.eMail
,members.GSM
,members.Comments,
members.id FROM members


CASE Paid WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END

FROM members

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Report SQL error

Check out:

SELECT
members.firstname
,members.lastname
,(CASE Paid WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END) as PaidYesNo
,members.ClubID
,members.StartBet
,members.EndBet
,members.eMail
,members.GSM
,members.Comments
,members.id 
FROM members
Dmitry.
  • From: Belgium
  • Registered: 2014-02-22
  • Posts: 101

Re: Report SQL error

Report is ok now,

Thanks Dmitry.