|
| Inicio → WINDEV 2024 → WD23 Bug in queries using analysis table name instead of SQL name |
| WD23 Bug in queries using analysis table name instead of SQL name |
| Iniciado por guest, 18,jul. 2018 17:04 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 18,julio 2018 - 17:04 |
Did anyone experience a WinDev 23 bug where in the query in specific situations the analysis table name is used instead of the SQL table name.
In analysis the SQL table name is set, and is different then the table name in analysis.
The specific situation is where there is a condition where the field is in a list of a sub query.
The field name is typed as analysis_table_name.id where in all other situations it typed correctly as sql_table_name.id
We converted a huge application from WD22 to WD23. In 22 all was fine. in 23 on all positions where we have this specific condition it's wrong.
Best regards,
Adri |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2018 - 12:42 |
If I understand good, the same problem hapened to me.
Please let me explain:
In a master query a sub-query is called with ANY type of values. When the sub-query has nothing to return, the master query simply HOLDS!!!
This problem hapens only with HFSQL V23 (the queries runs perfectly from V15 to V22).
This is the reason that I did not make the upgrade to V23 yet.
I think is time to make it known to pcsoft tech. support.
Best Regards
Vassilis Boutsikas
P.S.
If anyone has some accurate solution for this, is welcome. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2018 - 13:21 |
Not sure if this is the same problem. Our problem causes a crash because sql server doesn't know the analysis table name.
In the meantime time we already created an example app that contains the bug and send it to PCSoft.
Best regards,
Adri |
| |
| |
| | | |
|
| | | | |
| | |
|