NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Richard I on May 08, 2016, 02:53:15 PM

Title: Intermittent Error 33 message being posted
Post by: Richard I on May 08, 2016, 02:53:15 PM

Hi
I have two clients reporting that that an error 33 popup messages are appearing on the desktop of the server that is hosting my webserver
The popup is saying that the employee file is not being updated but in fact it is.
Im not using tryfetch

I cannot replicated this error on my local network.
Can I have some guidance on this please?

Thanks Richard

Title: Re: Intermittent Error 33 message being posted
Post by: osquiabro on May 08, 2016, 04:30:26 PM

have a primary key defined in the form?

Title: Re: Intermittent Error 33 message being posted
Post by: Richard I on May 08, 2016, 05:30:49 PM

Hi
Thanks for replying but I am a little uncertain as to what you are saying or suggesting?
I call the employees by a  unique key, not the primary key.
The primary key is the recordID
thanks
Richard

Title: Re: Intermittent Error 33 message being posted
Post by: Bruce on May 08, 2016, 10:43:37 PM

do you have any hand-code in the form in question?
does that hand-code do any table access?

cheers
Bruce

Title: Re: Intermittent Error 33 message being posted
Post by: Richard I on May 09, 2016, 01:53:50 AM

Hi Bruce,
yes the handcode  accesses the employee file by unique code, gets details, and includes in log as they log in , and makes them                            EMP:LoggedIn   = 1
When logging out access again and  makes them            EMP:Loggedin    = 0

Access:Employees.Update()

Following the C10 posting I have changed to
Access:Employees.TryUpdate()

Im fetching the Employee by login code on a unique key


All works well here but....

Thanks,
Richard

Title: Re: Intermittent Error 33 message being posted
Post by: Bruce on May 09, 2016, 10:37:53 PM

Hi Richard,

you haven't posted your code block, but it's important to put all the code together into one embed.
And you must open and close the tables you are using as well.

If you have any Unique keys on the table (other than the primary key) or you are changing the primary key value, then you also need to pre-emptivly check for Duplicates.

But as long as you are doing the TryUpdate then at least it's not that line generating a message.

Cheers
Bruce

Title: Re: Intermittent Error 33 message being posted
Post by: Richard I on May 12, 2016, 02:47:00 PM

Hi Bruce,
I have changed the Updates and Fetches to TryUpdate and TryFetch
and am about to release this version.
 
If the error message persists I will forward the code.
Thanks for your help
Richard