Information générale
Catégorie:
Gestionnaire d'écran & Écrans
You're going to have other problems besides slowness. You really shouldn't use data manipulation functions like TRIM() on the output fields of a SELECT statement. VFP will size the resulting column based on the first column encountered -- if your TRIM() results in a width of zero, well that's what you get.
Use views to create result sets. Do your data manipulation on the result sets -- not in the view definition.
>I've got a view that looks like this: create sql view "lvclientcharges" as select trim(clast)+', '+trim(cfirst),csac_id,chosp_id,dbirth,dcontact,nclient_id from clients where nclient_id in (select nclient_id from charge_visits) order by clast,cfirst
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement