Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

I need to create a view in access with parameter

Posted on 2006-11-22
4
Medium Priority
?
174 Views
Last Modified: 2010-04-05
Hello guys,

I need to create a view in access with parameters, I am trying to do this with Tadoquery but I am having an error that informs that parameter in view is not
possible. In access I have view with parameters, so it is perfectly possible.

How to do that?
0
Comment
Question by:hidrau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:mikelittlewood
ID: 17996483
I didn't think that this was possible.
As far as I always knew, views don't expect parameters.
0
 
LVL 1

Author Comment

by:hidrau
ID: 17996493
But I have a view with parameter in access and when I call it in my tadoquery, I open the parameters and it is there
0
 
LVL 15

Accepted Solution

by:
mikelittlewood earned 2000 total points
ID: 17997146
I think my problem is why you would want to have a view with parameters anyway.
Its not quicker than using a standard query to the database as the view wouldnt be prepared with undefined SQL anyway.
Wouldnt you be better off just doing a query to the originating tables, or creating a view without the parameter then query the view using a standard query?
0
 
LVL 1

Author Comment

by:hidrau
ID: 17997278
Ok, no problem now

I solved the things for another way without parameters.

to drop a view this line is correct:

drop table table1

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

609 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