?
Solved

Creating MS SQL Views from Delphi

Posted on 2000-01-25
3
Medium Priority
?
236 Views
Last Modified: 2010-04-04
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
0
Comment
Question by:stewartp
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
yk030299 earned 300 total points
ID: 2391547
How about specify the VIEW name
as SQLLoginName.ViewName
before access the VIEW!
0
 

Author Comment

by:stewartp
ID: 2392505
Thanks, Silly me!!!
0
 
LVL 1

Expert Comment

by:yk030299
ID: 2395154
:) glad to help.
I also have this kind of problem before.
it spend me for a whole morning so old silly me help.  haha
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question