[SOLVED] SubSelect don't work in ReportPDF

[aquiles]

When I define the SUBSELECT field (connection, Subquery, etc) save and receive this ERROR message:

Fatal error: Uncaught com_exception: Source: Provider Description: Type mismatch. in C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib hird
m_odbc_access\adodb.php:21 Stack trace: #0 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib hird
m_odbc_access\adodb.php(21): com->Open(‘DSN=’, NULL, NULL) #1 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib hird
m_odbc_access\adodb.php(10): AccessInformation->setBanco(NULL, NULL, NULL) #2 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php(7683): AccessInformation->__construct(NULL, NULL, NULL) #3 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php(4634): nm_odbc_access(NULL, NULL, NULL, ‘get_tables’) #4 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php(3583): nm_db_tables_access(NULL, Array, Array, ‘’) #5 C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\compat
m_select.class.php(442): nm_db_tables(’’, ‘C:\Program File…’, 442, true, true, Object(ADODB_access), ‘access’ in C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib hird
m_odbc_access\adodb.php on line 21

AND in the dialog window error Sc create one error file with this message:
Undefined variable: arr_conn | Script: C:\Program Files\NetMake\v9\wwwroot\scriptcase\devel\lib\php\database.inc.php linha: 3583

Environment:
Version SC9 9.0.024
Connection MsAccess ODBC
Windows 10

please fix this bugs
Thanks
Aquiles

[yuri_esteves]

Hello. This problem will be corrected in the next versions. Thanks for reporting

[yuri_esteves]

The reported case was corrected in release 9.0.027. Version available for download and update…

[mirko.rogora]

Hello. This problem is not solved. I downloaded version 27 and republished my application in full, replacing everything. But reports with sub sel continue to fail.
They only work in the development environment. Once published on the server, it does not work

[yuri_esteves]

@mirko.rogora

Hello. This problem is not solved. I downloaded version 27 and republished my application in full, replacing everything. But reports with sub sel continue to fail.
They only work in the development environment. Once published on the server, it does not work

Could you report the problem?

Fixed for this issue

AND in the dialog window error Sc create one error file with this message:
Undefined variable: arr_conn | Script: C: \ Program Files \ NetMake \ v9 \ wwwroot \ scriptcase \ devel \ lib \ php \ database.inc.php line: 3583

Environment:
Version SC9 9.0.024
ODBC Connection MsAccess
Windows 10

[mirko.rogora]

the problem is that the reports in pdf are not opened. The search mask appears, but then the report is not generated. In the development environment it works correctly. Once transferred to server no. But this only happens in reports that have a sub select. In reports without sub sel works correctly. Yesterday I download the latest version 9.0.027, but I always have the same problem. I am connected to a mysql database with Mac OS High Sierra 10.13.1

[mirko.rogora]

Any news about this bug…?

[yuri_esteves]

@mirko.rogora

the problem is that the reports in pdf are not opened. The search mask appears, but then the report is not generated. In the development environment it works correctly. Once transferred to server no. But this only happens in reports that have a sub select. In reports without sub sel works correctly. Yesterday I download the latest version 9.0.027, but I always have the same problem. I am connected to a mysql database with Mac OS High Sierra 10.13.1

The reported case was corrected in release 9.0.032. Version available for download and update.

• Fixed issue generating a Subselect field in pdf report application in php 7.1 environments

http://www.scriptcase.net/changelog/