FAQ
Hi,

This is Mahendra,

Could you please help me out in this doubt

I need to delete records from MSaccess database table
automatically on the daily basis(everyday)

I have a scheduler which calls the batch file and
inside batch file I'm calling database
with a autoexec macro.

(To delete all the records whos date is more than 90 days from current
date)
In Macro I have selected RUNSQL
and sql=delete from table_name where req_date <90

this is running fine but asking for do you wish to delete so many
records
Yes or no.. and getting struck in automation process.

So can u help me out what is the solution or alternate for this

Thanks & Rgds
Mahendra

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedApr 27, '02 at 8:51a
activeApr 27, '02 at 8:51a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Mahendra Nath: 1 post

People

Translate

site design / logo © 2022 Grokbase