function premaintain_query()
{
foreach ( $this->pre_sql as $sql)
{
$nsql = reportico_assignment::reportico_lookup_string_to_php($sql);
$recordSet = false;
$errorCode = false;
$errorMessage = false;
try {
$recordSet = $conn->Execute($nsql) ;
}
catch ( PDOException $ex)
{
$errorCode = $ex->getCode();
$errorMessage = $ex->getMessage();
}
if ( !$recordSet )
{
if ( $errorMessage )
handle_error("Query Failed<BR><BR>".$nsql."<br><br>" .
$errorMessage);
else
handle_error("Query Failed<BR><BR>".$nsql."<br><br>" .
"Status ".$conn->ErrorNo()." - ".
$conn->ErrorMsg());
}
}
$this->fetch_column_attributes();
// Run query for each target. Currently having more than
// one target means first target is array which becomes source
// for second target
//for ($i = 0; $i < count($this->targets); $i++ )
for ($i = 0; $i < 1; $i++ )
{
$target =& $this->targets[$i];
$target->set_query($this);
$target->set_columns($this->columns);
$target->start();
}
}
function premaintain_query()
{
foreach ($this->pre_sql as $sql) {
$nsql = reportico_assignment::reportico_lookup_string_to_php($sql);
$recordSet = $conn->Execute($sql);
echo $this->query_statement . "<br>Query failed : " . $conn->ErrorMsg();
}
$this->fetch_column_attributes();
// Run query for each target. Currently having more than
// one target means first target is array which becomes source
// for second target
//for ($i = 0; $i < count($this->targets); $i++ )
for ($i = 0; $i < 1; $i++) {
$target =& $this->targets[$i];
$target->set_query($this);
$target->set_columns($this->columns);
$target->start();
}
}
