 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / New Users / February 2007calling a function/query
hi, I have some queries that are grouped as "functions" in Database Explorer in VS 2005. I would like to set up a tableadapter with one of these, but each time I try, I get errors. It doesn't seem to recognize the function. Can you advise? Thank you!! Hello Leotiger, Is the database here also the access mdb database file you mentioned in another thread " how to refer to a query that calls a function" ? Also, as I've asked in your another thread. Is the functions you mentioned those VBA functions defined in your access database? Also, for those "functions" displayed in the vs 2005 server explorer, they're SQL Server specfiic functions and access database do not support such functions(it is empty by default and you can not add new ones it it in server explorer). Sincerely, Steven Cheng Microsoft MSDN Online Support Lead This posting is provided "AS IS" with no warranties, and confers no rights. HI, Yes, it's the same one. Yes, the functions I am referring to are ones I create and use in Access. The functions I see in (database explorer ) are also queries I use in Access. But when I try to open them , they are empty. I wonder why it bothered to copy them over if they're empty. I remain very confused about this whole thing. Thanks much. > Hello Leotiger, > [quoted text clipped - 14 lines] > > This posting is provided "AS IS" with no warranties, and confers no rights. Thanks for your reply Leotiger, I'll continue to followup in your another thread "how to refer to a query that calls a function". And we can discuss the issue further there. Sincerely, Steven Cheng Microsoft MSDN Online Support Lead This posting is provided "AS IS" with no warranties, and confers no rights. Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.