Announcement

Collapse
No announcement yet.

Field - Calculated by the database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Field - Calculated by the database

    In the window that shows the settings of a specific field, under the 'Database value' heading there is an 'Insert, Define the value to be saved in the database' and a 'Value in Database (Update)' where I can use the drop down box to select 'Calculated by the database'.

    How do I use this feature? Does it allow me to have the field automatically calculated at the database level?

  • #2
    Does exactly what he sais. Calculated by database, or just when null is calculated database.
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Where do I add database calculations?

      Comment


      • #4
        Originally posted by cnbrammer View Post
        Where do I add database calculations?
        IT depends on database. Some RDBMS allows creating calculated fields, others not and calculation is done with triggers.
        /Giuseppe

        Professional Scriptcase Services
        Some Customers opinions

        Comment


        • #5
          I am using MySQL, is it possible to add calculated fields with this database type? And, if so, is it possible to do this through ScriptCase?

          Comment


          • #6
            Not sure, I think MySQL don't allows calculated fields, otherwise, if you don't know if exists, you don't need it
            /Giuseppe

            Professional Scriptcase Services
            Some Customers opinions

            Comment

            Working...
            X