?
Solved

I need to create a view in access with parameter

Posted on 2006-11-22
4
Medium Priority
?
176 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
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
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…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

612 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