From kde-commits  Thu Oct 13 13:22:01 2005
From: Jaroslaw Staniek <js () iidea ! pl>
Date: Thu, 13 Oct 2005 13:22:01 +0000
To: kde-commits
Subject: koffice/kexi/plugins/queries
Message-Id: <1129209721.806087.2712.nullmailer () svn ! kde ! org>
X-MARC-Message: https://marc.info/?l=kde-commits&m=112920973312963

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