Sitemap

Amicuk Programming Answers

How we find that value exists in block or not??

-0001-11-30   Views:0

Advertisement

Hi All: I am building form in 10 g enviornment. I want to know that at execution time, that value exists in block or not. Beacuse I want to execute query only at this time when no value in block. its a tab sheet form. When I enter value in block. And

Hi All:
I am building form in 10 g enviornment. I want to know that at execution time, that value exists in block or not. Beacuse I want to execute query only at this time when no value in block. its a tab sheet form. When I enter value in block. And then go to other block. then the previous block value disappears( query executes). Please every body know. Help me . Thanks
Ali

The replay answer
Advertisement
You could check the block query status?
v_status := get_block_property(<block_name>,STATUS);
From the help:
STATUS Returns the VARCHAR2 value NEW if the block contains only new records, CHANGED if the block contains at least one changed record, and QUERY if the block contains only valid records that have been retrieved from the database.

Go to See the other 2 answers

How we find that value exists in block or not??

Category:DefaultRelease time:-0001-11-30Views:130

Hi All: I am building form in 10 g enviornment. I want to know that at execution time, that value exists in block or not. Beacuse I want to execute query only at this time when no value in block. its a tab sheet form. When I enter value in block. And[More]

How to change existing database block size in all tablespaces

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Need Help to change block size for my existing database which is in 8kb of block size. I have read that we can only change block size during database creation, but i want to change it after database installation. because for some reason i dont wa[More]

Folders don't exist for blocked add-ons. If they do, where are they?

Category:DefaultRelease time:-0001-11-30Views:130

I read and followed all the instructions for uninstalling blocked add-ons. Safe mode didn't enable the Uninstall buttons and the folders for blocked add-ons don't exist in either the profile or installation extensions folders. They still show up as i[More]

Adding New Dimension In An Existing Cube (Block)

Category:DefaultRelease time:2015-10-11Views:130

Hi fellows, Im not an expert so need you feedback. I am supporting a cube that was built a decade ago using Essbase 6.5. It has 7 dimensions (3 dense, 4 sparse). With the new reporting requirement, I need to add a new dimension to be called "BaseTime[More]

1and1 Webmail signing out only on this computer, won't sync, blocking non-existant pop-ups & windows

Category:DefaultRelease time:-0001-11-30Views:130

My webmail is auto signing me out several times a day, but only on this computer. It's set for 'private', I've uninstalled and reinstalled that program, cleared cache and re-started, same thing with Firefox. Firefox is also frequently blocking pages[More]

Looking for a select block

Category:DefaultRelease time:2015-10-11Views:130

Hello! I'm looking for a select block but I don't find it.. I want a block with four inputs,an input select, and one output. The output variable catch  the value of the input variable which his position agree with the value of input select. Ex.: I ha[More]

Adding a New Assignment Block

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, I need to add/create a new assignment block 'Strategy Plan ' similar to existing assignment block 'Attachment' in Account screen. I got the document which suggest creation of new assignment block by creating Set Type and attribute. But[More]

Payment Block Not stopping the payment to vendor??

Category:DefaultRelease time:2015-10-11Views:130

Hi All, we have a problem related to Payment Block option in Vendor Invoice. by using FB02 We have updated the payment block for MIRO accounting document against the vendor line item. while processing the vendor payment the blocked invoice is appeari[More]

Why to open Block only with Dense dimension Member ???

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want to understand the logic behind opening the block with dense member. Generally we open the block with member of dense dimension by fixing the sparse members e.g. below considering C1, P1,Working,Actual are members of sparse dimension cu[More]

How to add new assignment block in opportunity

Category:DefaultRelease time:2015-10-11Views:130

Hi,Experts. I'm a beginer of SAP CRM. I need to add/create a new assignment block similar to existing assignment block 'Details' and display enhancement items in Opportunity screen with SAP crm 2007. I have created new view using Wizard in BSP_WD_CMP[More]

Why do "official" NXT blocks have to be password protected?

Category:DefaultRelease time:-0001-11-30Views:130

Like everyone, I'm new to building NXT blocks with LabVIEW.  The projects we had in mind when we got LabVIEW were to combine and modify existing NXT-G blocks to make them more suitable for our purposes.  However, the first thing I learned was that th[More]

Hot
2010 i5 MBP with 8GB Crucial ram....In January I began getting random shut-downs...The screen would go garbled, then flash 2-3 times, then the computer would shut down...Has happened somewhat infrequently until this week...Happened 4 times on Tuesday [More]
In which table can I find a project (CMOD)and enhancement (SMOD)?? or else please suggest to me how I can find the project assigned to a enhancement? Regards, Shashank.Shashank, It looks like table MODACT makes the link between the project and the co [More]
Hi, I'm wondering if anyone can help: even though I have set my preferences in PS to "always generate preview thumbnails", I will open a window (Mac OS 10.10.2 and earlier - I've had this problem for years now) and see the generic icon for a tif [More]
I am trying to create Hi Res Panoramas and HDR images using Photoshop CS4. It seems that the resulting image is a much lower resolution than I expected (ie the image has been downsized by 50% and changed to 240 dpi). I can do the smame thing on my la [More]
After spending an afternoon at Guitar Center playing the Korg workstations and the Clavia Nord Stage 88, the Nord has a very realistic B-3 organ sim with LED drawbars. The Rhodes and Wurly pianos are really nice. But... the Stage 88 is $3200+. I alre [More]
we have increase the table size without taking care of DR, so sapdata1 becomes 100% at DR site after that applying archived had stopped at DR, after that i manually added datafile using following commands, select * from v$recover_file where error lik [More]
I have a blog with banners and links. These links will work in every other browser except for FireFox. However, a friend of mine has assured me they worked about 2 days ago.All the links that I checked worked fine, as long as JavaScript is turned off [More]
Hi, Does anyone know a way of using a pt tag to render a link straight to the changePassword activity space? I have it hard coded at the moment, but obviously I want to use a tag to make it work between environments etc. the link I want to render loo [More]
Hi All, Can somebody help me in finding the details of responsibility of user logged in. It should include both form and html pages. As of now I am trying to figure out in FND_LOGINS and FND_LOGIN_RESPONSIBILITIES. But FND_LOGIN_RESPONSIBILITIES is n [More]
Hi, I am new to the JTable component... I have set up a JTabel which displays some sample information. I have to display results I get from one of my methods... There is the Swing/JTable tutorial at http://java.sun.com/docs/books/tutorial/uiswing/com [More]