|
By saturation - Thu 25 Nov 2010
|
|
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.
|
|
By Paul - Sun 28 Nov 2010
|
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.
|
|