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

Edited SQl definition in daSQL

edited October 2003 in DADE
When user put some SQL definition directly, then no Search form is possible.
OK...Is there any way to cheat RB (what is different in database between
that way of SQL and SQL wizard definition) to simulate Wizard way?

THX and sorry if that post is repeted...
Benjamin

The difference between theory and practice is that in theory there is no
difference between theory and practice, but in practice there is....

Comments

  • edited October 2003

    Yes, once you edit the SQL as text, the AutoSearch and Linking features are
    no longer available.

    You can call the TdaSQL methods to add select fields, search criteria, order
    by fields, etc. Then the SQL exists a collection of objects and the SQL text
    can be generated by TdaSQL upon demand. Below is an example that you can
    download. You can also consult the TdaSQL source code (see daSQL.pas).

    http://www.digital-metaphors.com/tips/ExtractSQLObject.zip



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.