search

leeonsoft / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

Bug fix for Queries like "where Field1 = Field2" with fields from same dataset #13

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Queries with where clause like "Field1 = Field2" (fields from same dataser) do 
not work.

Bug fix in xQuery.pas :

Procedure TSqlAnalizer.DoJoinInWhere;

  Procedure RecursiveJoin(Start: Integer);
  begin
  ... 
  End;

Begin
  { recursively joining }
  if FTableList.Count > 0 then // change to 0 (was 1) from eLion
    RecursiveJoin(-1); // was 0. Have to start from -1 for queries like select ... where Field1 = Field2
End;

eLion

Original issue reported on code.google.com by lion.emm...@gmail.com on 25 Jan 2011 at 12:58

GoogleCodeExporter commented 9 years ago 
Hi I have uploaded updated sources for txquery please chek issue #19 to 
download the sources. make tests, any feedback will be appreciated

Original comment by fdue...@gmail.com on 25 Aug 2011 at 2:52