stewartp
asked on
Creating MS SQL Views from Delphi
I am using an SQL object in Delphi and supplying the following :-
SQL.add('CREATE VIEW TEST AS');
SQL.add('SELECT * FROM Type');
SQL.Prepare;
ExecSQL;
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.
Stewart Page
SQL.add('CREATE VIEW TEST AS');
SQL.add('SELECT * FROM Type');
SQL.Prepare;
ExecSQL;
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.
Stewart Page
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:) glad to help.
I also have this kind of problem before.
it spend me for a whole morning so old silly me help. haha
I also have this kind of problem before.
it spend me for a whole morning so old silly me help. haha
ASKER