Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql error messages
Date:Thu, 24 Sep 2020 15:59:44 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
Try the following and see what comes up in strError. If you're 
executing a procedure or function, it may be you've called "RAISE 
EXCEPTION" without a message.

var
    strSQL string
    strError string
    SQLCommand SQL
endvar

stSQL = "SELECT .... etc etc"
;// Execute the SQL command agains the requested database
try
    SQLCommand.readFromString(strSQL)
    ExecuteSQL(YourDBParam, SQLCommand)
    return True
onFail
    strError = ErrorStackToString()
    return False
endTry

method ErrorStackToString() string
    var
       stError string
    endvar
    stError = ""
    while ErrorMessage() <> ""
       stError = stError + " " + ErrorMessage()
       ErrorPop()
    endWhile
    return stError
endMethod

On 24/09/2020 3:15 am, Mark Bannister wrote:
> I can't seem to get error messages back from the server.
> Is there something I'm doing wrong.  I get a failure, but not the error 
> itself.
> -- 
> Mark B


Copyright © 2004 thedbcommunity.com