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
>
>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--