Alpha Video Training
Results 1 to 1 of 1

Thread: Delete oldest record(s)

  1. #1
    Member EricN's Avatar
    Real Name
    Join Date
    May 2007

    Default Delete oldest record(s)

    Currently when a customer posts a job using a grid in the jobs table, a record is automatically added to the customer's history table which has a limit of 50 records.

    I know how to test to see if the limit has been reached, but I don't know how to create a script that will delete the oldest record (if limit has been reached) and allow the grid to add the newest record.

    Any ideas or help?

    Last edited by EricN; 02-04-2008 at 11:21 PM.

    Alpha Five Websites

Similar Threads

  1. Cannot delete record
    By Dan Blank in forum Application Server Version 8
    Replies: 1
    Last Post: 05-24-2007, 06:49 AM
  2. Delete record
    By BRIAN GRAY in forum Alpha Five Version 6
    Replies: 5
    Last Post: 05-10-2005, 01:25 PM
  3. Can't delete a record
    By wcoole in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-09-2003, 01:12 AM
  4. How to delete a record....
    By Jeff Klages in forum Alpha Five Version 5
    Replies: 2
    Last Post: 02-19-2003, 01:21 PM
    By HENRY KAHEN in forum Alpha Five Version 4
    Replies: 3
    Last Post: 06-23-2000, 05:03 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts