Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aida
Starting Member
5 Posts |
 Posted - 2006-09-18 : 22:33:56
|
 I was unable to read from view in SQL.Is there any specific command to read?I just use this command : View's Name: mfvcengrpmem Query Statement: "Select * from mfvcengrpmem" The problem is, program does not recognize the view.Pleas help. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-18 : 23:00:35
|
what is the error message ?Does the user has access to the view ?
KH |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-18 : 23:01:25
|
| The syntax is right.Try opening up Query Analyser / Enterprise Manager and see if it's listed there. |
|
|
|
aida
Starting Member
5 Posts |
Posted - 2006-09-18 : 23:21:36
|
| Error msg : Invalid object name 'MFVCENGRPMEM'.The view is there (in the database) but still cannot recognized. |
|
|
|
aida
Starting Member
5 Posts |
Posted - 2006-09-18 : 23:48:45
|
Sorry everybody...Actually my fault  I point to other database, that's why the view is not been recognized/ invalid.Sorry again. Thanks for your help.quote:
Originally posted by aida
Error msg : Invalid object name 'MFVCENGRPMEM'.The view is there (in the database) but still cannot recognized.
|
|
|
|
|
|
|
Unable to read from SQL View