›
Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Accessing Insert records through the Repository Function

Luann_DiasLuann_Dias
in OpenInsight
So I've been able to access the contents of stored procedures using the Repository("ACCESS", ) function , with being the value of => (@APPID<;1> :"*STPROC**":procedureName). My issue is that I'm not aware of the location of where insert records get stored. I think that "STPROC" may not be the case in that instance. Any idea of what the right name should be? (Also if there's an easier way of grabbing the contents of procedures using XLATES instead of the Repository function please let me know)

Thanks

Comments

  • KevinFournierKevinFournier
    The type you want is STPROCINS. If you look in the SYSREPOSTYPES table, you'll see a list of all the types.
  • Luann_DiasLuann_Dias
    Excellent, thank you!
  • DonBakkeDonBakke
    edited December 2022
    The system table where source code and inserts are stored is SYSPROCS. As Kevin showed you, inserts have their own entity type so that is why the Repository function wasn't working.
Sign In or Register to comment.