RE: Grid Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bankim Desai (BankimDesai_at_discussions.microsoft.com)
Date: 12/09/04 

Date: Thu, 9 Dec 2004 06:25:06 -0800

Hi Stefen

I have created the query with CREATE SQL VIEW. I have got following problems.

I can not understand what is parameterized View.
How to use the created query. & where it saves.
Secondly how to pass the parameters in the query.

One major problem noted by me is. I have many records with some identical
field values in the file. When i change the field value of some fields which
are not key field then also i get the error message as 'uniquness error' and
all the filed value with same key record changes which is not i wanted to do.

How can i get the resulted output of create sql view in the grid data.

"Bankim Desai" wrote:

> I want to design a grid based on the specific condition. memory variable has
> to be used for conditional critieria. No Set filter command has to be used as
> it is very slow. I can seek the record. But records meeting the criteria
> should come in the grid data. Secondly I sould like to edit the data if
> required on clicking on the grid record.
> What is the correct procedures.
>
> 1.IF grid source is cursor I can not edit the main file record as only some
> fields are only displayed.
> 2.I grid source is temporary table creating the same & using the same as
> grid source does not allow me to edit the main file data.
>
> Is there any way where by I can use the mainfile record as the record source
> for the grid & can check the memory variable criteria . & EDITING OF DATA
> ALSO BECOMES POSSIBLE.

Relevant Pages

  • Re: VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView
    ... > Thanks for that Bart, ... > the values from my Grid to the TableAdapters Insert method. ... >> choose add query, then choose insert query, use a query like below, ... >>> stored in the SQL Database but a VB generated (or disconected dataset ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to requery grid based on query
    ... you will get the REQUERY() orportunity if you use a view instead of a query. ... CREATE SQL VIEW Command ... Form runs, grid> displays data. ... a grid does not have a requery> method. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: How to requery grid based on query
    ... allowing you to create a SQL view. ... combining the flexibility of a query with the ability to update ... a grid does not have a requery ...
    (microsoft.public.fox.programmer.exchange)
  • Re: What GROUP BY is not...
    ... And if you were running it against SQL Server, ... the same amount of time for both, according to Michel (and the query ... DISTINCT is for eliminating duplicates. ... skilled users learning how to use Group By on the QBE grid will be far more ...
    (microsoft.public.access.queries)
  • ADO /ACCESS problem
    ... I have an issue where is have an Access 2K table db connected to a grid ... using ADO. ... The current query returns about 200 records. ... Once this happens, the grid data is ...
    (borland.public.delphi.database.ado)