I am using an SQL object in Delphi and supplying the following :-
SQL.add('CREATE VIEW TEST AS');
SQL.add('SELECT * FROM Type');
The view appears in MSSQL, but when I try to access it, SQL complains that
'The object 'TEST' does not exist in database 'Titan'.'
If I go into the view and Run it, all then works well.
Can anybody point out the problem please.