Empty record mistakenly saved

12 Apr '17, 09:35 AM
50,408 Views
No Forum Badges

Hi,

I have a page with a Multiple Form that shows three rows. If I insert the values in only two rows and I save the data, in the table is saved also an empty record.
How can I avoid to save the empty record?

Thanks in advance for your help in this issue.

Best regards

 
x 0
Follow
Answer Answer at this question and get points!
Forum Expert - Level 5

Hi,

to avoid this behavior, you can enable the "Avoid Blank Record" property present in the Properties View of the Create Operation. In this way, the component avoids the creation of blank records in the case all the provided inputs are NULLs or empty strings.

Also, when the "Avoid Blank Records" option is enabled, the "Blank Attributes" property is enabled as a result. If no attribute is chosen in this property to perform the control, by default are controlled all the attributes of the entity. So, if the Create Operation receives at least one value, the record is consequently saved.

Best regards

   
x 0
No Forum Badges

Hi Ombretta,

thanks for the answer. I use this property and now no empty rows are saved in the database.

Best regards

 
x 0
Answer at this question and get points!

Related questions

502 proxy error-generate and run Acceder a diferentes site views/ Acces to diferents site views Adding and deleting from the database Add to Bag link in ACME Agregar boton de cambio de contraseña en el login Ajax and FCK Editor (WebRatio 5.x) Ajax onchange and jQuery 2.x (with migrate plugin) incompatible Ajax on change selection field and modify units Alimentar graficas con base de datos any webratio book ? Asking For a Book Atributos Condicionales heredados Attribute comparison in a selector unit Autocomplete template Automatic date in form Automatic file upload [beginner] - How to store and browse data collected with BPM app? BPMN: URL field Business object data Cancellare campi e tabelle dal database Cannot add a Database in the Domain Model Cannot connect to MySQL Cannot insert an entity in the database Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! Change uplod directory and protect anauthorized access to files ckeditor - change directory for the browser Clarification about the NoOperation unit Clean a form Codigo QR Como crear cambio de contraseña Como hacer un menu en webratio? Como mostrar una imagen en una lista o en la componente detalles? Como recuperar todos los atributos de una relacion N:N y insertar registros? Como tener dos botones juntos en un formulario independientes de una accion? Como usar la función autocomplete en un field Compare with the current time Conditional Expression "greater than 0" on null fields Conexion a Oracle 12g Connection refused. Connect more query unit connect to Cloud Content module page variable won't assign. Convert data in a Calculated attribute Convert selector component result to single value coupled mandatory fields Creación DB Apache Derby - Modelado BPMN Create Unit with Date (Year only) Criptare dati sensibili nel database Cryptic error when submitting a form Custom Attributes Condition Database Database connection, Host and Port number Database List is not showing up in App Emulator Database password encrypting Database properties Database resource consumption Database Tables Creation After Remote Deploy Data is always created doubled Data Management: Updating Data - Attachments - Updating Data Sample Project Final DB in Data Service Project Deploy in Cloud Amazon Beanstalk with Postgres Description: Unknown tag 'wr:LinkResource' Disabilitare campi durante evento AJAX Drop down menu question Dudas sobre modelado(Data Flow,Forms y Operation Create) Dynamic attribute/field names. Possible? Dynamic data type Dynamic instantiation of fields on a page for any Class type entry form logic. Entry Unit - Default field timestamp Entry Unity, Field Date Type Error en_US codify problem Error updating metadata process EverLasting error "The TCP/IP connection to the host has failed. Connection refused" Execute truncate sql query Export XML external link.= Field as link soruce file analysis then update MySQL database Filter information in a Simple List Find Model Problemas Foriegn key relationship Format currency Form element Form template forward/backward navigation and bookmark in ajax web app Generate and run locally on webratio professional edition. "Generation Error" with Generate and Run Generation options problem get the attachment files of an email getting data from database Getting the absolute path of a RTXBLOBData Get Unit problem Get Year from Date Groovy and Database Guardar Saltos de LINEA Help for connect public and private site views Hide a form if condition if true Hide form until a flow is triggered Hiding form components based on page conditions Hierarchy component How can i create pagemenu or landmarkmenu with multiple levels. How can I import a view in the Domain Model as an attribute of an Entity? How database or datamodel migration? How does WebRatio represent these IFML elements? / ¿Cómo representa WebRatio estos elementos IFML? How I can receive the primary key value after adding into database from OK Port. How i can reuse modules in multiple projects? How to block empty string in Database How to define the sequence of execution units on a page? How to disble derby database? How to display the attributes of a related entity. How to filter imported attributes? How to fix Network error(status 0) How to include Selector Unit result in Mail Unit Body? How to pass vars to a alternative page How to process IFML Model (build with Eclipse editor) with ATL How to redirect to the correct site view after a successful login attempt How to show a page based on a boolean? How to show certain values derived from relations in the domain model? How to speed up the "last" link using PowerIndexUnit for lots of records How to store data related to an entity in relationships in a project web I can't run any application with WebRatio (Table/View 'APP.POST' does not exist) Image in List field input mask Insert data into database Insert master page to many hybrid modules Integrating a BPM model into an existent WebML model Is it possible to create a derived relationship between databases? JDBC4 Postgresql Driver JDBC connection with mysql on mac Job not start correctly JSON I/O Unit e informazioni derivate KO Links in Selector Unit Landmark in hybrid module Link localization Links from Index unit with condition Link Visibility Condition Power Index Unit Mail multipla maintain the record order in a sortable list Mapping database of the entity '...' is unspecified Math Unit to update attributes of an entity? [MOBILE] Can't synchronize domain model with beck end DB [MOBILE] How I extract information from JSON client side? Modifica Entità tramite file xml Mostrar datos de diferentes tablas/ show dates from diferentes entities MS SQL server jdbc file Multi Entry Unit: How to forward only checked rows? Multi-Image Upload multi-lingual product description Multiple forms on one page. HTML5 input attributes. Possible? (2 questions) multi selections field problem Multi Selects didn't work in update page MySQL Driver jdbc No Apache Derby driver found No Database on Cloud account No database on my cloud account Non riesco a fare funzionare Xml out unit Parametrizzazione Selector Unit Passing JSON Object to Model Personalizzare lo stile di un progetto PostgreSQL Predefined values in database Prelevare la chiave del record da una Selection Field in una Multiple Form Problem accessing MySQL with WebRatio 6 Problema Grafo da una lista gerarchica Problema ¨HTTP Status 404" Problemas con el Operations View Delete Problem Example create Unit (no company in employee table) Problem in adding diagrams in IFML Editor (Eclipse) Problem saving multi selection from input Problems to connect Sql Server DB from Webratio Problems with Database Metadata Problem with fields with accents used in attribute condition Problem with query unit! Problem with Scroller Unit Problem with stored procedure Problem with the deletion of more than 50.000 records in a table Progress bar when uploading big file(s) in a form? publish web service for storing information in PostgreSQL DB following XSD Resource Pulire URL query a database Question about Site Views Redirecting users to another site view Refresh and Synchronize DB Problems Relaciones Removing the User-Group-Module tagles Rename passing attributes Replace ID by its value in another table Resize fields Retrieve a value and add some value to it reverse engineering, problema con le relazioni di default Script Unit e Mysql Search by Selector component does not work Select between parameters selection fields on cascade Select multiple files for upload Selector unit doesn't return any value in hybrid module Sending mails is not working Sending mails with gmail is not working Setting the Default link for a Switch unit Setting Upload directory Share database connection show/hide fields on button click (registration page) Showing items that have a relation with an entity Slot in Selection Field [solved] all links transparent, why ? Solve "Generation Error" with Generate and Run option Something leads to wrong condition expression evaluation. Statistics Component for WebRatio > 7.2.0 Status ProcessInstance and activityInstance in spanish sumar atributos de una tabla filtrado por Role Condition Sum entity's values Sybase JConnect 4 JAR replace Sync DataService Project with Mobile Project Table 'freeapp43.profesion' doesn't exist Tarea de servicio no me evalua el valor Transportation Link issue Trying to Synchronize Domain Model Unable to execute the script java.lang.NullPointerException Unique Fields Unknow property on Dynaclass after generation Unspecified BPM Engine Database Update fields based on selection of other fields Update mutiple records with the same value Updating attributes of an entity upload file and the move it to other location upload file html Uppercase User Login Timestamp Username come chiave Using own User and Group tables using relationship role conditional with null Uso de la componente chart de webRatio usuarios y grupos utilizzo componenti database Validacion validation fields Value Length (Min) fails to validate when field is empty? Visibility Condition on Multiple Links From Index Unit Web ratio data model WebRatio - list results of joined tables Web Ratio Mobile and Foreign Key Web Ratio Mobile - Remote data mapping problem WebRation - Create Navigation diagram WebRatio no imports all attributes (fields) of a table What are the new features of WebRatio 6.1? Where is the ACME demo data stored?! which of these three models is closer to webratio/ifml way of creating web applications White report