Hi all,
I have a form with three text boxes. The first is a bound text box to a field SALE_SUBTOTAL in a table where I ultimately store the form contents as a new record. Under this text box, I have two other text boxes, one which contains the expression =[SALE_SUBTOTAL]*0.2, which displays...
Hi all,
I have a problem where I need to remotely access a desktop and have the audio / microphone audio passed from the far end machine to my desktop. I thought that perhaps PC Anywhere would have that functionality but it appears not. Does anyone have an idea of software which can do this...
Hi all,
As per the title, Im looking for a way to print off an outlook calendar graphically to display a timeline if you like. Similar to the way the scheduling tab looks when you are scheduling a meeting. Is there any way, or using an additional tool to do this?
John
[smile]
Hi all,
I have QueryA which returns three fields in a List box on a report. I have added the behaviour to open a new query QueryB which runs using a value from column 1 in QueryA, but I cant get this run correctly. How do you tell the new query QueryB to get its criteria for the query from the...
Hi all,
I have the following Data....
ID START(UTC) END(UTC) DURATION STATE TRANSACTION_ID
------------------------------------------------------
1 1251384001 1251384102 101 INBOUND 31808563970
2 1251384102 1251384202 100 HOLD 31808563970
3 1251384202 1251384302 100 INBOUND...
Hi all,
I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex. Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...
Hi all,
I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex. Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...
Hi all,
Im running IE8 on windows xp and have to view some presentations from a vendor which launch via a play.htm file, which then seems to jump to another page. I believe this is trying to run some javascript, and it runs fine on an old xp machine with ie6.
Ive done a clean build of xp, ie8...
Hi all,
I have a situation where I have a table TABLE1 and a backup table BACKUPTABLE1 which is an exact copy of the main table, populated by running a query before a bulk merge to the TABLE1 table.
I am looking for the best way to handle some kind of rollback, and I have looked at rollback...
Hi all,
I have an issue which is driving me bananas! I have written a script on windows machine which calls an sqlplus -s script. Yesterday I tested it and it worked no problem, but today I get the error SP2-0734 saying it cannot recognise the command.
I have ors81 and ora92 homes, and have...
Hi all,
I am currently using the following command to cat a bunch of .gz files, gunzip -c them, and then grep for a text string which sends to output file
cat *.gz |gunzip -c |grep "person_dbid = 10353" >Skillchange8.txt
What I need is to have the filename of the original file where the text...
Hi,
I run with a preview pane, and if I click out of the main inbox window and into the preview pane, I can hardly tell which message is actually selected in my list of messages in inbox.
Is there any way to alter this, so that even when I click in the preview pane, the selected message is...
Hi,
Real Newbie question, but Im installing an appa on a solaris box and its asking fro the Domain of the box? How do I find this on Solaris?
John
[smile]
Hi there,
Im looking for a way to get an export of the fields which are in the tables of our Database and I have very basic SQL knowledge and read only access.
Is there a simple SQL command to get this info or a utility?
John
[smile]
Hi all,
I have an oracle viewas per below....
CREATE OR REPLACE VIEW v_login (
employee_id,
place,
event_desc,
eventdate,
"TIME"
) AS
SELECT
P.EMPLOYEE_ID,
L.NAME,
CASE STATUS
WHEN 0 THEN 'LOGOUT'
WHEN 1 THEN 'LOGIN'
ELSE...
Hi all,
I have a view which has the following columns,
STARTTIME
ENDTIME
The data is in the format hh:mm:ss but I think it is actually in text format rather than time as such. The underlying table has this column in UTC, and a conversion is done in the structure of the view to give us the...
Hi all,
I have a desktop HP DC7100 SFF PC which uses integrated graphics and I want to upgrade the graphics to something decent. Trouble is I cant find many half height card options?
If this will be a problem, I was thinking of moving its guts to a tower I had sitting but Ive noticed that the...
Hi all,
I have generated a bunch of flash galleries (photoshop elements)which seem to me to be rather complex in the way they are structured so I have put each one which has its page, the swf files, and all the resources under a seperate folder for each in my site. My plan was to make a master...
Hi all,
I am trying to get some training material on the whole TO_CHAR and TO_DATE functions of Oracle DBMS but in the mean time I need help with the following query?
I have a view which has a date field defined as
TO_CHAR(TO_DATE(STARTLOCALTIME,'DD/MM/RRRR HH24:MI:SS'),'DD/MM/RRRR') as...
Hi all,
I am trying to get some training material on the whole TO_CHAR and TO_DATE functions of Oracle DBMS but in the mean time I need help with the following query?
I have a view which has a date field defined as
TO_CHAR(TO_DATE(STARTLOCALTIME,'DD/MM/RRRR HH24:MI:SS'),'DD/MM/RRRR') as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.