changing SQL text on query via RAP

rbuser

Hello All..


How i do to change an SQL sentence of a DataView in RAP Code before it's
open or doing Close, change, open. but the way, i need to change sql
sentence of a query via RAP (such as BeforeAutoSearchDialogCreate ).


thanks..

digitalmetaphors

There is an example of customizing the end user search criteria when using
DADE in the autosearch demos directory. The code is in Delphi code, but you
can adapt it to be used in RAP. You'll need to write RAP passthrough
functions in order to make some of the calls which are not available in RAP.
There are examples of creating RAP pass through functions in your RAP demos
directory in the installation.

If you want to change more than the autosearch criteria, then you'll have to
use this code to modify the objects defined on the dataview:
http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


Cheers,

Jim Bennett
Digital Metaphors