Search results for query: *

It's ok now. found the answer in this thread http://www.tek-tips.com/viewthread.cfm?qid=267938

Running Solaris8. I have cron jobs set to run every hour from 6am till 7pm, as oracle user, which transfers archive log files to my standby system. This job ran ok till 7:00pm yesterday evening. Since 6am this morning it fails. Here is the line in the crontab: 00 6-19 * * *...

This is my favourite access site, and it's uk based. http://www.access-programmers.co.uk/forums/index.php? Really good site.

Thanks for the replies guys. Just to update. Yes I can monitor connections from the listener log and am working on a way to get notified automatically if a connection is made to the database other than via the application. We have already stripped odbc from all workstations and I am having the...

Hi, here is my dilemma. I have a database with hundreds of users. The database is oracle 8.1.7.2 on solaris 8. The database runs a financial application (banking). All the users connect to oracle through the application. All users have insert update and delete privileges on the main schema...

When you say that "the whole thing goes bonkers" what do you mean? Do you get an error message? does the select statement return any data, and if so, what? Also you say "I thought I'd be able to get select min(row_added), workorder_no, workorder_desc from workorder_def group by workorder_no...

Would the last person to leave this thread please turn off the lights :-)

Interesting. As I said previously I have a workaround but discovered the following while testing it. The app is designed to be user friendly. basically you open the database, are presented with a form, press a button and everything is done in the background and your reports are sent to the...

Thanks for the replies. I have managed to come up with a work around for the problem. It's not perfect but at least management are getting their reports again.

Hi, Not running win200 server, just the workstations. Oracle databases are on unix servers. Net Still cant find that damn logfile!

Hi, The mdb file imports data from an oracle database on our production server and generates a report for management. I have run this against our test database with no problems, and also against our development database with no problems. It only fails on production. The prod, test and dev...

Hi, I'd be grateful if someone could help me out here. I am getting an error message from Access which says 'MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created' What error log? Where is it? I cant find anything...

try this link http://www.ixora.com.au/scripts/

Hold on In your third post you said The view should only show: REF_NUM TRAN_DATE TRAN_NUMBER 10921671 13/01/2003 000377 0224529015 14/01/2003 000018 Yet your sample data shows A new sample of data: REF_NUM TRAN_DATE TRAN_NUMBER 10921671...

Yes sorry! should have seen from your sample data Each transaction has a number. Although will only work if the max tran_number corresponds to the latest transaction.

Ok try jee's original script on the same sample data in your third post. ie. SELECT ref_num, tran_date, tran_number from table1 t1, ( SELECT MAX (to_char (TRAN_DATE, 'dd Mon YYYY HH24:MI:SS')) max_date, ref_num FROM table1 GROUP BY ref_num) t2 WHERE t1.tran_date =...

What result do you get if you execute the following? select MAX (to_char (TRAN_DATE, 'dd Mon YYYY HH24:MI:SS'))from YOUR_TABLE_NAME

OK, When the tran_date is recorded is there a time element involved. Can you manipulate to read the max tran_date in the format DD-MON-YYYY HH:MI:SS example SELECT to_char(sysdate,'dd Mon YYYY HH24:MI:SS') from DUAL

Jee's script looks ok. Did you drop the original view? Use CREATE OR REPLACE VIEW syntax when creating the view.