I reported this on your behalf. It also gives an error in VFP5, "Insufficient stack space".

Thanks!

>Hi,
>
>On a SQL-SELECT if you use an object same name of the SELECT table field:
>- if property is not on fields list fire a not found error
>- if property is on fields list fire a C05 error and VFP collapse
>
>

>CREATE CURSOR TAB0 ( field1 C(10))
>CREATE CURSOR TAB1 ( field1 C(10) , field2 C(10) )
>INSERT INTO TAB0 VALUES ( 'TAB0_F1' )
>INSERT INTO TAB1 VALUES ( 'TAB1_F1' , 'TAB1_F2' )
>
>SELECT TAB1
>SCATTER NAME TAB0
>m.TAB0.field1 = 'OBJECT'
>
>* Error m.TAB0.field3 is not found on VFP6SP5,VFP7SP1,VFP8SP1
>SELECT m.TAB0.field2 field2,TAB0.field1  from TAB0 INTO CURSOR notfound
>
>* next command fire a C5 crash error on VFP6SP5,VFP7SP1,VFP8SP1
>* comment this for exec workaround
>SELECT m.TAB0.field1 field1bis,TAB0.field1  from TAB0 INTO CURSOR crash05
>
>* rename table alias on VFP8SP1 resolve the problem
>* this report a syntax error on VFP6SP5 and VFP7SP1
>SELECT m.TAB0.field1 field1bis,TABRENAME.field1 from TAB0 TABRENAME INTO CURSOR workaround
>BROWSE LAST
>

>
>Fabio