Search results

  1. H

    Using subquery in select statement

    Simple SQLQUERY below works MSSQL and ORACLE. ------- Select CustNum, (Select Sum(TotalPaid) From Invoice) From Customer ------- But when I call this simple query from ODBC connection on Progress DB, ODBC driver generate "SQL syntax error". Why doesn't work. Is this an SQL92 capability...
  2. H

    Date-Format

    I have a project on delphi and I want to set date format using odbc connection. But I couldn't succes to use SESSION:DATE-FORMAT = "DMY" commmand.
  3. H

    Insufficient Memory

    I have just met wit progres. I have a delphi project used ADO driver and when I run the sql statement like this Select T1.X,T2.Y,T2.Z from Table1 as T1 left join Table2 as T2 on (T1.ID = T2.ID) I get the error message below "Insufficient Memory, Memory allocation failed at 1618 in...
Top