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 derfloh 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: *

  1. TimboA

    Dynamic Table Name in a Cursor

    The db is used to store monthly transaction data (approx 40 million trans per month) from another system and we'll be keeping a rolling 12 months of data. Each month end, we'll be clearing out the appropriate month (ie at this month end we'll clear out data from March 2003 and load in data for...
  2. TimboA

    Dynamic Table Name in a Cursor

    ...the procedure as follows :- create or replace procedure pr_mth_csv (p_mth VARCHAR2) as v_mth VARCHAR2(5) := 'T_'||p_mth|| CURSOR TAB_DATA IS SELECT * FROM v_mth; etc.... But this gives me an error of "PL/SQL: ORA-00942: table or view does not exist" Any ideas??? Many thanks in advance.
  3. TimboA

    Insert Into Using Dynamic Table Name??

    ...uses a parameter at runtime called v_FILEMTH, allowing the month name (JAN, FEB etc) can be entered, but I can't get my INSERT statement to work using the parameter as the table name (i.e. INSERT INTO v_FILEMTH SELECT * FROM ORIG_DATA) Any idea how I can get this to work ?? Thanks in advance.
  4. TimboA

    MSHearts on Windows 2000

    Does anybody know how to get MSHearts working on a Win2000 machine? I used to play all the time on my old Win98 machine, but MS seem to have ditched it on Win2000!! I've managed to find the files needed (MSHEARTS.EXE, MSHEARTS.HLP and CARDS.DLL) but when I run the exe I get "Cannot Find...
  5. TimboA

    Calculate Working Days in SQL

    I need to calculate the number of working days between two dates using pure SQL (ie can't use WORK_DAYS). Anyone know how this can be achieved?? many thanks in advance. timboa
  6. TimboA

    AS/400 Query & Reporting Tools

    Thanks everyone for your valuable input. I've been looking at the SEQUEL software (from ASC) and it looks to fit the bill !! It allows me to create predefined SQL views (with parameters if necessary) and via the SEQUEL Web Interface Module, my Users can then run the views via a browser...
  7. TimboA

    AS/400 Query & Reporting Tools

    jrjuiliano, Thanks for your reply, and I agree that the AS/400 Query tool is very powerful. However,my quest is to allow my average User to run their own pre-templated reports therfore negating the need for further manipulation on their PC - most of my Users can only just use a PC (bless...
  8. TimboA

    AS/400 Query & Reporting Tools

    My company is in the process of buying a CRM package that runs on the IBM iSeries Server running AS/400. My remit is MIS and Reporting. I know that AS/400 comes with it's own query tool (AS/400 Query), but from what I've seen this is totally "green screen" based and not very user...
  9. TimboA

    Data Cleansing Trigger

    Thanks Dagon, I think my brain was having a relapse...sledge hammer and nut and all that. PS - I had to change it to a BEFORE Insert to get it to work.
  10. TimboA

    Data Cleansing Trigger

    Thanks Dagon, I think my brain was having a relapse...sledge hammer and nut and all that.
  11. TimboA

    Data Cleansing Trigger

    I currently have a date field in a table that is being written to from an Access Front End. However, sometimes (and I haven't yet found out why!!) the date is written from the access client machines in DD/MM/YY format, but other times it's in MM/DD/YY format. I need to create a trigger that...
  12. TimboA

    SQL "Matrix" Query

    I want to write from a table that will display the results matrix style. The table contains UserIDs and the Roles they have been granted, for example :- USERID ROLE SCOTT SALES ADMIN SCOTT FINANCE CLERK SCOTT CREDIT MANAGER What I want to display...
  13. TimboA

    ODBC Direct Syntax Problem

    I'm trying to connect to an Oracle 8i Db via Acces using ODBCDirect. My code (located in a module) is :- Sub CreateConnection() Dim wrkODBC As Workspace Dim ConnOracle As Connection Dim strCon As String ' Define Connection String strCon = "ODBC;DSN=dev;UID=scott;PWD=tiger" 'Define...
  14. TimboA

    Hard Drive Upgrade Advice

    Thanks for the assistance with the Ultra DMA issue, and I'm glad I posed the question on this forum as I never knew the BIOS might have a bearing on my choice of Hard Drive upgrade. Fenix, from your reply sounds it like you are intending to have 2 x hard drives in your machine (the original 6gb...
  15. TimboA

    Hard Drive Upgrade Advice

    osuman, Thanks for your reply. What I was really after (and didn't make it that clear !!) was info on my 5170, and whether it was Ultra DMA compliant - I'm not too up on these things, has Ultra DMA been around for a while (my 5170 is about 3yrs old...) Thanks again.
  16. TimboA

    Hard Drive Upgrade Advice

    I'm looking at upgrading my Compaq Presario 5170's harddrive. I currently have a 6Gb disk, but am looking at putting in a Maxtor Diamondmax D740 40gb. The problem I have is that I'm not sure whether my PC is compatible - I've read that it has to be Ultra DMA compliant ?? Can Anyone...
  17. TimboA

    Pass-Through Query With Parameters

    I've created a module (called Parameter_Pass_Through) and added a function for a pass-through query to my Oracle DB as follows :- Public Function ParamSPT(MyProcName As String, MyParam As String) Dim MyDb As Database Dim MyQ As QueryDef Set MyDb = CurrentDb() Set MyQ =...
  18. TimboA

    Table Join Query

    dgillz, many thanks for your suggestion, I've got it working for those records that have an entry in table 3, however I've got a few records which I need to report that don't have anything in table 3 (i.e. no email addresses or websites data present). I'm struggling on the syntax for...
  19. TimboA

    Table Join Query

    I have a Crystal Report which is produced using Customer data from 2 tables. I need to add in a further field (email address) which comes from a 3rd table, joining it to table 1. However, the 3rd table contains multiple records for each record in table 1 (Primary email address, secondary...
  20. TimboA

    HP4300C Scanjet Installation Problem

    Just in case anyone has this thread marked, I'd thought I'd let you know that I've now got my scanner working !!! I spoke to HP Tech Support and after the usual de-install, delete registry, delete USB Devices, re-boot, reinstall - I was still no further forward. A colleague suggested that I...

Part and Inventory Search

Back
Top