Announcement

Collapse
No announcement yet.

Change Record Status upon export

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

  • Change Record Status upon export

    Hi
    I want to run an export of filtered records in status "X" and have the status update the status upon execution to "Y" and capture date.
    Is this achievable?

    Alternatively, and perhaps easier, How can I edit multiple records at once i.e.
    Select Status column and change to "Y"
    Select date & Change

    Thanks

  • #2
    how about performing an update statement and then doing an sc_redir to the same page?

    Comment


    • #3
      Can you give me a hint on how to do that please?

      Comment


      • #4
        Editing multiple records at once how I think you could do it.
        Suppose you have a record with 10 fields. Catch the OnChange event of the field you want to change.
        In that OnChange event perform an update for the records you want changed:
        then just do an update mytable set status='Y' where status='X' in an sql call (autocommit is assumed here).
        after that simply sc_redir to the page you are already on.

        Comment

        Working...
        X