Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#8 Strange behaviour of Find match

Next_release
closed
Ken Clubok
Interface (5)
5
2006-02-06
2006-01-18
Drzewiecki T.
No

Simple query (OpenEditor inside SQLTools 1.4.1 Beta
build 66):

(SELECT
MAX(A_ED.EFFDT)
FROM TBL@A A_ED
WHERE A_ED.SETID = E.SETID
AND A_ED.CHARTFIELD1 = E.CHARTFIELD1
OR A_ED.EFFDT <= SYSDATE)

Place cursor just after first '('. After 'Find Match'
cursor goes before 'FROM' keyword, second time
before 'WHERE' keyword, finally goes before last ')'.

This behaviour is identical if you place cursor in the
middle of 'SELECT', 'FROM' and 'WHERE'.

In another keywords like 'AND', 'OR' or in variables
cursor don't change its place (it doesn't find a
match?).

Proper behaviour (in my opinion): if cursor is before
or after '(' apropriate match is found. In another
places cursor doesn't move or proper message is shown.

Discussion

  • Drzewiecki T.
    Drzewiecki T.
    2006-02-05

    • assigned_to: nobody --> clubok
    • summary: Find match - strange behaviour --> Strange behaviour of Find match
     
  • Logged In: NO

    It warks as designed. Always match keyword after cirsor if
    not found then after. It does not support all syntax
    constructions: {},(),declare/begin/end, proc/packages and
    major sql statements. Not a bug at all.

     
    • status: open --> closed