Information générale
Catégorie:
Codage, syntaxe et commandes
My alternate solution before anyone else responded was to resort to the use of IIF(). IIF( x > y, y, x ) as MyVal.
I just thought it was strange and was I missing something but completely went blank that SQL had its own version of the min/max commands.
>>I am having a problem with a simple select statement and don't know if it is a bug... To verify the simplicity of it, I created a bogus table with two numeric columns N1, N2 both integer.
>>
>>Then I issued
>>
>>select min( N1, N2 ) as tmpfld from tmptable.
>>
>>The error I received was
>>"Function name is missing ),"
>>
>>anyone seen this???
>
>The problem is that the MAX and MIN VFP functions conflict with the SQL ones... I think there is no solution (other than writing an UDF which does the same job) and would like to here about one, if available.
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