Forum acting up again.

[Zvoni]

Have trouble posting answers (Quick reply, reply with quote).
Forum claims "reply is too short" (as in empty)
Doesn't matter if Quick reply or with Advanced

EDIT: Found it
It's the Word "C ASE" (note the blank between C and A)
Forum rejects the post if i remove the blank in that word

We/I had the same thing some months ago
See here: https://www.vbforums.com/showthread....er-Site-Issues

[dday9]

What about select case statements?

Edit - Hmm, that allowed me to post it. I wonder if it is when SELECT CASE is all capitalized.

Edit 2 - No, that allowed me to post it too. What about on its own: Case

Edit 3 - Nope, that's fine for me too. Are you sure it's the word case getting caught?

[Zvoni]

What about select case statements?

Edit - Hmm, that allowed me to post it. I wonder if it is when SELECT CASE is all capitalized.

Edit 2 - No, that allowed me to post it too. What about on its own: Case

Edit 3 - Nope, that's fine for me too. Are you sure it's the word case getting caught?

Pretty sure.
I was trying to post some SQL-Code having a C ASE WHEN
In particular this thread and the SQL-Code within
https://www.vbforums.com/showthread....=1#post5684352

[dday9]

I wonder if it was because of the parenthesis before it: (CASE

Edit - No, let me try copying/pasting the entire code snippet:

SELECT Ma.Control,
SUM(CASE WHEN RLS.ReleaseMethod IS NULL THEN 0 ELSE 1 END) AS SumRelease,
SUM(CASE WHEN RLS.ReleaseMethod IS NOT NULL THEN 0 ELSE 1 END) AS SumReleaseNo  
FROM xtlbMROrder AS Ma
LEFT JOIN xtblMROrderSerialNumbers AS RLS ON Ma.Control=RLS.MROrderMasterControl
GROUP BY Ma.Control

Edit 2 - No, it let me copy/paste it. Maybe it's because I'm a moderator? But that just seems very odd.

[Steve R Jones]

The message you have entered is too short. Please lengthen your message to at least 4 characters.

"C ASE" isn't an English word unless you can use it in a sentence

[Zvoni]

The message you have entered is too short. Please lengthen your message to at least 4 characters.

"C ASE" isn't an English word unless you can use it in a sentence

You're having me on...

[Shaggy Hiker]

I can't post JUST CASE but maybe C ASE?

[Shaggy Hiker]

SELECT Ma.Control,
SUM(CASE WHEN RLS.ReleaseMethod IS NULL THEN 0 ELSE 1 END) AS SumRelease,
SUM(CASE WHEN RLS.ReleaseMethod IS NOT NULL THEN 0 ELSE 1 END) AS SumReleaseNo
FROM xtlbMROrder AS Ma
LEFT JOIN xtblMROrderSerialNumbers AS RLS ON Ma.Control=RLS.MROrderMasterControl
GROUP BY Ma.Control

[Shaggy Hiker]

SELECT Ma.Control,
SUM(CASE WHEN RLS.ReleaseMethod IS NULL THEN 0 ELSE 1 END) AS SumRelease,
SUM(CASE WHEN RLS.ReleaseMethod IS NOT NULL THEN 0 ELSE 1 END) AS SumReleaseNo  
FROM xtlbMROrder AS Ma
LEFT JOIN xtblMROrderSerialNumbers AS RLS ON Ma.Control=RLS.MROrderMasterControl
GROUP BY Ma.Control

[Shaggy Hiker]

SELECT Ma.Control,
SUM(C ASE WHEN RLS.ReleaseMethod IS NULL THEN 0 ELSE 1 END) AS SumRelease,
SUM(CASE WHEN RLS.ReleaseMethod IS NOT NULL THEN 0 ELSE 1 END) AS SumReleaseNo
FROM xtlbMROrder AS Ma
LEFT JOIN xtblMROrderSerialNumbers AS RLS ON Ma.Control=RLS.MROrderMasterControl
GROUP BY Ma.Control

[Shaggy Hiker]

Well, I can't replicate it. Which browser are y'all using. All y'all who are getting the problem, that is.

[Zvoni]

Well, I can't replicate it. Which browser are y'all using. All y'all who are getting the problem, that is.

Firefox

[Steve R Jones]

Well, I can't replicate it. Which browser are y'all using. All y'all who are getting the problem, that is.

The word SELECT is more than 4 characters.... BOOM you're done and have gotten past too short error.

Chrome.

[Zvoni]

Select case

SELECT CASE WHEN ID IS NULL THEN 0 ELSE 1 END FROM MyTable

EDIT:
Weird....

Maybe the Rules here in Forum Feedback are different?

[dday9]

case