Register   |  Login
      Search
    Welcome Guest! To enable all features please try to register or login.
    Admin
    #1 Posted : Monday, August 06, 2012 2:42:24 PM(UTC)
    Lean Software

    Rank: Administration

    Posts: 42

    A new feature has been added (by request) to indicate primary key violations within the same batch of data using the Validation button.

    The new feature "Batch validation" will run validation on selected rows as a single batch or 'transaction'.

    Lets say we have key field 'CustomerId', and we enter several rows with same id.

    When we use Batch validation this mistake is highlighted and validation stops.

    To use Batch validation, obtain version 1.1.21 or later, and select the batch validation option from the Advanced tab of the task setup dialogue.

    Batch validation

    Row validation
    Submits rows for Validation or Send in separate transactions, one per row.

    Batch validation
    Submits rows for Validation or Send in one transactions, one per batch of selected rows.

    Edited by user Monday, August 06, 2012 5:06:00 PM(UTC)  | Reason: Not specified

    Rss Feed  Atom Feed
    Users browsing this topic
    Guest
    Forum Jump  
    You cannot post new topics in this forum.
    You cannot reply to topics in this forum.
    You cannot delete your posts in this forum.
    You cannot edit your posts in this forum.
    You cannot create polls in this forum.
    You cannot vote in polls in this forum.

    Download

     

    Excel Database Tasks

    DOWNLOAD

    Fully functional 40 day evaluation 

    on up to 5 workstations

    No row limit in the evaluation

    Product Guide

    Excel Database Tasks

    Update

     

    6th February 2013

    Version 2.5 has been released

    Read more..


    Feedback

    Great product, I can see how it can save people a load of time! by Richard (UK) July 2012

     

    OMG this works great with SQL Server! by Freeman (USA) June 2012

    Community



    Share a link to us