[RESOLVIDO]bug sc9 - Quebra Dinâmica Consulta - ORACLE

Bugs
#1

[size=14pt]O erro ocorre justamente quando se escolhe um item da quebra… porém se vc clicar no botão detalhe não ocorre o erro.[/size]

(oci805): alter session set nls_timestamp_format = ‘yyyy-mm-dd hh24:mi:ss’
(oci805): alter session set nls_timestamp_tz_format = ‘yyyy-mm-dd hh24:mi:ss’
(oci805): alter session set nls_time_format = ‘hh24:mi:ss’
(oci805): alter session set nls_time_tz_format = ‘hh24:mi:ss’
(oci805): alter session set nls_numeric_characters = ‘.,’
(oci805): SELECT count() from REI.MDSO_VM_VD_REC where EXERCICIO=2017AND COD_MUNICIPIO=3 AND COD_COMPETENCIA=402 and ( = 003.001 - PREFEITURA MUNICIPAL)
936: ORA-00936: missing expression
ADOConnection._Execute(SELECT count() from REI.MDSO_VM_VD_REC where EXERCICIO=2017AND COD_MUNICIPIO=3 AND COD_COMPETENCIA=402 and ( = 003.001 - PRE…, false) % line 787, file: adodb-oci8.inc.php
ADODB_oci8.Execute(SELECT count(*) from REI.MDSO_VM_VD_REC where EXERCICIO=2017AND COD_MUNICIPIO=3 AND COD_COMPETENCIA=402 and ( = 003.001 - PRE…) % line 830, file: MDSO_VD_RECEITAS_GRID_grid.class.php
MDSO_VD_RECEITAS_GRID_grid.inicializa() % line 138, file: MDSO_VD_RECEITAS_GRID_grid.class.php
MDSO_VD_RECEITAS_GRID_grid.monta_grid(0) % line 3619, file: index.php
MDSO_VD_RECEITAS_GRID_apl.controle() % line 4918, file: index.php

#2

Está acontecendo comigo também, tanto na conexão ACCESS-ODBC, quanto na conexão MYSQL-PDO.

#3

Depois que atualizei a versão.

#4

(pdo-mysql): SELECT count() from prodautonotif where = Art. 36 a 43
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘= Art. 36 a 43’ at line 1
ADOConnection._Execute(SELECT count() from prodautonotif where = Art. 36 a 43, false) % line 1095, file: adodb.inc.php
ADOConnection.Execute(SELECT count() from prodautonotif where = Art. 36 a 43) % line 726, file: grid_prodautonotif_grid.class.php
grid_prodautonotif_grid.inicializa() % line 109, file: grid_prodautonotif_grid.class.php
grid_prodautonotif_grid.monta_grid(0) % line 3810, file: index.php
grid_prodautonotif_apl.controle() % line 5210, file: index.php
Atenção
Erro ao acessar o banco de dados
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘= Art. 36 a 43’ at line 1
SELECT count() from prodautonotif where = Art. 36 a 43

Script: D:\SC9\v9\wwwroot\scriptcase\app\ServUrb\grid_prodautonotif\grid_prodautonotif_grid.class.php (729)

#5

Prezados,

O problema relatado nesse post, foi corrigido na release 9.0.022.

Versão liberada e disponivel para download e atualização.