|
Group: Forum Members
Last Active: Fri 30 Nov 2012
Posts: 108,
Visits: 1,185
|
How and/or where do I change the SQL statements, or at a bare minimum, where are the stored procedures called? I can't seem to find a reference to them in the .NET pages anywhere.
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
The stored procedures are called from within the kartris dll (bin folder), which is compiled.
But the stored procedures themselves are SQL statements and can be edited. These can be found within the SQL database itself. If you open it up in MS SQL Studio express and then look in programmability >> stored procedures, you will find them.
Sprocs used for the back end begin with an underscore _
Each sproc is named systematically to describe what it applies to.
Be aware that modifying stored procedures so that the interface no longer matches kartris can introduce errors (for example, if the sproc expects 3 parameters and outputs 5 fields for each record and your modifications change this, it will likely cause an error either going into the sproc, or in the page that receives data back from the sproc).
Kartris uses parametrized stored procedures rather than inline SQL strings for performance and security.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|