troubleshooting Question

multitable views in vfp 9

Avatar of gaby12
gaby12Flag for Romania asked on
FoxProMicrosoft Applications
11 Comments2 Solutions588 ViewsLast Modified:
Hello experts,
I need your help.
I created a multitable view. All seemed OK until I wanted to use the SKIP command with a VCR command buttons. When using the skip command the order in which the records are displayed is corresponding to index of the last table in join, not from the main table.
The view has the order to the main table.
This is the code:
Create SWL view Hotarari_judecatoresti_view as;
SELECT Hotarari_judecatoresti.id_hotarare,;
  Hotarari_judecatoresti.id_fel_hot, Hotarari_judecatoresti.id_rg,;
  Hotarari_judecatoresti.data_rg, Hotarari_judecatoresti.id_inst,;
  Lista_instante.den_inst, Hotarari_judecatoresti.nr_dosar,;
  Hotarari_judecatoresti.data_dosar, Hotarari_judecatoresti.id_obiect,;
  Lista_obiecte_actiuni.den_obiect, Hotarari_judecatoresti.id_stad_pr,;
  Lista_stadii_proces.den_stadiu, Hotarari_judecatoresti.term_judec,;
  Hotarari_judecatoresti.nr_anrp, Hotarari_judecatoresti.reclamant,;
  Hotarari_judecatoresti.id_parat, Lista_parati.den_parat,;
  Hotarari_judecatoresti.id_solutia, Hotarari_judecatoresti.descr_sol,;
  Hotarari_judecatoresti.id_dir, Hotarari_judecatoresti.id_cons,;
  Hotarari_judecatoresti.observatii, Lista_instante.id_inst,;
  Lista_obiecte_actiuni.id_obiect, Lista_parati.id_parat,;
  Lista_stadii_proces.id_stadiu;
 FROM ;
     INDEX_RG!HOTARARI_JUDECATORESTI ;
    LEFT OUTER JOIN index_rg!lista_instante ;
   ON  Hotarari_judecatoresti.id_inst = Lista_instante.id_inst ;
    LEFT OUTER JOIN index_rg!lista_obiecte_actiuni ;
   ON  Hotarari_judecatoresti.id_obiect = Lista_obiecte_actiuni.id_obiect ;
    LEFT OUTER JOIN index_rg!lista_stadii_proces ;
   ON  Hotarari_judecatoresti.id_stad_pr = Lista_stadii_proces.id_stadiu ;
    LEFT OUTER JOIN index_rg!lista_parati ;
   ON  Hotarari_judecatoresti.id_parat = Lista_parati.id_parat;
 ORDER BY Hotarari_judecatoresti.id_hotarare
  ...

How can I control the order in which the records are displayed ?
Thank you
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros