Hi Sergey,
I am using ASPRunnerPro 31a. When I drill down to the childeren of a master detail relation I get an ASP error. See below
ASP error happened
Technical information
Error number -2147467259
Error description [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended
URL /CRMBehandelaars/CRM_MV_ACTIVITEITEN_list.asp
SQL query select BEHANDELAAR, GROEPBEHANDELAAR, ACTIVITEITOMS, BEGINDATUM, PLANDATUM, EINDDATUM, RELATIENUMMER, INITIALEN, VOORVOEGSEL, ACHTERNAAM, STATUS, EIGENAAR, GROEPEIGENAAR From CRM_BHR.CRM_MV_ACTIVITEITEN ORDER BY BEHANDELAAR ASC, BEGINDATUM DESC where BEHANDELAAR = 'ARCHIEF'
In my believe the cause of the error is the ORDER BY clause which should be after the WHERE clause.
