Is it possible to implement with ODAC my own data transport level (like Direct mode in ODAC)?
For example, handle SQL from TOraSession, send it to my own ISAPI that runs this SQL and returns data in XML, and this XML loaded to the TOraDataSet…
Is it possible anyway?
Thanks.
Is it possible to implement with ODAC my own data transport level (like Direct mode in ODAC)?
You can not implement such data transport level that is transparent for code using ODAC.
But you can work in the following way:
1. Send a SQL to your server.
2. Server opens a TOraQuery component with SQL and saves result to XML. You can use SaveToXML method of TOraQuery.
3. Server sends XML to the client, and client opens this XML in TVirtualTable component using LoadFromStream or LoadFromFile methods of TVirtualTable.
But you can work in the following way:
1. Send a SQL to your server.
2. Server opens a TOraQuery component with SQL and saves result to XML. You can use SaveToXML method of TOraQuery.
3. Server sends XML to the client, and client opens this XML in TVirtualTable component using LoadFromStream or LoadFromFile methods of TVirtualTable.