hi, i'm trying to evaluate the formspider, witch seems to be a very usefull tool for fast developments. now, i,ve created a data source ds, based on a simple table users (usrid,usrname,usrpasswd), usrid is treated as an auto incremented field (using trigger at insert time). i've build a grid with datasource ds. i have 2 events, on dubleclick on a grid element,a new dialog is open, containing a panel with all the inforation reqarding that line. The elements on the new panel are also linked with the data source; after modification on some record information by pressing 'save' button i've see the modification in the grid, but doesn't commit into the database, even if a use api_application.doCommit; on the other hand , i have also on the grid a button for new record, when i open the same dialog, but empty, because firts i,ve create datasource new row; by saveing i've got an error, something like not new row in data source; what am i doing wrong? witch is the best practice in this situation? thanks, bsd |
hi, i was able to manage also the inserts; seems that i have to set insert trigger disable; here is the sample of what i've done: --create a new row if the for is open by the button if api_application.getevent().objectname_tx = 'usersGridPanel.btnNew' then
end if; --on save
-- on form close if the data is not save we have to clear the created row if api_datasource.getcolumnvaluetx('dsusers1.USRID',api_datasource.getcurrentrowid('dsusers1')) is null then api_datasource.deleteCurrentRow('dsusers1'); end if; regards,
bsd |
Hi BSD, Could you please send us the export of the application and the PL/SQL code you wrote? You can export a Formspider application from the menu var at the top FIle->Export. Please email the export and the PL/SQL code to support (at) gerger.co . Thank you. |
Hi, |
hi, it seems that i've forgotten to put the ds updatable; i will check also with the inserts; thanks, bsd |
Great. Let us know how it all worked out. |