Solved

I need to create a view in access with parameter

Posted on 2006-11-22
4
164 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now