>Hi!
>in vfp7 I used to issue a select statement
>on a dataenvironment cursor caling it by it's alias
>something like select vtable.field1, sum(vtable.field2) as ssum from vtable ;
> group by field1 into cursor c1 nocon
>
>when porting the form to vfp8 the same select returns an empty cursor!!
>
>q1. what causes this behaviour
>q2. Can I issue a select on the dataenvironment cursor's actual data.
>
>Thanks in advance,
>
>Nir.

a1. try SET ENGINEBEHAVIOR 70 in the start of your program

a2. i don't understand exactly what you mean. Normally, if the cursor is not in the DE, you can't run a SELECT unless you manually USE it. Also, you can use a cursor ( even from another SELECT ) in a new SELECT statement, as long as you don't close the cursor.

HTH
Jaime