Search results for query: *

hi all i m using oracle8i and my query is that select dat,decode(v_type,'ct',sum(account)debit, decode(v_type,'cr',sum(account) credit) from voucher group by dat; this query works fine but if i increase the conditions, i-e decode(v_type,'ct','ds','gs','ps',sum(account) debit, this makes some...

hi to all i am making a form in java connected to ms access behind. it is based on a table of vendor's record. i m auto generating vendor id .... by using of sql query select max(vendor_id)+1 from vendor; this is going fine but when i use nvl function alongwith the query it generates error...

hi all i m doing a very simple query i don't know where is the problem. i tried this one SELECT 'INSERT INTO TRIAL(AMOUNT) VALUES('||NVL(SUM(COL1),0)-NVL(SUM(COL2),0)||');' FROM TAB1,TAB2,TAB3 WHERE COND1 AND COND2; I GOT ERROR AT THIS POINT " VALUES('||NVL(SUM...

hi all! i'm trying to install forms6i rel 2 on my winxp p4 machine. the installation didn't create any errors but when i try to run form designer i got the error about ifdug60.dll file. i've replaced the file from the installation cd also but unable to get rid of this problem. please help me...

hi everyone! i've a report similar to a ledger report that displays the transactions of any particular record according to the given dates. i-e start date and end date, and the report is running well. but i've a problem in that. suppose i've started entrying the transanctions from 01-Jan-2004 to...

hi gurus i want to know the method to run SDI window without displaying MDI window. i've tried -- ifrun60 module=form_name userid=user/password@SID USESDI=yes -- in command line. it is doing good. but everytime i've to put the code in command line to run sdi. is there anyway to automatically...

hi ! i'm running forms 6i. my problem is that i've some image items (non-database) in my form. i want to navigate b/w them through arrow keys. suppose in each row there are 2 image items. if the image1 is selected and i press right arrow key the image2 should be selected, and if i press the...

hi gurus! i've a report having 3 columns "name","plus","minus" each name may have some value in either "plus" or in "minus", a name could n't have values in both "plus" and "minus" in a same time. there is also one possiblity...

hi guys i've a question. i'm using office 2000. i've a calculated field that always contains decimal values like 30.34, 45,09 etc i've another field in which i want to round the values deciding the values after decimals. if the value after point is between 1 to 20 e.g 12.09 then it would check...

hi to everyone! i'm new comer to vb. i'm running win98 and vb6. and i want to send email via vb to any email containing the text values of the form as the text body of the email. the coding i'm using is --- Dim oItem As Outlook.MailItem Dim oitems As Items Set oOutlook = New Outlook.Application...

hi i want to know is there a compatibility b/w oracle 8 and forms 6i or not? i've tried to install personal oracle 8 with forms 6i. but it doesn't work. plz help me

hi gurus! i'm new comer to this field. well my problem is that i've dual booting in my pc, running oracle 8 in win98 & oracle 8.1.7 in win2000. for some reason i want to transfer the data( a user with its complete tables) of 8i to 8. is there any solution? if yes then what is that. plz tell me...

hi everyone! i'm new comer to this field. i'm using forms6i. my need is that i've an exe file of flash. and i want to run it through forms6i. so i placed an ole on the form. and attach the required file to it. but ole runs the stand alone files. i mean it is not embeded in the canvas. i want to...

hi everyone! i've oracle 8i running and forms 6i. they are doing good. but i don't have devdemo folder installed in my forms 6i. i need some pll files for some tasks. can anybody tell me any url of a website from which i can easily download these files. more i want to change the cursor style to...

hi i want to know how to distinct between postive and negative number of a summary based column in reports at run time. i want to put positive numbers in seperate column and negative in seperate. thanx in advance