Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

JetDriver: Replace CASE expressions with something that's understandable by Access

Description

The first patch simplifies the SQL transformation function.

The second patch has the following effect:
Change all (case when ... then ... else ... end) expressions into something like:
IIf(IsNull(Switch(when_1, then_1, ... when_n, then_n)), else, Switch(when_1, then_1, ... when_n, then_n))
or (when no "else" part exists):
Switch(when_1, then_1, ... when_n, then_n)

Environment

None

Attachments

6

Activity

Show:

Alex Zaytsev 
May 19, 2017 at 1:46 AM

Mark Junker 
October 25, 2011 at 9:34 AM

Use the original SQL string as cache key

Mark Junker 
October 25, 2011 at 9:31 AM

Fixes problems with the created Switch statements (multiple and duplicate WHEN parts)

Mark Junker 
October 24, 2011 at 8:07 AM

This patch moves the CASE conversion to the top of the function. It also renames the function to something more suitable.

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created October 20, 2011 at 11:25 AM
Updated May 19, 2017 at 1:46 AM
Who's Looking?