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.
5 comments
-
Clemens Maier, Dontenwill AG
commented
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)"
-
synack
commented
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.
-
jeremym1234
commented
I imagine we would use overloaded functions to retain the old prototypes, but provide a consistent set of new functions as well.
-
graphicequaliser
commented
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?
-
LePrince
commented
I'd really appreciate this!