NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Richard I on October 03, 2017, 04:31:21 PM

Title: Error 33 message continues
Post by: Richard I on October 03, 2017, 04:31:21 PM

Hi there,
my error 33 message is still intermittently occuring on server desktop.
I have a check box Edit in place field in a browse row
the code on the server side is
 all:RecordId = p_web.GSV('all:RecordId')
   IF access:Allergy.tryfetch(all:byLogID) = LEVEL:BENIGN
      all:AllergyCheck     = 1
      all:AllergyCheckDate = today()
   END

The allergy table and this routine are being used by different users at the same time.
If a single user checks the edit in place, the error 33  does not occur

The filter on the browse removes the record from the browse when  all:allergycheck = 1
I note in the Individual file overrides, all options are set to "Use default"
Should I changes any of these?
ie File open
Should i change to  Share or open?
and defer file opening..
Should i set to  Yes? or No?

I am reluctant to trial this on a live system.

guidance please  !!
thanks
Richard
NT 8.71

Title: Re: Error 33 message continues
Post by: Bruce on October 03, 2017, 09:17:30 PM

Hi Richard,

Does the Allergy table have the THREAD option ticked on in the dictionary?
It should be on (indeed it should be on for all your tables.)

>> all options are set to "Use default". Should I changes any of these?

no.

cheers
Bruce

Title: Re: Error 33 message continues
Post by: Richard I on October 03, 2017, 10:01:50 PM

Thanks Bruce, Ill turn it on
Cheers
Richard

Title: Re: Error 33 message continues .Allergy Table was and is threaded
Post by: Richard I on October 03, 2017, 10:37:57 PM

Bruce,
The Allergy Table was and is Threaded.
so are all other tables.

Because the EIP check box is in the Allergy Browse, I havent done so ,but  is there any need to code anything like Share the table or Open the table in the Server side code?

It appears that if two different iterations both try and update the Allergy table simultaneously,using the EIP it returns the error 33
I cannot replicate it using the clients app via the web when I am the only one selecting the EIP check

Thanks
Richard

Title: Re: Error 33 message continues
Post by: Bruce on October 04, 2017, 09:41:46 AM

>> but  is there any need to code anything like Share the table or Open the table in the Server side code?

probably - but if that was the problem then it would never work.

perhaps it's not number of users related - perhaps you are clicking another check too quickly as one user - before the row has finished refreshing?

Bruce