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.

Reply via email to