Recent content by aidystew

Sorry yes. The table_name and field_name will only reference a single value that will be returned. Earlier in our process a whole bunch of variables are initialised and stored in memory in the form of rowtype variables that are available to the whole transaction - but only from within the...

Dima's code should work on oracle 9.2 but won't work on version 7, as you can't put an order by on an inline view in version 7. I know I tried it the other day. :(

Hi, I'm using oracle 7.3.4.5 (plsql 2.3.4.5.0) and am trying to do something akin to dynamic sql but with plsql. What I'm trying to achieve is to create a function that returns the values stored in a package variable by passing in the name of the table and column and returning the contents of...

Update on previous query. This still seems to be causing a problem, however, the query only hangs when run as part of an 'end-of-day' suite. If we run the queries or the whole sql package on its own it seems fine. there are two SQL selects that have had parallel query hints added. Both produce...

Queries run in SQL*PLUS complete correctly. However, when placed in cursors and run in two procedures (one after the other), the first appears to finish and the second hangs (no output is produced for the second) Problem cannot be reproduced in sql*plus they both always finish (in a single...

Have you tried installing the Office XP service pack - available from the Microsoft Website?

Sorry, when I was talking about files I actually meant folders... I don't think you can protect individual files - although you can apply password protection by zipping them and adding a password to the zip process. I think you can even protect individual files by password through word etc...

You can, but only if you are running Windows NT, 2000 or XP. You have to convert the relevant partition to NTFS (you cannot password files on a FAT or FAT32 drive)and then you can right-click the relevant file and an option to protect this file will magically appear! PS Partition Magic is a...

Have you tried the Win2K service packs? They fix an awful lot of problems. They are about 250mB in total - so its quite drastic, but it may be worth a try.

Thanks very much - that's sorted it.

Don't know how your knowledge is - but a basic overview of features can be found at: http://www.win2000mag.com/Articles/Index.cfm?ArticleID=7766 a FAQ can be found at: http://www.programmingmsaccess.com/FAQs/MOD.htm a tutorial on MOD can be found at...

I am experiencing problems with a PC that will not allow a document to be opened properly that contains text forms. Instead of inserting the correct textform box it inserts the following {TextForm}. I have tried installing the whole of Office in case something needs to be run from the...

Thanks for that - but I think I've solved it. If you use AuxOutTime and take away AuxOutOffTime from it (which is Outbound Talktime) you are left with, ehat I can only assume is, the Ringtime.

I'm using Centrevu Supervisor 9 and am having trouble with whether a database item exists or not for a historical report. I have looked through the documentation - to no avail. What I'm looking for is an item that will give AuxOut Ringtime. This would be exceptionally useful for my report -...

I've had a closer look at the suggestions you made & it seems that it is not possible to use the SUM function in a realtime or integrated report - looking at the historical report I found that includes a 'totals' line (which is what I was really looking for). I found that the section that dealt...