[RESOLVIDO] SC9 ---> ERROR em formulario no campo tipo SELECT

Bugs
#1

Estou com ERROR ao gerar aplicação de um formulario:

Campo - select

tenho o seguinte SQL

[b]SELECT loads.loadID,
CONCAT(
‘#’,
loads.referencia,
’ - ',
cities.city,
‘,’
,cities.state_code,
’ to ',
cities_1.city,
‘,’,
cities_1.state_code,
‘’
)
FROM (
state.cities cities
INNER JOIN trucks_loads.loads loads
ON (cities.seqID = loads.frm_city_seq)
)
INNER JOIN state.cities cities_1
ON (cities_1.seqID = loads.del_city_seq)

WHERE loads.empresaID=‘17’[/b]

Este formulario estava rodando na versão sc8.1 fiz a conversão para sc9.

** ERROR ***
Fatal error: Uncaught Error: Call to a member function MoveNext() on boolean in C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php:1938 Stack trace: #0 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\class\generator\nmDados.class.php(6664): nm_db_fields_type(‘trucks’, ‘ISO-8859-1’, Object(ADODB_pdo), Object(nmConnection), ‘select loads.lo…’, ‘’) #1 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\class\generator\nmFontePHP.class.php(17868): nmDados->AnalizaLookup(‘SELECT loads.lo…’, ‘trucks’, 120) #2 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\class\generator\nmFontePHPForm.class.php(2506): nmFontePHP->Lookup(false, 120, ‘’) #3 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\class\generator\nmControleForm.class.php(54): nmFontePHPForm->InicializaDados() #4 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\class\generator\nmGerador.class.php(1907): nmControleForm->GeraFonte() #5 C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\ in C:\Program Files (x86)\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php on line 1938

#2

Testa com este código mas primeiro executa a Query SQL no Gerenciador de Banco de dados desta base:
SELECT
loads.loadID,
CONCAT(loads.referencia,
’ > ',
cities.city,
’ > ',
cities.state_code,
’ >> ',
cities_1.city,
’ = ',
cities_1.state_code)
FROM
state.cities cities
INNER JOIN trucks_loads.loads loads ON cities.seqID = loads.frm_city_seq
INNER JOIN state.cities cities_1 ON cities_1.seqID = loads.del_city_seq
WHERE
loads.empresaID=‘17’
ORDER BY
loads.empresaID

Ai depois limpa o CACHE do navegador e cola na sua app form do SC e gera novamente.

#3

Jailton, muito obrigado !!!

O problema estava aqui:

SELECT loads.loadID,
CONCAT(
‘#’,

Seu exemplo deu certo !!!