To activate it programatically:ĭocmd.OpenQuery 'qryYourPassthroughQryName'

Replace the above SQL String with any legitimate serverside SQL My oracle is not too good, so I wont hazard a real example.Īfter the above code executes, the SQL in the saved query will have been set according to the code.

Once you are happy that it works, then you can programatically change the SQL string without effecting the other properties. Save your passthrough Query, then test it, to make sure it works. Set ODBCTimeOut to zero to prevent a timeout problem. If its a standard select, then ReturnRecords will be Yes.

insert, update, delete), then ReturnRecords will be No. In the query properties, set the ODBC Connection String, ReturnRecords, and ODBCTimeout properties. Then type in the Oracle SQL which will perform the action required. To do this, go to your Query design window, create a new query, and select the Query, SQL Specific, Passthrough options. To do this, create an associated passthrough Query definition and save it. This allows all of the database processing to occur on the Oracle server, and prevents the otherwise potentially heavy associated network traffic.

It depends on what you are doing, but if its possible, I suggest that you use a passthrough query to manipulate your data on Oracle.

Change odbc timeout