Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Unanswered: Delphi PostgreSQL write error

    Have a Delphi application reading and writing to PostgreSQL 8.8.2. Application reads without error but when it writes it reports

    "No Columns Defined In Rowset" after it has written correctly to PostgreSQL database.

    Any ideas welcome.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by iwcantar
    Have a Delphi application reading and writing to PostgreSQL 8.8.2. Application reads without error but when it writes it reports

    "No Columns Defined In Rowset" after it has written correctly to PostgreSQL database.
    8.8.2 do you mean 8.2 ?

    And, it would help if you post some applicable code.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Feb 2007
    Posts
    3
    Sorry, it was it the end of a long day

    Should have been 8.2.2

    The code, a simplfied version

    adoquery1.Active:=false;
    adoquery1.SQL.Clear;
    adoquery1.SQL.add('insert into locks_txm_po(polock) values (1234)');
    adoquery1.ExecSQL;

    Writes correctly and throws the error in Delphi 2005 & Delphi.net whereas the equivalent code in vb.net writes and doesn't throw the error.

    Am now wondering about the connection string, which is

    Provider=PostgreSQL OLE DB Provider;Password=ian;User ID=iancharters;Data Source=127.0.0.1;Location=textileman;Extended Properties=""

    Perhaps Delphi is looking for additional settings?

  4. #4
    Join Date
    Feb 2007
    Posts
    3
    Had another look at the settings for the ADO Connection and resloved the problem by changing the "CursorLocation" from 'clUseClient' to 'clUseServer' and it writes without throwing the error.

    Thanks for your interest.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •