Firebird views and SQLDB
lazarus / 16-Databases

----------------------------------------------------------------------
talorigomat · 2015-10-27 17:42

I have created a simple view in Firebird.  I have tried using the
following statement in a TSQLQuery

"Select * from my_view"

and I get the following message:   "Table Unknown my_view".

What is the correct statament to use to get data displayed from a
view?

----------------------------------------------------------------------
LacaK · 2015-10-27 17:55

It is correct statement 
So problem must be somewhere else.

----------------------------------------------------------------------
exdatis · 2015-10-27 18:22

Try to browse from view(my_view) with some usual tools(Flamerobin
etc.).Correct result?

p.c. Check connection and your settings(TSQLquery) and then run query

----------------------------------------------------------------------
talorigomat · 2015-10-29 07:54

Thanks for the help.  Realised the problem was I had set TIBConnection
component to the wrong version of the database