Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Ansi On
Message
 
 
À
13/07/2009 12:13:32
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01411969
Message ID:
01411978
Vues:
67
I don't get any errors with your test under VFP9SP1.

>I'm using VFP9 SP1 (I didn't apply SP2 because of new bugs).
>
>I'm facing a problem which can be simplified in the following code.
>
>Set Ansi Off	&&default
>
>Create Cursor Curs1 (MyField1 C(10))
>Insert Into Curs1 (MyField1 ) Values ("")
>Insert Into Curs1 (MyField1 ) Values ("aa")
>
>Create Cursor Curs2 (MyField1 C(10))
>Insert Into Curs2 (MyField1 ) Values ("bb")
>
>Delete From Curs1 Where MyField1 In (Select MyField1 From Curs2 Where MyField1 = "cc")
>
>*Error message record is out of range
>
>
>I realized that the problem is only present with SP1 (not SP2 or VFP8 and previous versions).
>The problem doesn't appear if I set
>Set Ansi On
>
>
>I'm now wondering to simply insert:
>Set Ansi On
>in the current datasession.
>But I don't know the real impact in the whole application, so I need some advice.
>At first, does the command apply only in string comparisons in SQL Selects (or other string comparisons)?
>Other aspects to consider?
>
>
>
>TIA
>Bruno Maddalozzo
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform