Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does Order By work with a memo field?
Message
De
14/11/2002 14:27:43
 
 
À
14/11/2002 14:18:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00722873
Message ID:
00722880
Vues:
11
Steve,

You can grab a portion of the memo field, using the left() function, see example below:

>I have a select statement that is failing whenever my 'order by' is a memo field. It returns the error "SQL: ORDER BY clause is invalid."
>
>Following is the code that is failing:
>
>select *, left(fdesc,10) as shortDescription ;
>From (cAlias);
>ORDER BY shortDescription;	
>into cursor (lcResultTable) readwrite
>
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform