DADE SQL generation
Hi,
When selecting a table or fields in the query designer, in the background
the corresponding SQL statement is generated.
I would like to have control over the generated sql statement.
so what I basically want to do is change the SQL statement myself when the
'ok' button is pressed in the query designer.
Where do I find these procedures? What do I need to override.
I ask this, because I'm busy creating a DADE plugin to work with Remobjects
Data Abstract. Here I have definitions of DATables which are not really the
same as the underlying database table names.
For now, I can already access them and preview/print/load/save the report,
as long as I don't change any tablename or fieldname.
Regards,
Wouter Devos
When selecting a table or fields in the query designer, in the background
the corresponding SQL statement is generated.
I would like to have control over the generated sql statement.
so what I basically want to do is change the SQL statement myself when the
'ok' button is pressed in the query designer.
Where do I find these procedures? What do I need to override.
I ask this, because I'm busy creating a DADE plugin to work with Remobjects
Data Abstract. Here I have definitions of DATables which are not really the
same as the underlying database table names.
For now, I can already access them and preview/print/load/save the report,
as long as I don't change any tablename or fieldname.
Regards,
Wouter Devos
This discussion has been closed.
Comments
The QueryDataView.SQLChanged method is the place where the generated SQL
text is assigned to the TDataSet descendant. For an example see daADO.pas,
the TADOQueryDataView.SQLChanged method.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com