Update SQL record Follow

0
Avatar
Simon Barnsley

Having real trouble getting a very simple SQL record to update when the label is printed.

 

The label is printed using a unique Equipment number and I just want the SQL to record / update that this Equipment number has been printed.

I have attached my label document if anyone can help me out. thanks

https://drive.google.com/file/d/1G-kqbZVwuFcIE0XMDLqV4niu2vae2vr2/view?usp=sharing 

3 comments

0
Avatar
Pete Thane
Comment actions Permalink

I am guessing it could be user rights on the action so maybe worth trying with a specific user account that has full rights to the SQL table rather than the user Windows credentials. Some of the processes are not run by the actual user but the local system account for example and I have come across issues before where those have no or insufficient permissions to access databases and network locations etc. 

(Castle Hill or Hull Royal? Just down the road from them!)

0
Avatar
Simon Barnsley
Comment actions Permalink

Hi Pete,

I have managed to get a specific record to update by entering its specific Equipment number into the Query, so I now know that there is no challenge with user credentials. 

Just struggling with %TBW Equip%  :( 

 

0
Avatar
Pete Thane
Comment actions Permalink

Sorry not sure, you may want to ping a support request through to the guys in Technical Support and see if they can put your right. 

Please sign in to leave a comment.