Announcement

Collapse
No announcement yet.

[SOLVED] Adding a new mysql-table-field to an existing single row form application?

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

  • [SOLVED] Adding a new mysql-table-field to an existing single row form application?

    Hi all,

    Still evaluating ScriptCase, and I've run into a scenario that I can't find the answer to...

    If I have a single row form application that I have created based off a mysql table... for example:

    the mysql table is called customers
    the fields are customer_id, activeflag_id, customer_name, customer_domain

    ... and then I decide I want to add a field to the customers table in the database, say customer_phone...

    How can I now add customer_phone to my existing form? Is it possible? I cannot find a way...

    On the grid applications, I can do this by simply modifying the SQL statement and then under field positioning, moving the field the proper place. I often go to Edit Fields and make changes like renaming the label to something the end user will understand, setting up an SQL statement for a field lookup instead of having a foreign key there... but in the form applications, it seems when I originally design the form, I'm stuck with whatever fields I had when I created it.

    Then again, it is late at night, and it's possible I'm missing the forest for the trees. Any help would be appreciated. :-)

    -Anomaly0617

  • #2
    Go to application -> synchronize. That's all. (For standard forms). For grids you need to adjust the sql, but you already found that. After adding the field by synchronizing you must put it on your form somewhere, it's not on by default (field position).
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Thanks, Albert, that worked!

      Comment


      • #4
        Originally posted by aducom View Post
        Go to application -> synchronize. That's all. (For standard forms). For grids you need to adjust the sql, but you already found that. After adding the field by synchronizing you must put it on your form somewhere, it's not on by default (field position).
        I am having exact same problem. And I am unable to find "Application->Synchronize" menu item to do the sync. I am on V7 evaluation version. So far so good except for this problem. Any help is much appreciated.

        Comment


        • #5
          Please ignore my question...I found the menu which on side bar for the application. I was trying to use the main menu bar "Application" item. Apologies.

          Comment

          Working...
          X