[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    koffice/kexi/plugins/queries
From:       Jaroslaw Staniek <js () iidea ! pl>
Date:       2005-10-13 13:22:01
Message-ID: 1129209721.806087.2712.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 470258 by staniek:

Query Designer

- conditions: ambiguous expressions fixed: 
  "t1.id > 100" is used instead of "id > 100" in queries like
  SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.id > 100
- fixed possible crash when invalid query design is loaded in design view
- fixed switching to design mode after invalid query was opened directly in text mode 
- eat parentheses on criteria loading, in WHERE conditions like (a.id = value)
- also accept tableName.fieldName on criteria loading, not only tableName
- also accept e.g. "2 = variable" as condition, not only "variable = 2"
- graphical representation of joins is generated back from SQL statement not only 
  based on explicit query schema's relations but are also retrieved 
  from "[t1.]f1 = [t2.]f2" expressions within WHERE section



 M  +128 -57   kexiquerydesignerguieditor.cpp  
 M  +11 -1     kexiquerydesignerguieditor.h  
 M  +28 -14    kexiquerydesignersql.cpp  
 M  +1 -1      kexiquerydesignersql.h  
 M  +3 -2      kexiquerypart.cpp  
 M  +8 -5      kexiquerypart.h  


[prev in list] [next in list] [prev in thread] [next in thread]