execute ms-sql stored proc

nait · Post by **nait** » Fri Feb 10, 2017 12:20 am

is it possible to execute an ms sql stored procedured from a button click?

if this is not possible is it possible to execute a ms-sql stored procedure after a row is updated.

the procedure will perform an insert into a table using parameters from the row, but this should run on sql server i guess

for example i created a view that does a sort of dummy update but executes the stored procedure.

any help would be appreciated

nait

nait · Post by **nait** » Fri Feb 10, 2017 12:28 am

i have put the following code in

function Row_Updated($rsold, &$rsnew) {

//execute my stored proc
ew_Execute("usp_TAMADMIN");

}

after pressing save i get server error 500

mobhar · Post by **mobhar** » Fri Feb 10, 2017 9:17 am

Is your Stored Procedure contains parameter?

nait · Post by **nait** » Mon Feb 13, 2017 7:04 pm

hi thanks for you reply

its has two parameters, but i have also tried to execute a stored proc with no parameters but it does not run

mobhar · Post by **mobhar** » Mon Feb 13, 2017 7:11 pm

Make sure you have already added () characters after the SP's name.

nait · Post by **nait** » Tue Feb 14, 2017 12:56 am

HI adding () has made no difference when i update the row after update i get the server 500 error

mobhar · Post by **mobhar** » Tue Feb 14, 2017 9:33 am

Assume you are using v2017, and your SP name is "MySP" and it has no parameter, then try this:

global $UserTableConn;
$rs = $UserTableConn->Execute("MySP()");
if ($rs->RecordCount()==0) {
$this->setSuccessMessage("SP is OK");
} else {
$this->setFailureMessage("SP not OK");
}

nait · Post by **nait** » Thu Feb 16, 2017 10:52 pm

hi apologies im using v12

mobhar · Post by **mobhar** » Thu Feb 16, 2017 10:58 pm

Then try this:

global $conn;
$rs = $conn->Execute("MySP()");
if ($rs->RecordCount()==0) {
$this->setSuccessMessage("SP is OK");
} else {
$this->setFailureMessage("SP not OK");
}