Recent content by TimboA

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

I have 12 tables (T_JAN, T_FEB, T_MAR etc..). I want to write a single procedure that can be used to extract data from any one table and output it to a csv file. How do I get a dynamic table in a cursor?? I've tried passing a variable (of JAN or FEB or MAR) into the procedure as follows...

I have a table full of data (called ORIG_DATA) that I need to insert into another table. Depending on which month I do the insert determines the table I insert into (i.e. if I do it in January then I want to insert the data into a table called JAN, if its February then into FEB and so on). I've...

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

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

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

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

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

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.

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

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

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

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

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

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.