Customer Support Discussion

[ Home | TOC | Search | Post | Reply | Next | Previous | Up ]

Automation

From: Troy
Remote Name: 210.55.225.253
Date: 14 Aug 2001
Time: 21:12:27

Comments

Hi all,

I am new to this and I have to extract data out of the Advanced revelation (V3.0) database on a regaular basis.

I have created a saved script (probably not the correct term) so all I have to do is press F5 and type the key word, and it will run away are select specific data. Also have created a pretermined export to ASCII format, which i have saved, and once this initial select is run, I just type the name of this and it exports.

The question that I have is : Is it possible to have:

The select statement pull back records with a date that is that same as the system date?? (eg Date#=#Now()) Also to have this automated, so that it will run on a daily basis without manual input??

Sorry for the longwinded explaination, however I hope someone can instill a little faith with this, and help me out.

Thanks for your efforts in advance Rgds Troy

Last changed: July 18, 2002