Hi Bruno,
>I'm using VFP9 SP1 (I didn't apply SP2 because of new bugs).
SP 2 also contains a huge number of bug fixes, some of them serious ones. The most important bugs introduced in SP2 have already been fixed in the hot fix:
http://code.msdn.microsoft.com/KB968409/Release/ProjectReleases.aspx?ReleaseId=2445>I'm facing a problem which can be simplified in the following code.
It's also in VFP 9 without the service pack. Before changing the code, I'd rather check if the service pack and the hot fixes work for you. Otherwise, your options are to avoid SET ANSI OFF, rewrite the DELETE statement, or use a different collate sequence.
>At first, does the command apply only in string comparisons in SQL Selects (or other string comparisons)?
Yes, it applies to SQL statements only. Other string operations are governed by SET EXACT.
--
Christof