a maintenance script

Results 1 to 2 of 2

Thread: a maintenance script

  1. #1
    yls Guest

    Default a maintenance script

    hi, i have this YLSdate field. what i want to achieve is that when YLSdate is not the date of the system date, i want to delete these records. <BR><BR>1) how to check the date?<BR><BR>2) how to schedule the execution of the scripts?

  2. #2
    Join Date
    Dec 1969

    Default RE: a maintenance script

    &nbsp;<BR><BR>Sql= "Delete TableName.* From TableName Where YLSdate &#060;&#062; #" & Date & "#;"<BR>YourConnection.Execute Sql

Posting Permissions

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