Announcement

Collapse
No announcement yet.

Form limited to insert and show only 1 record

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

  • Form limited to insert and show only 1 record

    Hi all,

    I've to create a table and a form about where I want to record all LOGOS used on several application.
    Becouse I need to have a unique global reference to a specific image on this table I have to limit the data entry to only 1 record.
    Just to be more clear
    logo_id
    logo_100x50 --> Database image
    logo_100x100 --> Database image
    logo_200x50 --> Database image

    Which could be the trick to limit to one record only the logos table ? I've to do the constraing on DB side or have I to do it in SC form ?
    I imagine to hide toolbar button i.e.

    Many thanks
    Giovannino

  • #2
    Insert a default empty record in the table with the key you need. Then delete the insert and delete button from the toolbar. If you open the application it will default show only the save button and show the current record.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Hi Aducon,

      It sounds nice, thanks.
      Tomorrow I'll try it !
      Bye

      Comment


      • #4
        I'd confirm the trick works. The only thing you have to activate is "Update" and "First" record on footer otherwise nothing happens.
        Strange the needing to insert something on footer, but after many tests I realized it.
        Bye

        Comment

        Working...
        X