Created attachment 188549 [details] Shows 0-result of autovalue when table is queries with alias. Open the attached screenshot. There is a table with AutoValue. Query with SELECT * FROM "tbl_Test" will work as expected. AutoValue will be shown in query. Now there is an alias for the table: SELECT * FROM "tbl_Test" AS "a" AutoValue won't be refreshed any more. Wrong entry '0' is shown instead. I'm using this kind of query for correlating queries, which works well with internal HSQLDB. With FIREBIRD the correlation works, but the connected value of the AutoValue field for the subform is '0' instead of a real value of the table.
Thanks for the report, Robert. Can you please provide example files, and test again in LO 7.6? Thank you!
I can confirm the erroneous behavior ----------------------- Version: 7.6.0.1 (X86_64) / LibreOffice Community Build ID: 776eaf34564cbf3f034a0ba1fd1d5c32ff9ccf1c CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded ----------------------- Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 34387332173782498acd4998c7c665d04ebc3c7d CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Created attachment 188873 [details] Open the query in the database file and add a new "Name" - ID will be '0'
Following comment 2 I will set this one to NEW
Thank you both! Also reproduced on Linux with a recent master build, as well as: Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; Locale: en-AU (en_AU.UTF-8); Calc: group threaded