Dear all, I am getting the following error when I issue an execute query command:
When the panel opens the data is fetched and populated in the OTV_SO_M datasource. However, when re-querying using 'Force Current Row' is ticked in the datasource creation screen. Kindly help me to solve this issue. regards, George. |
Hi George, Formspider raises e_noCurrentRow exception during execute query because you checked the force current row option. Formspider tries to set a current row but the query probably doesn't return any rows. Therefore Formspider can't set the current row and throws an exception. Seemd like all you have to do is handle the exception. Kind Regards, |
Hi Yalim, i have this situation: 1) A combobox with search criteria. When event "valueChanged" occurs, it starts up an action to requery. 2) The query is done from a procedure with api_datasource.executeQuery('datasource-name'); With some search criteria no records will be found, so i also run into the error "Datasource XXXX has no current row". Where do i capture this exception? I tried in the same procedure that invokes executeQuery, but that does not help. Kind regards, Jan Willem Vermeer |
Hi Jan, The exception you need to capture is api_datasource.executeQuery does not raise e_noCurrentrow. This exception is raised by API's that attempt to access to the current row of a datasource (for a get or a set operation) but cannot find one. I guess most if not all of these API's are in the api_datasource package. Kind Regards, |
Thanks Yalim. With this information i could investigate this problem further. It appeared that the error was raised in the procedure fired by the Current Row Changed action on that datasource. Probably during this call: api_datasource.getColumnValueTx. After implementing the exception in this procedure, also the detail datasource is cleaned up now. Kind regards, Jan Willem |