Feedback:

Same Syntax for AOF and SQL-Where (LIKE, IN, ...)

It would be fine when the AOF (of a TADSTable) could have the same Syntax like the SQL-Where-Part of a TADSQuery.

67 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    TyroleanTyrolean shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...
      • Clemens Maier, Dontenwill AGClemens Maier, Dontenwill AG commented  ·   ·  Flag as inappropriate

        We would also need the counterpart: In our ERP-Application, users can define "read permissions" as AOF-Filters for every table in the dictionary.

        To be able to use the same filters in SQL based request, we would need a SQL function like "AOF(SQL_ALIAS, AOF_FILTER_STRING)"

      • synacksynack commented  ·   ·  Flag as inappropriate

        I say leave it alone - xBase is dead so there's no need to conform to it. Why are your users aware of syntax anyway? You can recreate the xBase syntax in your application but execute the SQL equivelant.

      • jeremym1234jeremym1234 commented  ·   ·  Flag as inappropriate

        I imagine we would use overloaded functions to retain the old prototypes, but provide a consistent set of new functions as well.

      • graphicequalisergraphicequaliser commented  ·   ·  Flag as inappropriate

        Surely, there is too much disparity between the xBase syntax and the SQL Anywhwere syntax for this to be possible! If such a feat were to be accomplished, I would very much resent seeing any changes to the xBase syntax all my users are accustomed to. How would such a change be achieved without changes to either syntax?

      Knowledge Base and Helpdesk