Hi All,
I am trying to find the Source of a View, that it self is based on a Query.
I know I can go into .Script, but that does not really work for the client.
Found this https://wiki.openoffice.org/wiki/HSQLDB:Tips_and_Tricks and on the bottom: 'How to retrieve the definition of a view'.
That does not appear to work either any more or with a Split DataBase.
Running 2.6.0
Any suggestions?
Dream
[Solved] Lookup Source of a View, based on a Query
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
[Solved] Lookup Source of a View, based on a Query
Last edited by dreamquartz on Fri Jul 30, 2021 8:42 am, edited 1 time in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Re: Lookup Source of a View, based on a Query
This one works for me on 2.51
SELECT * FROM "INFORMATION_SCHEMA"."VIEWS"
SELECT * FROM "INFORMATION_SCHEMA"."VIEWS"
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: [SOLVED] Lookup Source of a View, based on a Query
That's exactly what I was looking for.
Thanks,
Dream
Thanks,
Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.