Recent content by Hasan Haliciogl

  1. H

    Using subquery in select statement

    I hope so. Thank you.
  2. H

    Using subquery in select statement

    Yes, the problem is "the sample code" that you send to me run in Oracle, MS SQL, Interbase,... but doesn't work on Progress. I have tried to find a way to solve that problem for 3 weeks.
  3. H

    Using subquery in select statement

    Thanks, but I must use the subquery to solved my problem.
  4. H

    Using subquery in select statement

    I realy thank you Casper. If you don't mind I have another question about same case. I have to pass a parameter to subquery ---------------------------------- SELECT CustNum, sq.Tutar FROM Pub.Customer CUST, (SELECT Sum(TotalPaid) FROM pub.Invoice INV WHERE INV.CustNum = CUST.CustNum )...
  5. 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...
  6. 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.
  7. H

    Insufficient Memory

    Option #2 is solved my problem. Thank you Casper.
  8. 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...
See more
Top