TUniStoredProc with postgreSQL

[Suhaimin]

Thanks AlexP..
UNISTOREDPROC1.STOREDPROCNAME :='GETINVOICENO';
SHOWMESSAGE(UNISTOREDPROC1.PARAMBYNAME('result').ASSTRING);

after i follow your instruction. when i run unistoredproc1.parambyname('result').asstring or unistoredproc1.parambyname('result').asstring , then error occur parameter "result" not found. why this occur? thanks

[AlexP]

Hello,

As I wrote in the last post, OUT parameters (RESULT is an OUT parameter) are initialized on an EXECUTE method call. If you want parameters to be defined before procedure execution, you should run the PREPARE method.

[Suhaimin]

hello,

unistoreproc1.execute;
Unistoreproc1.STOREDPROCNAME :='GETINVOICENO';
SHOWMESSAGE(UNISTOREDPROC1.PARAMBYNAME('result').ASSTRING);

i got error parameter "result" not found. i change the code to unistoredproc1.fieldbyname('result').value then error fieldbyname result not found.
why this error occur ? thanks a lot

[AlexP]

Hello,

The Execute method (as well as the Prepare method) should be called after you specify a stored procedure name.