mibuso.com
Home› NAV/Navision Classic Client

Cannot Perform SET operation Error

ricky76ricky76 Member Posts: 204
edited 2007-05-21 in NAV/Navision Classic Client
Wondered if anyone could help me. On the validation trigger of a field in the purchase line table i have some code that checks certain conditions and if it does it tries to go away and write an insert into another bespoke table. When this tries to happen i get an error saying the Current user is not the database or object owner for table (bespoke table name) cannot perform set operation. I have looked this up on the Microsoft website and it is listed there as a bug but a couple of the workarounds suggested are not ideal. Has anyone else come across this issue and could i eliminate it by working my code in a different way?? Any help would be most appreciated.

Comments

  • ricky76ricky76 Member Posts: 204
    Can anyone help??
  • DenSterDenSter Member Posts: 8,307
    I don't think anyone here has any clue what you are talking about.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ricky76ricky76 Member Posts: 204
    I am amazed as it is a known bug with SQL Server 2000. Still, managed to get round it.
  • GarethGareth Member Posts: 17
    Does your bespoke table have a field with the AutoIncrement property set to yes? If so, make sure you set this field to zero before doing an INSERT. If this field is in the primary key then an INIT alone will not clear the variable.
  • ricky76ricky76 Member Posts: 204
    Gareth, thank you very much for your help. This indeed was the problem.
Sign In or Register to comment.