Hi ratbak,

It looks like the easiest solution is to right-click in the grey area outside the report body, select Report Properties, and change the Page Setup there.

Extension definitions.  Ok thanks, I never heard of that before.

Frederico,

Thanks but that page doesn't call Stored Procedures.  That illsutrates parameterized queries with straight UPDATEs or INSERTs.  We don't have any problem doing that.

Anyway, our issue is resolved.  It's because...

Got it.  I can't believe it.

It's the absence of braces.

The call to the Stored Procedure should be written

$sql_prep = "{ p_1A_insert( ?, ?, ?, ?, ?, .....

rather...

The sqlsrv_query call, that we were originally using, works fine.

The problem is

$stmt = sqlsrv_prepare($queryLink, $sql_prep, $spParams ) ;
$storedProc = sqlsrv_execute($stmt) ;

The sqlsrv_prepare() call returns a valid object. ...

Ok, thanks SSC.

I also ran through it in Python, after creating a mini-table with only 5 fields, and a corresponding INSERT Stored Procedure.

Same result.  I tried both Driver 11, and...

Yes, I understand.  I'm just saying I can't find a reference to it anywhere, using a global search in the project subfolders, which includes all the php and all the...

Hi MVDBA,

Yes, we're already using a Stored Procedure, and it runs fine with sqlsrv_query.  We just can't seem to execute it, with prepared statements.

@p1 is not referenced anywhere in the...