Hi,
In a form I have a field with the following Select query
SELECT DISTINCT RTDepartments.RTDepartmentID,
CONCAT(Cities.ZIP,’ ‘,Cities.City,’ ‘,RTDepartments.Address,’ ‘,States.ISO,’/’,Countries.ISO)
FROM RT Departments
JOIN EmployeeProfiles ON FIND_IN_SET(RTDepartments.RTDepartmentID, EmployeeProfiles.RTDepartments) > 0
INNER JOIN Cities ON RTDepartments.CityID = Cities.CityID
INNER JOIN States ON Cities.StateID = States.StateID
INNER JOIN Countries ON States.CountryID = Countries.CountryID
WHERE EmployeeProfiles.EmployeeProfileID = 1
The script works fine under SQL
However, when I want to generate the form, the following error message comes up
Salvatore Reinemuth_@S_9.9.014 (23)_@S_R116QDWT
form_PracticalLessons_Exams_@S_form_@S_error
Attempt to read property “EOF” on bool | Script: D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php linha: 2248
Attempt to read property “fields” on bool | Script: D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php linha: 2250
Trying to access array offset on value of type null | Script: D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php linha: 2250
Attempt to read property “fields” on bool | Script: D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php linha: 2250
Fatal error: Uncaught Error: Call to a member function MoveNext() on bool in D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php:2251
Stack trace:
#0 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmDados.class.php(7790): nm_db_fields_type(‘conn_mysql’, ‘UTF-8’, Object(ADODB_pdo), Object (nmConnection), ‘select DISTINCT…’, ‘’, false, false, true)
#1 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmFontePHP.class.php(21057): nmDados->AnalizaLookup(‘SELECT DISTINCT…’, ‘conn_mysql’, 530 , ‘rtdepartmentid’)
#2 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmFontePHPForm.class.php(2436): nmFontePHP->Lookup(false, 530, ‘’)
#3 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmControleForm.class.php(55): nmFontePHPForm->InicializaDados()
#4 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmGerador.class.php(2073): nmControleForm->GeraFonte()
#5 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\gerador.php(100): nmGerador->IniciaGeracao(‘BlueOrganizer_9…’, ‘23’, ‘form_PracticalL… .’, ‘’)
#6 D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\gerador.php(2): sg_load(‘68ABBE04C7C5024…’)
#7 {main}
thrown in D:\Programs\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php on line 2251