Forum acting up again.

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

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?

Quote:

---

Originally Posted by 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?

---

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

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

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

Code:

---

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.

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:p

Quote:

---

Originally Posted by 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:p

---

You're having me on...

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

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

Code:

---

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

---

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

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

Quote:

---

Originally Posted by Shaggy Hiker

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

---

Firefox

Quote:

---

Originally Posted by Shaggy Hiker

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.

Select case

Code:

---

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

---

EDIT:
Weird....

Maybe the Rules here in Forum Feedback are different?

case