[Solved] Lookup Source of a View, based on a Query

Discuss the database features
Post Reply
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

[Solved] Lookup Source of a View, based on a Query

Post by dreamquartz »

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
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.
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Lookup Source of a View, based on a Query

Post by gkick »

This one works for me on 2.51

SELECT * FROM "INFORMATION_SCHEMA"."VIEWS"
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

Re: [SOLVED] Lookup Source of a View, based on a Query

Post by dreamquartz »

That's exactly what I was looking for.

Thanks,

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Post Reply