NetTalk Central

Author Topic: Auto numbering problem on Insert from web service method  (Read 3728 times)

Thys

  • Sr. Member
  • ****
  • Posts: 311
    • View Profile
    • Incasu
    • Email
Auto numbering problem on Insert from web service method
« 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

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Auto numbering problem on Insert from web service method
« Reply #1 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

Thys

  • Sr. Member
  • ****
  • Posts: 311
    • View Profile
    • Incasu
    • Email
Re: Auto numbering problem on Insert from web service method
« Reply #2 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.