Technically we are inserting or updating a record, but the form should have just one button Submit from the user point of view. Sc_apl_conf(“check_form”,“insert”,“on”) // it will make sure the button Insert is visible Sc_apl_conf(“check_form”,“start”,“new”) // it will make sure the form opens empty If you start form with start new macro, it won’t add the insert button, so you have to run an extra macro to enable the button. Once the user insert new records you can add own flow. If you remove insert button from the toolbar the button Add New will disappear and you end up with a nice looking form where only one button - submit or whatever. there will be two buttons update and add new next to each other. and this is the empty form with the Insert buttonīy the way, often you do not want insert button on your forms because it will confuse the users. I think SC team thought deep about what makes insert mode an insert mode. Rows_ins Forces the number of lines for insert (only for form of multiple records). Rows Forces the number of lines for each page (only for form of multiple records). if I create a new one, it should appear to all question-sheets per client This functionality can be called via events or via a button and AJAX e.g. First: I manage the questions in the summary (in a multi row form). Update on/off Qualifies (on) or unqualifies (off) the "save" button on the form.ĭelete on/off Qualifies (on) or unqualifies (off) the "delete" button on the form.įield_display_off field Dinamically hides a field.įield_display_on field Dinamically shows a field.įield_readonly field Dinamically set the "readonly" attribute in order to select the field. Im started to work with SC Id like to have a question-summary, and a question-sheet for all Clients. Insert on/off Qualifies (on) or unqualifies (off) the "add new" button to allow the addtion of new records. Start new Forces the form to start in the insert mode in order to add new records. Properties for Form applications Property Value Description Database Firstly you need to select the connection (Database) that you want to use. So I found out i got the last ID of the log instead of the last ID of my table. This macro must be used by one application to modify the properties of another application. If you want the generated ID when you insert to some table, you must run SELECT LASTINSERTID () immediately after doing that (or use some API function which does this for you). The user can determine if a Form will start in insert mode, or a Grid starts by filter, etc. This interface allows configuring the related database settings, such as the SQL statement, the used database connection, case sensitive, and others. This macro allows to modify the property of the application. Sc_apl_conf(“Application”, “Property”, “Value”) SELECT Name,Date,”.$x.There is a macro that will do this (see “start” property): $sql=“insert into table-b(Name,Date,Month,Year,Cb,Cbd) SELECT Name,Date,$x,Year,Cb,Cbd from table-a”) Sc_exec_sql(“insert into table-b(Name,Date,Month,Year,Cb,Cbd)Įlse//in this query I want to insert data from a table-a with the amount of data 100, to the table-b but with repetition as much as $ x, year = $ yr with a different month figures. Sc_lookup(qdefault, “select Date,Cb,Cbd from table-a where person = ‘’”) The following is a script that I use in key processes I have difficulties to insert data into TABLE-B using existing data in TABLE-A and is repeated as many as the number of variables that exist.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |