Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in views can't be convert in sqlserver with upsi
Message
 
 
To
29/07/2007 13:58:30
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01244448
Message ID:
01244452
Views:
13
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform