SvendK
  • Posts: 4
  • Joined: 1/23/2018
Hi guys

Using the pro version, I cannot find out how to change the SQL Format editor settings of an AND clause inside a WHERE clause.

Eg:
WHERE JournalLine.DayTotalNo IS NULL AND LnTy IN (1,2) -- < No LineBreak is added before AND

SvendK
  • Posts: 4
  • Joined: 1/23/2018
My template.xml:
<?xml version="1.0" encoding="utf-16"?>
<FormatStyle xmlns:xsi="<<REMOVED DETECTED AS SPAM>>" xmlns:xsd="<<REMOVED DETECTED AS SPAM>>">
  <Name>My template</Name>
  <Options>
    <AlignmentStyle>Spaces</AlignmentStyle>
    <Block>
      <IndentCode>true</IndentCode>
    </Block>
    <If>
      <SpaceBeforeCondition>Space</SpaceBeforeCondition>
      <SpaceAfterCondition>LineBreak</SpaceAfterCondition>
      <IndentCondition>true</IndentCondition>
      <IndentSingleStatement>true</IndentSingleStatement>
      <IndentBlock>false</IndentBlock>
      <SpaceBeforeElseKeyword>Unspecified</SpaceBeforeElseKeyword>
      <SpaceAfterElseKeyword>Unspecified</SpaceAfterElseKeyword>
    </If>
    <While>
      <SpaceBeforeCondition>Space</SpaceBeforeCondition>
      <SpaceAfterCondition>LineBreak</SpaceAfterCondition>
      <IndentCondition>true</IndentCondition>
      <IndentSingleStatement>true</IndentSingleStatement>
      <IndentBlock>false</IndentBlock>
    </While>
    <Case>
      <SpaceBeforeInputExpression>Space</SpaceBeforeInputExpression>
      <IndentInputExpression>true</IndentInputExpression>
      <Branches>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>true</Indent>
        <SpaceBetween>LineBreak</SpaceBetween>
        <SpaceBeforeWhenExpression>Space</SpaceBeforeWhenExpression>
        <IndentWhenExpression>false</IndentWhenExpression>
        <SpaceBeforeThen>LineBreak</SpaceBeforeThen>
        <IndentThenElse>false</IndentThenElse>
        <SpaceBeforeResultExpression>Space</SpaceBeforeResultExpression>
        <IndentResultExpression>true</IndentResultExpression>
        <Align>true</Align>
        <AlignResults>true</AlignResults>
      </Branches>
      <SpaceBeforeEnd>LineBreak</SpaceBeforeEnd>
    </Case>
    <With>
      <SpaceAfter>LineBreak</SpaceAfter>
      <TableExpressions>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
      </TableExpressions>
    </With>
    <TableExpression>
      <Columns>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <SpaceAfterLastItem>Space</SpaceAfterLastItem>
        <IndentItems>false</IndentItems>
      </Columns>
      <SpaceBeforeAs>LineBreak</SpaceBeforeAs>
      <SpaceBeforeQueryOpeningBrace>LineBreak</SpaceBeforeQueryOpeningBrace>
      <SpaceAfterQueryOpeningBrace>LineBreak</SpaceAfterQueryOpeningBrace>
      <SpaceBeforeQueryClosingBrace>LineBreak</SpaceBeforeQueryClosingBrace>
      <IndentQuery>true</IndentQuery>
    </TableExpression>
    <Select>
      <UnionsExceptsIntersects>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeRightQuery>LineBreak</SpaceBeforeRightQuery>
        <IndentRightQuery>false</IndentRightQuery>
      </UnionsExceptsIntersects>
      <SpaceBeforeAllDistinct>Space</SpaceBeforeAllDistinct>
      <IndentAllDistinct>true</IndentAllDistinct>
      <AlignAllDistinctWithSelectList>false</AlignAllDistinctWithSelectList>
      <SpaceBeforeTop>Space</SpaceBeforeTop>
      <IndentTop>true</IndentTop>
      <AlignTopWithSelectList>false</AlignTopWithSelectList>
      <SelectList>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>true</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>NoSpace</SpaceAfterDelimiter>
        <Align>true</Align>
        <AlignAliases>false</AlignAliases>
      </SelectList>
      <Into>
        <SpaceBefore>Unspecified</SpaceBefore>
        <Indent>true</Indent>
        <SpaceBeforeTable>Unspecified</SpaceBeforeTable>
        <IndentTable>true</IndentTable>
      </Into>
      <Where>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeConditions>Space</SpaceBeforeConditions>
        <IndentConditions>true</IndentConditions>
      </Where>
      <GroupBy>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <Items>
          <SpaceBefore>Space</SpaceBefore>
          <Indent>false</Indent>
          <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
          <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
          <Align>true</Align>
        </Items>
      </GroupBy>
      <Having>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeConditions>Unspecified</SpaceBeforeConditions>
        <IndentConditions>true</IndentConditions>
      </Having>
      <OrderBy>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <Items>
          <SpaceBefore>Space</SpaceBefore>
          <Indent>false</Indent>
          <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
          <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
          <Align>true</Align>
        </Items>
      </OrderBy>
      <For>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
      </For>
      <Option>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
      </Option>
    </Select>
    <Insert>
      <SpaceBeforeTop>LineBreak</SpaceBeforeTop>
      <IndentTop>true</IndentTop>
      <Into>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeTable>Space</SpaceBeforeTable>
        <IndentTable>true</IndentTable>
      </Into>
      <Columns>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>NoSpace</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>LineBreak</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>LineBreak</SpaceBeforeFirstItem>
        <SpaceAfterLastItem>LineBreak</SpaceAfterLastItem>
        <IndentItems>true</IndentItems>
        <AlignAsTable>false</AlignAsTable>
      </Columns>
      <Values>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeRows>LineBreak</SpaceBeforeRows>
        <IndentRows>false</IndentRows>
        <SpaceBeforeRowDelimiter>LineBreak</SpaceBeforeRowDelimiter>
        <SpaceAfterRowDelimiter>LineBreak</SpaceAfterRowDelimiter>
        <AlignRows>true</AlignRows>
        <SpaceAfterOpeningBrace>LineBreak</SpaceAfterOpeningBrace>
        <SpaceBeforeClosingBrace>LineBreak</SpaceBeforeClosingBrace>
        <IndentValues>true</IndentValues>
        <SpaceBeforeValueDelimiter>NoSpace</SpaceBeforeValueDelimiter>
        <SpaceAfterValueDelimiter>LineBreak</SpaceAfterValueDelimiter>
        <AlignValues>true</AlignValues>
        <AlignValuesAsTable>true</AlignValuesAsTable>
      </Values>
      <Query>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
      </Query>
    </Insert>
    <Update>
      <SpaceBeforeTop>LineBreak</SpaceBeforeTop>
      <IndentTop>true</IndentTop>
      <Target>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeTable>Space</SpaceBeforeTable>
        <IndentTable>true</IndentTable>
      </Target>
      <Set>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <Assignments>
          <SpaceBefore>Space</SpaceBefore>
          <Indent>false</Indent>
          <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
          <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
          <Align>true</Align>
          <SpaceBeforeOperator>Space</SpaceBeforeOperator>
          <SpaceAfterOperator>Space</SpaceAfterOperator>
        </Assignments>
      </Set>
      <Option>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
      </Option>
    </Update>
    <Delete>
      <SpaceBeforeTop>LineBreak</SpaceBeforeTop>
      <IndentTop>true</IndentTop>
      <Target>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeTable>Space</SpaceBeforeTable>
        <IndentTable>true</IndentTable>
      </Target>
      <Option>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
      </Option>
    </Delete>
    <From>
      <SpaceBefore>LineBreak</SpaceBefore>
      <Indent>false</Indent>
      <SpaceBeforeTables>Space</SpaceBeforeTables>
      <IndentTables>false</IndentTables>
      <SpaceBeforeTableDelimiter>LineBreak</SpaceBeforeTableDelimiter>
      <SpaceAfterTableDelimiter>Unspecified</SpaceAfterTableDelimiter>
      <AlignTables>true</AlignTables>
      <AlignAliases>true</AlignAliases>
      <Joins>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceAfterOperator>Space</SpaceAfterOperator>
        <IndentRightTableAndOn>true</IndentRightTableAndOn>
        <SpaceBeforeOn>LineBreak</SpaceBeforeOn>
        <IndentOn>false</IndentOn>
        <SpaceBeforeOnCondition>Space</SpaceBeforeOnCondition>
        <IndentOnCondition>true</IndentOnCondition>
        <AlignOns>true</AlignOns>
      </Joins>
    </From>
    <Where>
      <SpaceBefore>LineBreak</SpaceBefore>
      <Indent>false</Indent>
      <SpaceBeforeConditions>Space</SpaceBeforeConditions>
      <IndentConditions>false</IndentConditions>
    </Where>
    <Output>
      <SpaceBefore>LineBreak</SpaceBefore>
      <Indent>true</Indent>
      <Columns>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <AlignAliases>true</AlignAliases>
      </Columns>
      <Into>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeTable>Space</SpaceBeforeTable>
        <IndentTableAndColumns>false</IndentTableAndColumns>
        <Columns>
          <SpaceBefore>Space</SpaceBefore>
          <Indent>false</Indent>
          <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
          <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
          <Align>true</Align>
          <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
          <SpaceAfterLastItem>Space</SpaceAfterLastItem>
          <IndentItems>false</IndentItems>
        </Columns>
      </Into>
    </Output>
    <CreateTable>
      <SpaceBeforeName>Space</SpaceBeforeName>
      <IndentName>false</IndentName>
      <Columns>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>NoSpace</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>LineBreak</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>LineBreak</SpaceBeforeFirstItem>
        <SpaceAfterLastItem>LineBreak</SpaceAfterLastItem>
        <IndentItems>true</IndentItems>
        <AlignColumnsTypes>true</AlignColumnsTypes>
      </Columns>
    </CreateTable>
    <Execute>
      <Arguments>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <AlignValues>true</AlignValues>
      </Arguments>
    </Execute>
    <Declare>
      <Variables>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <AlignDataTypes>true</AlignDataTypes>
        <AlignValues>true</AlignValues>
      </Variables>
    </Declare>
    <Procedure>
      <Parameters>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>true</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>NoSpace</SpaceAfterDelimiter>
        <Align>true</Align>
        <AlignDefaultValues>true</AlignDefaultValues>
      </Parameters>
      <Options>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <IndentItems>false</IndentItems>
      </Options>
      <SpaceBeforeAs>LineBreak</SpaceBeforeAs>
      <SpaceBeforeStatements>LineBreak</SpaceBeforeStatements>
      <IndentBlock>false</IndentBlock>
      <IndentStatements>true</IndentStatements>
    </Procedure>
    <Function>
      <Parameters>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <SpaceAfterLastItem>Space</SpaceAfterLastItem>
        <IndentItems>false</IndentItems>
        <AlignDefaultValues>true</AlignDefaultValues>
      </Parameters>
      <SpaceBeforeReturns>LineBreak</SpaceBeforeReturns>
      <Options>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <IndentItems>false</IndentItems>
      </Options>
      <SpaceBeforeAs>LineBreak</SpaceBeforeAs>
      <SpaceBeforeBeginEndBody>LineBreak</SpaceBeforeBeginEndBody>
      <IndentBeginEndBody>false</IndentBeginEndBody>
      <SpaceBeforeReturnBody>LineBreak</SpaceBeforeReturnBody>
      <IndentReturnBody>true</IndentReturnBody>
      <SpaceBeforeExternalNameBody>LineBreak</SpaceBeforeExternalNameBody>
      <IndentExternalNameBody>true</IndentExternalNameBody>
    </Function>
    <View>
      <IndentName>true</IndentName>
      <Columns>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <SpaceAfterLastItem>Space</SpaceAfterLastItem>
        <IndentItems>false</IndentItems>
      </Columns>
      <Options>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <IndentItems>false</IndentItems>
      </Options>
      <SpaceBeforeAs>LineBreak</SpaceBeforeAs>
      <IndentAs>false</IndentAs>
      <SpaceBeforeSelectStatement>LineBreak</SpaceBeforeSelectStatement>
      <IndentSelectStatement>true</IndentSelectStatement>
      <SpaceBeforeWithCheckOption>LineBreak</SpaceBeforeWithCheckOption>
    </View>
    <Trigger>
      <IndentName>true</IndentName>
      <SpaceBeforeOn>LineBreak</SpaceBeforeOn>
      <IndentOn>false</IndentOn>
      <SpaceBeforeTarget>Space</SpaceBeforeTarget>
      <IndentTarget>true</IndentTarget>
      <Options>
        <SpaceBefore>LineBreak</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
        <SpaceBeforeFirstItem>Space</SpaceBeforeFirstItem>
        <IndentItems>false</IndentItems>
      </Options>
      <SpaceBeforeForAfterInsteadOf>LineBreak</SpaceBeforeForAfterInsteadOf>
      <IndentForAfterInsteadOf>false</IndentForAfterInsteadOf>
      <Events>
        <SpaceBefore>Space</SpaceBefore>
        <Indent>false</Indent>
        <SpaceBeforeDelimiter>LineBreak</SpaceBeforeDelimiter>
        <SpaceAfterDelimiter>Space</SpaceAfterDelimiter>
        <Align>true</Align>
      </Events>
      <SpaceBeforeAs>LineBreak</SpaceBeforeAs>
      <IndentAs>false</IndentAs>
      <SpaceBeforeStatements>LineBreak</SpaceBeforeStatements>
      <IndentStatements>true</IndentStatements>
      <IndentBlockStatements>false</IndentBlockStatements>
    </Trigger>
    <TextCase>
      <KeywordsCase>UpperCase</KeywordsCase>
    </TextCase>
  </Options>
</FormatStyle>
SvendK
  • Posts: 4
  • Joined: 1/23/2018
Is it OK to bump posts? :-)
Will you reply to all posts or?
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.