when I do "select field1, field2, field3 from table1" no erros but I can access only Query.FieldByName('field1') or Query.Fields[0], other names gives "no field with name", all others indexes return "List index out of bounds". For this only field query gives the valid data.
This happens with one database, query to another database on the same server return field set as expected.
Any ideas how to understand what's wrong?
UPD
table without bytea
select field1, field2, field3 from table1 gives 3 fields
select * from table1 gives 3 fields
table WITH bytea
select field1, field2, field3 from table2 gives 1 field
select * from table2 gives 20 fields (table2 has 27 fields)
select table2.field1, table2.field2, table3.field3 from table2 join table3 gives 1 field
select table2.*, table3.field3 from table2 join table3 gives 20 fields
select table3.field3, table2.* from table2 join table3 gives 21 fields
select table3.field3, table3.field4, table2.* from table2 join table3 anyway gives 21 fields
have created a view with select table3.field3, table3.field4, table2.* from table2 join table3
select * from view1 - 21 fields
select field3, field4, field1 from view1 - 1 field
That's very fun!
