Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GROUP BY 1 no longer works
Message
De
06/02/2003 23:52:38
 
 
À
06/02/2003 23:49:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00750415
Message ID:
00750434
Vues:
14
Hi Mike,

The problem was that our SQL was, in some situations, not compliant with the rest of the world. So the default behavior is now to be compliant with other SQL standards. The SYS function is an acknowledgement that people will need to be backward-compatible for existing apps.

>>Have you tried putting SYS(3099, 70) in the code?
>
>With that in place it works. But, this forces me to be backward compliant. If MS decided to adapt its SQL engine to a new standard then I really want to know what I should adapt on it to make it standard to the native SQL support of the product. I don't want to start added backward compliant command where it occurs. I want to resolve it once and for all. :)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform