Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a way to speed this SELECT up?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00446204
Message ID:
00446213
Vues:
9
>Here is the correct SELECT code. I mistakenly put the wrong code in the first message. Oooooops!
>
>
>SELECT master.incident, master.patnum, master.patqty, master.name_last, master.name_first, ;
>	master.sitename, master.addr1a, master.citya, ;
>	master.mcoid, arrest.sca_ctr, master.date, arrest.closed ;
>	FROM master, arrest ORDER BY master.date INTO ARRAY slister
>
>
>Sorry about that.

Probably because you got a nice little Cartesian product going on there ;)
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform