smarthaert / txquery

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

First attempt to use TXQuery failed dismally what is wrong? #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
using latest version in svn http://txquery.googlecode.com/svn/trunk/ 
txquery-read-only

Did not recognize SELECT token, as far as I remember that was the first thing 
you do in SQL. What is happening?

  with slSQL do
    begin
       add('SELECT *');
       add('FROM PB');
       add('LEFT OUTER JOIN PL');
       add('ON( PB.TERMID  = PL.CD_WS )');
       add('AND( PB.SEQNO  = PL.AI_SRC_FILE )');
    end;
      xqry       := TXQuery.Create(nil);
      xdi        := xqry.DataSets.Add;
      xdi.Alias  := 'PB';
      xdi.DataSet := memPOStBOS;
      xdi        := xqry.DataSets.Add;
      xdi.Alias  := 'PL';
      xdi.DataSet := memPOSLOG;
      xqry.SQL.Assign(slSQL);
      xqry.Open;
      { at this point exception is created

ExqueryError: syntax error at line : 1, Column 0, token SELECT

}

      xqry.Close;
      FreeAndNil(xqry);

Original issue reported on code.google.com by rgilland...@gmail.com on 24 Jul 2012 at 7:06

GoogleCodeExporter commented 9 years ago
OK,

This was because I commented out the resource files as I didn't know how to 
build them.
Solved that probelm which solved this problem

Original comment by rgilland...@gmail.com on 24 Jul 2012 at 11:12