Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bgill
  • Order by date
  1. bgill

    CRON Problem

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

    CRON Problem

    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 * * *...
  3. bgill

    Career and Learning

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

    odbc connections and database security

    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...
  5. bgill

    odbc connections and database security

    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...
  6. bgill

    trying for distinct records - not working!

    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...
  7. bgill

    light hearted relief

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

    Error Message

    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...
  9. bgill

    Error Message

    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.
  10. bgill

    Error Message

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

    Error Message

    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...
  12. bgill

    Error Message

    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...
  13. bgill

    Need some performance tuning script

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

    Easy View question

    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...
  15. bgill

    Easy View question

    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.
  16. bgill

    Easy View question

    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 =...
  17. bgill

    Easy View question

    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
  18. bgill

    Easy View question

    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
  19. bgill

    Easy View question

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

Part and Inventory Search

Back
Top