Re: Index Suggestion Please
From: L.Peter (peter_at_nospam.local)
Date: 04/08/04
- Next message: Willianto: "Re: Adding comments to a block of code"
- Previous message: Thierry Nivelet: "Re: time question"
- In reply to: Marc Lyon: "Re: Index Suggestion Please"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Apr 2004 15:31:24 +0800
Thanks Marc for your suggestion, That's exactly what I did
Best Regards
Peter
"Marc Lyon" <whocares@apathy.org> wrote in message
news:ebCfrU9GEHA.3472@TK2MSFTNGP11.phx.gbl...
> L.Peter,
>
> Be careful. If you use that table with that index without the supplier
> table, you will get an error. The error will say that the supplier table
is
> not found.
>
> If you are stuck within someone elses code, and cannot use a view for the
> screen (not that hard to do even in someone elses code), try creating a
> temporary index file, then deleting it.
>
> lcTempIndex = SYS(3)
> INDEX ON Supplier_name TO (lcTempIndex)
>
> When you are done
>
> SET INDEX TO
> ERASE (lcTempIndex)
>
> HTH,
>
> Marc
>
> "L.Peter" <peter@nospam.local> wrote in message
> news:%23ML12G5GEHA.740@tk2msftngp13.phx.gbl...
> > oh, I just discover that i can 'index on supp.supp_name to myindex' and
it
> > works
> >
> > Thank you and Best Regards
> >
> > Peter
> >
> > "Rush Strong" <rush.strong]@[verizon.net> wrote in message
> > news:%234dcI14GEHA.2224@TK2MSFTNGP12.phx.gbl...
> > > Not that I see. Setting a relation requires setting an order in the
> child
> > > table, and that's the order you're stuck with. Invest the time in
> views,
> > > you'll be paid back soon enough!
> > >
> > > - Rush
> > >
> > > "L.Peter" <peter@nospam.local> wrote in message
> > > news:%23JNC8v4GEHA.704@tk2msftngp13.phx.gbl...
> > > > Dear Rush,
> > > > Using View is a very good idea, but is there any other quicker
tweak?
> > > >
> > > > Thank you and Best Regards
> > > >
> > > > Peter
> > > > "Rush Strong" <rush.strong]@[verizon.net> wrote in message
> > > > news:OsoN5R4GEHA.4008@TK2MSFTNGP10.phx.gbl...
> > > > > Use a[n] [up]dateable view instead of relations.
> > > > >
> > > > > - Rush
> > > > >
> > > > > "L.Peter" <peter@nospam.local> wrote in message
> > > > > news:OsgSkI4GEHA.3168@TK2MSFTNGP12.phx.gbl...
> > > > > > Dear Group,
> > > > > > I have two tables
> > > > > > Invoice Header : inv_id, Supp_id ....
> > > > > > Supplier : supp_id, Supp_Name
> > > > > >
> > > > > > on a form, I have a grid showing Inv_id and Supp_name from
> Supplier
> > > (one
> > > > > to
> > > > > > many relation). Showing data to User is OK but How can I sort by
> > > > Supp_Name
> > > > > > on this Form?
> > > > > >
> > > > > > TIA
> > > > > >
> > > > > > Peter
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > Outgoing mail is certified Virus Free.
> > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > Version: 6.0.651 / Virus Database: 417 - Release Date: 4/5/2004
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.651 / Virus Database: 417 - Release Date: 4/5/2004
> > > >
> > > >
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.651 / Virus Database: 417 - Release Date: 4/5/2004
> >
> >
>
>
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.654 / Virus Database: 419 - Release Date: 4/6/2004
- Next message: Willianto: "Re: Adding comments to a block of code"
- Previous message: Thierry Nivelet: "Re: time question"
- In reply to: Marc Lyon: "Re: Index Suggestion Please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
