Custom dataviews
I have a problem with a custom dataview I am working on. I am
opening a schools table twice. Once for home school and then once
for the opponents. The problem is that when I want to sort by the
opponent school, the report writer only looks at the field name to
generate the SQL and so it always gets the schools.school name field
to sort instead of the opponents.schoolname field. I was able to get
the sql.sqltext.text to have the correct field by not using your
getfieldforsqlfield name and by looping thru the fields myself.
However this still does not sort the file properly. I can take the
sql and run it in database explorer and get the correct results. Is
there a way around this?
opening a schools table twice. Once for home school and then once
for the opponents. The problem is that when I want to sort by the
opponent school, the report writer only looks at the field name to
generate the SQL and so it always gets the schools.school name field
to sort instead of the opponents.schoolname field. I was able to get
the sql.sqltext.text to have the correct field by not using your
getfieldforsqlfield name and by looping thru the fields myself.
However this still does not sort the file properly. I can take the
sql and run it in database explorer and get the correct results. Is
there a way around this?
This discussion has been closed.