Lazarus

Programming => Databases => Topic started by: talorigomat on October 27, 2015, 06:42:09 pm

Title: Firebird views and SQLDB
Post by: talorigomat on October 27, 2015, 06:42:09 pm

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?

Title: Re: Firebird views and SQLDB
Post by: LacaK on October 27, 2015, 06:55:23 pm

It is correct statement  :)
So problem must be somewhere else.

Title: Re: Firebird views and SQLDB
Post by: exdatis on October 27, 2015, 07:22:47 pm

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

Title: Re: Firebird views and SQLDB
Post by: talorigomat on October 29, 2015, 08:54:21 am

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