Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

changing SQL text on query via RAP

edited January 2003 in RAP
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..

Comments

  • edited January 2003
    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


This discussion has been closed.