![]() Sorry, this doesn’t work, since I have an editable grid with several rows, in which the fields have names “punkte1”, “punkte2”, “punkte3”, …, “bonus1”, “bonus2”, “bonus3”, …ĭocument.F1.focusedFormElement = this ĭocument.F1.focusedFormElement = null įor(var j = 0, e = document.F1.elements j < e. I have set the id for all tables on auto_increment.Ĭould it be a better idea to have only a table_00 auto_increment, and all others would be set to Auto Increment (manual), but I’m not sure how it works at 1.gesamt.value = obonus + opunkte *** End Update a record on another table */ ![]() “datum_razgovora4 = ‘$datum_razgovora4’”, $update_fields = array( // Field list, add as many as needed In this tutorial, we will see how use a field with type Select to checks values that are in another tables. ![]() But I want the looked up value inside the field to send it as an e-mail and to save to db. Even when I say Use lookup to display the field description, it shows the value I want next to the field. Works fine when it is used as select with grid lookup. Sc_ajax_javascript (‘nm_atualiza’, array (“alterar”)) sc_redir (kpk_form_01.php, id = ’” // Where clause Hi, I want a form field in form1 to get the value from dbfeildname of a separate table. Sc_commit_trans () // save the changes (inserts the data) Then I have a php SAVE button to create all 18 forms with this code: Then the date field appears and in this field I have Aja圎vent to save the data: sc_ajax_javascript (‘nm_atualiza’, array (“incluir”)) įor this, there are two optional fields that are sometimes entered or not. What day is even all day OK, the second day there is an error. So in all three cases it is an identical database.īut not always. everything is OKģ- Users who access the app from the business location, however, fail to make a mistake. The application is installed on a hosted server and the database is also on this serverġ- I access from home and input data - everything is OKĢ- One user tested the application before use and accessed from home. ![]() I ask for some idea how to set up the concept and prevent these errors. I can not figure out where the error is and what goes wrong.īut I can not combine all the tables into one table and one form, because then it’s over 450 fields and it’s impossible to work with Scriptcase slowly and the database is slow. My id is set to automatic increase in all tables. Empty records appear and this completely destroys the complete concept.īecause the id from the individual tables does not match anymore all inputs are mixed and useless. I have everything already done and everything from my office works all without error.īut by the user does not work. The two fields are identical in all tables. Altered & deployed forms also reflected their changes. Somewhere about here it dawned on me to clear the browser’s (FF) cache. Example of an application used to update a N:N relationship table using the Double Select object on the field Regions. I should add that I noticed some other occasional weird behaviour with changes in application forms not being reflected when deployed to the remote server. The number of data is different for each page. Many-to-many (double select field) form24 see complete description. For example: if the field is defined in the database as cmpnameclient, it will be easier to the user understand if the name is Client Name. Label : Set the title of a field in the application. When set to CheckBox, you can have multiple options selected. table_01 to table_18 and copy certain data from table_00 in them. Data Type : Select the type of field for the application. 10 fieldsĪfter creating the page 00 - I need to create 18 pages. I have a form - table_00 in which I enter all important and mandatory information. I am looking for a solution how to best create 18 forms from the initial form.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |