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
Solved

I need to create a view in access with parameter

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
delphi prevent click fast 2 238
oracle global variables 4 76
Tembedded WB animatid gifs not animated on some pcs 2 84
Drag & Drop... Data from one grid to another 2 41
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

856 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