Recent

Author Topic: Firebird views and SQLDB  (Read 1464 times)

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Firebird views and SQLDB
« 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?
Lazarus 1.8.0Rc4, Windows 10

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: Firebird views and SQLDB
« Reply #1 on: October 27, 2015, 06:55:23 pm »
It is correct statement  :)
So problem must be somewhere else.

exdatis

  • Hero Member
  • *****
  • Posts: 668
    • exdatis
Re: Firebird views and SQLDB
« Reply #2 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

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Firebird views and SQLDB
« Reply #3 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  :)
Lazarus 1.8.0Rc4, Windows 10