Here a complete example (php and sybase) with the
problem of compute sql statement.
PHP stop when he encountred the
compute.
PHP :
sybase_query=("EXEC
MYPROC");
$result =
sybase_query($query);
while ($row = sybase_fetch_array($result)) { print $row["COLUMN1"]; print $row["COLUMN3"]; print $row["COLUMN3"]; } SYBASE PROC :
SELECT DISTINCT doc1,";", conste+concen +conqtm+conord+coni1+coni2,";", numchg,"; ", rais1d,";", cpd,";", intcomd,";", dpliv,";", tcaht, ";", qtet,";", crgro, ";" FROM fantasio..f_mtf WHERE datchg>=@debut AND datchg<=@fin AND unit='6' ORDER BY dpliv, rais1d, intcomd, cpd COMPUTE SUM(tcaht), SUM(qtet) BY dpliv, rais1d, intcomd, cpd PHP stop on COMPUTE... Then it's a bug of PHP This error is encountred when i try to return two select. |