How many elements in a CASE ?
|
02-22-2016, 12:18 PM
Post: #1
|
|||
|
|||
How many elements in a CASE ?
Hello again,
I spent the weekend working on my latest project, which involves the use of a large CASE statement. Things were going well as I was building up the CASE tests, up to a point when all of a sudden I got a syntax error in some simple code within the CASE statement that appeared to be fine. After some noodling around, I thought that maybe I had reached the limit on the number of tests that could be in a CASE statement. I then broke the CASE statement into two CASE statements, and that now passes the syntax checking. In this project of mine, I will likely have 245-250 tests to do. I would much prefer to have them all in one CASE statement, if possible. What is the maximum number of tests that are allowed in one CASE statement? Thanks, in advance, for your patience and attention. smp |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
How many elements in a CASE ? - smp - 02-22-2016 12:18 PM
RE: How many elements in a CASE ? - Didier Lachieze - 02-22-2016, 02:49 PM
RE: How many elements in a CASE ? - smp - 02-22-2016, 11:02 PM
RE: How many elements in a CASE ? - cyrille de brébisson - 02-23-2016, 07:03 AM
RE: How many elements in a CASE ? - smp - 02-23-2016, 08:25 PM
RE: How many elements in a CASE ? - Tim Wessman - 02-23-2016, 09:14 PM
RE: How many elements in a CASE ? - smp - 02-23-2016, 11:31 PM
RE: How many elements in a CASE ? - cyrille de brébisson - 02-24-2016, 07:53 AM
RE: How many elements in a CASE ? - smp - 02-24-2016, 12:40 PM
RE: How many elements in a CASE ? - smp - 02-29-2016, 01:40 AM
RE: How many elements in a CASE ? - debrouxl - 02-25-2016, 07:08 AM
RE: How many elements in a CASE ? - cyrille de brébisson - 02-26-2016, 06:49 AM
|
User(s) browsing this thread: 1 Guest(s)