RE: Grid Query
From: Bankim Desai (BankimDesai_at_discussions.microsoft.com)
Date: 12/10/04
- Next message: Lee Mitchell: "RE: Missing indexes in DBC."
- Previous message: Bankim Desai: "Re: Grid Query"
- In reply to: Lee Mitchell: "RE: Grid Query"
- Next in thread: Bankim Desai: "RE: Grid Query"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 07:07:05 -0800
"Lee Mitchell" wrote:
> Hi Bankim Desai:
>
> Look at these articles for more information on parameterized views:
>
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;130707
>
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;132947
>
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;137124
>
> A view is saved in a database container. You use a view just like you use
> a table, USE View_name.
>
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 Public Beta Now Available!! --*
> Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>
> >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.
>
>
- Next message: Lee Mitchell: "RE: Missing indexes in DBC."
- Previous message: Bankim Desai: "Re: Grid Query"
- In reply to: Lee Mitchell: "RE: Grid Query"
- Next in thread: Bankim Desai: "RE: Grid Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
