#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    2
    Rep Power
    0

    Firbird Select Case dialect?


    I've taken the following directly from the documentation...
    CanVote = case
    when Age >= 18 then 'Yes'
    when Age < 18 then 'No'
    else 'Unsure'
    end;
    When I write the dame code directly into my Delphi Query
    Mth1 = case
    etc....
    Firebird rejects the code on the = sign. Why? Could it be that this is a dialect 3 only construct?

    (Note The Case statement was apparently added in approx Firebird 1.5, I am using 2.somthing.)
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    2
    Rep Power
    0
    Ed: "dame code" should of course be "same code"

IMN logo majestic logo threadwatch logo seochat tools logo