Hai Gurus,
I have one basic Question.If execute the below query in BaanIV
How many fields does it fetch exactly whether field1 only or all the fields?

Select table1.field1
from table1
select do
.........
end select

Thanks in advance
James

The select you mention will only return field1 from table1.


Mark

If you are using level 1 Database, with this query you can only read table1.field1 but query parsed to database is select *