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