Recent content by fernandezd

Hi all, How do I send a report to an xml file automatically from the click of a button please. Regards

Hi all, can some one point me to a location or example of the following. Logging of all the data a user changes onto a separate table. so that this can be audited. Just in case some one says the database is the problem. Thanks

Hi, This is my dilema. I have a field called Create_time for records. It is a CREATE_TIME which is a NUMBER(15). Now I think this is the number of seconds since 1970. I have to compare this to actual time like say select sysdate from dual;But this is a differnet format. What I would like to...

Hi I want to be able to get the current timestamp from a database by using select statements. How can this be done? FernandezD At your service. Unix systems Admin

OOOPS This any good for you... The script can be altered to produce HTML if you like. FernandezD At your service. Unix systems Admin

Hi all, I have a routine that when the group stops it will run a program which dumps the completion report onto a file. At a time during the day this is then looked at by a script and a report generated from it here is a sample of the email I receve every day...

Thanks but I do not get it. The notification is run on the backup server. A sun box. The SQL instance is in an Windows Compaq Server. How do I set a pre command and post command on an windows server I know how to do it on the sun server through the savegroup.res file. Is it the same ...

Hi, Is there a way to clearout the sql transaction log files automatically from the sql executable for the legato backups? DAVE FernandezD At your service. Unix systems Admin

Why??? I can do hot backups for the database but cannot resotre to a dorrupt file system from a hot backup. Do I have to rebuild the database and then resotre to it?? AHHH sql servers. FernandezD At your service. Unix systems Admin

Hi all, I have sql servers backing up on hotbackup mode with the sql agent. I want to do a cold backup at the end of the week to make sure we can restore. now how do I do this? How do I shutdown the sql server with legato? Thanks FernandezD At your service. Unix systems Admin

Hi I have the same problem were do you store the Input file. Please some one help. FernandezD At your service. Unix systems Admin

Cheerio I know but I am desparate. I have to roll out this project soon and I cannot do with it what I really want too. Please help FernandezD At your service. Unix systems Admin

Hi I want to be able to change the status bar so that it has different information in different fields not just the massive one suppied. Or even add a new Active X control for a status bar. I must say I have not got a clue how to do this. Can some one please help me. I want to be able to...

Hi, I just read this. What about changing the status bar so that it contains more then one field. as Access has loads as standard. FernandezD At your service. Unix systems Admin

Hi all, I want to add a status bar to my Access database to show user name and version numbers etc. I have added the active X control but I not got a clue how to update the information on it. I have been looking for three days now with no success. PLEASE HELP... FernandezD At your service...