Hello,
I have been trying unsuccessfully to use parameters for modifying the sort order in a SQL statement with B4A. as in the ParameterQueryExample sub in the attached code sample.
Reversing the sSortParameters makes no difference to the results.
The code in the WorkingQueryExample sub DOES work, so my basic syntax is correct (the actual query is far more comlex, I have simplified it here to make it clear) but I would prefer to use parameters for the sort order:
Can I do this using sort order parameters? I have tried all the variations I can think of …
I have been trying unsuccessfully to use parameters for modifying the sort order in a SQL statement with B4A. as in the ParameterQueryExample sub in the attached code sample.
Reversing the sSortParameters makes no difference to the results.
The code in the WorkingQueryExample sub DOES work, so my basic syntax is correct (the actual query is far more comlex, I have simplified it here to make it clear) but I would prefer to use parameters for the sort order:
Can I do this using sort order parameters? I have tried all the variations I can think of …