Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALLTRIM in views can't be convert in sqlserver with upsi
Message
 
 
À
29/07/2007 13:58:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01244448
Message ID:
01244452
Vues:
14
You should review all your views that use ALLTRIM() to make sure that ALLTRIM() s necessary there. In WHERE clause ALLTRIM() in most cases can be replaced with '==' operator. You can post View SQL where you think ALLTRIM() is neccessary.
Even if view has been upsized, it doesn't mean it'll work correctly in SQL Server unless you're using SET ANSI ON. See http://www.berezniker.com/display/VFP/String+comparison+in+VFP for more info.

>i tried to upsize my app to sql server. at the end many views have not been converted with the upsize wizard due to the alltrim command.
>what can i do ?
>is there another upsize utility that can help ?
>is is possible to edit the wizard procedure and re-code it ?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform