2. PHPRunner General questions
  3. Table Count On A Non-Object
This topic is locked

Table Count On A Non-Object

 		5/30/2013 3:52:06 PM
PHPRunner General questions
M
 mdibarra author

Fatal error: Call to a member function TableCount() on a non-object in ..\output\classes\sql.php on line 74
sql.php on line 74

if($this->m_strTable == "" || $query->TableCount() == 1)




function toSql($query)

{

if($query->cipherer != null)

return $query->cipherer->GetFieldName(

($this->m_strTable != "" && $query->TableCount() > 1 ? AddTableWrappers($this->m_strTable)."." : "")

.AddFieldWrappers($this->m_strName));



$fieldName = AddFieldWrappers($this->m_strName);

if($this->m_strTable == "" || $query->TableCount() == 1)

{

return $fieldName;

}

else

{

return AddTableWrappers($this->m_strTable) . "." . $fieldName;

}

}


SQL QUERY:
SELECT

COUNTRY,

OFFICE_NAME,

COUNT(*) AS SITES,

SUM(NO_OF_POS) AS WS

FROM SITES.SITES

WHERE (SUPPORT = 'Y')

GROUP BY OFFICE_NAME, COUNTRY

HAVING SUM(NO_OF_POS) !=0

ORDER BY OFFICE_NAME, COUNTRY
Any idea to solve this issue?
Sergey Kornilov admin 5/31/2013

As a first step make sure you use the latest available build of PHPRunner and perform a full project build. If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
M
 		mdibarra author 5/31/2013

PHPRunner Enterprise 6.2 (Build 14199)
M
 		mdibarra author 5/31/2013

No, I'm not understanding you. What is "Demo Account URL"?