Calling pgsql function from delphi

From: "samira" <srivisal(at)slu(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Calling pgsql function from delphi
Date: 2003-01-22 03:59:54
Message-ID: b0ktou$bc3$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have pgsql 7.2.2 running on linux 8. Client is win2k running Delphi6
ODBC version : 7.2.5

Create function get_machine_detail( smallint) return text as ...... language
'plpgsql'

Function was created and worked by testing from sql window in pgAdminII.
I am trying to call this function via delphi ADOdataset commandtype :
storedproc

with storedproc : It kept giving me an error stating that the parameter
setting is incorrect.

Calling using adodataset with commandtype : commandtext give me the correct
answer.
Any suggestion. Thanks
samira

Browse pgsql-general by date

  From Date Subject
Next Message Qiao Jian ( Net2Room) 2003-01-22 04:02:13 FW: ERROR: Relation "pg_user" does not exist
Previous Message Dan Delaney 2003-01-22 03:45:34 Error at end of pg_dump output (setting sequence number?)