Hello Gents,
QET is fantastic app. I am so excited about this software. I created reports and it is nice how it refresh automatically... I am so happy to find QET!
for me it was easier to create SQLite query for nomenclature reports. But it is not very comfortable.
Maybe programmer can suggest me:
1. How to create querys or test them? Now if I copy my not correct query to nomenclature window it just returns nothing. Maybe there is possibility to have some error message or console from QET? Because trying to repair query is blind.
2. Second question is similar. I am trying to use different functions of SQLite. For example:
SUBSTR(folio , 1, INSTR(folio, '/')-1) finding and substacting String is working perfectly.
also
ORDER BY CAST(folio AS INTEGER) works fine.
But I think not all functions is working in QET
I could not make work this query:
SELECT ROW_NUMBER () OVER (ORDER BY folio) AS 'RowNumber', unity, label, folio FROM element_nomenclature_view WHERE (unity = 'optional');
Is it possible to know which functions are working?
Thank You very much.