Recent content by chochoo

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

thanks both of u for replying. i've checked my columsn they contain only number and the remedy of himan works and i got my desired results thanks Himan for that.

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

how can i pass the parameter in shortcut can u plz guide me?

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

thanx lewisp but still i'm having problem in moving left and right.

hi rob i think there is a problem in the code u are using. can u plz explain your code with the trigger accociated with that to find what the exact problem u r going to have?

hey u can do this: alter your table by giving sysdate default to your date field and hide the date item in your form. it will automatically insert the sysdate in your table and no body can change that. -- alter table applicant add (app_dat date DEFAULT sysdate); -- hope this would solve your problem

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 thanks nagornyi for your solution, its working but i've also put the trigger for plus and mins to hide the complete row

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

thanks tony yer formula is working