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
|