Auto numbering problem on Insert from web service method

[Thys]

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

[Bruce]

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

Cheers
Bruce

[Thys]

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

Thanks Bruce.