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

Whats mith more specific SQL?

edited February 2003 in DADE
Whats about a bit more specific SQL?

if i install Ado with MSSQL as an option, whay is it not possible to handle
some more features.

TOP 10 is under T-SQL:

SELECT TOP 10 * FROM Customer order by xy
also some other features would be cool.
If you need some info about MSSQL, i could give you a lot of infos.

Is it planed (in the near future) to enhance the language-model of
generating SQL?

chris

Comments

  • edited February 2003
    We have to support all the different databases that we support:) This means
    that there is a lowest common denominator in each of the SQL standards that
    we support for our SQL generation. Yes, we are aware that each database has
    their own functions, but we are not supporting them individually at this
    time. You will have to edit the SQL text in the dataview in order to use the
    database specific functions. Perhaps in the future we can extend our SQL
    generator to have more support for database specific functions. Thankyou for
    the suggestion!


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited February 2003
    yes, this would be a big feature!
    chris


This discussion has been closed.