Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Ansi On
Message
 
 
To
13/07/2009 12:13:32
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01411969
Message ID:
01411978
Views:
65
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform