NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Thys on June 08, 2017, 03:17:10 AM

Title: Auto numbering problem on Insert from web service method
Post by: Thys on June 08, 2017, 03:17:10 AM

Hi,

I get a Clarion error message when inserting a child record in MSSQL, where a trigger on the child table checks whether a parent record exists (special conditions, so normal FK constraint can't work). When the auto numbering in Clarion is done and the record is added, the trigger returns the error - but this is not passed back to the Clarion code to report the error to the web service method. See attached.

The app is set to Release, so I didn't expect the error to be displayed. Any suggestions on how to deal with it?

Thanks
Thys

Title: Re: Auto numbering problem on Insert from web service method
Post by: Bruce on June 08, 2017, 07:57:41 AM

you'd have to filter it out using MessageBox or some other implementation of System{prop:messagehook}

Cheers
Bruce

Title: Re: Auto numbering problem on Insert from web service method
Post by: Thys on June 08, 2017, 09:15:27 AM

It will solve the possible message block, but it won't pass through the actual error message.

Thanks Bruce.