daogu

Hi dear All Gurus

i need one solution.

i have three block in in block i have got data and i need

when if user want record post so user click the recod after that he click the button after that record post another block

i have written this query it works but i need if record post then user could not do same post

i have written these code if there is any modification please do it.

Thanks in advance

---

[EDITED by LF: added [code] tags]

---

Answer:hi dear all

still i am waiting for you response please give me response

---

Answer:STILL I AM NOT GETTING ANY RESPONSE

PLEASE

ANY BODY GIVE ME ANS

PLEASE

---

Answer:Please, read the OraFAQ Forum Guide.

---

It appears that you are quite impatient. Asking a question does not necessarily mean that you’ll get the answer (although, you might consider yourself lucky as David (djmartin) will, eventually, see ALL questions asked in the Forms Forum.

However, you should understand that noone here owes you any kind of response. It is just a forum, where people try to help each other under certain conditions:

• they have the knowledge,
• enough free time (nobody here is an employee of the OraFAQ; most of us have a regular job or study and can not / do not want to spend free time answering your (or anyone else’s) questions,
• don’t feel annoyed by constant "I am not getting any response" messages,

• etc.

If your problem requires urgent solution, please, call Oracle Support Service or hire a consultant. Here, on OraFAQ Forum, all you can do is to be patient.

---

As of your question: if you had read the Guide, you’d probably know that code should be properly formatted. Messy posts are difficult to read and some/many forum members simply skip such questions as they don’t want to spend their (precious) free time trying to decipher what someone wants to say.

This time, I have added [code] tags to your message. Next time, please, do it yourself.

You have declared certain variables, but do not use them (for example, CUR_REC, THE_BUTTON_PRESSED). If you don't use them, remove them.

IF condition is always true; therefore, it is useless. Is that on purpose, or did you make a mistake?

Quote:

i need if record post then user could not do same post

I guess that it means that you should mark "BLK_TAS_TEMP" record as "posted" so that user couldn't "post" it again ("post", as far as I understood it, means "copy values from one block to another". Right?). You'd, of course, have to check whether the record is marked or not, and then copy it or not.

---

Answer:Concerning all your 'SET_ITEM_INSTANCE_PROPERTY' commands, why not use 'Current Record Visual Attribute Group' property at the block level?

You have a 'MAKE_BLOCK_UPDATE_ALLOW' procedure that permits access to a block, why don't you create a 'MAKE_ROW_UPDATE_NOT_ALLOW' and apply it to the record from which you are 'COMING'?

David

Related posts:

1. database user create hi i want to create database user from developer...
2. POST-QUERY Hi all, I have a database datablock in my...
3. user of enter button of key board to perform some action Hi Champs, I want to right a code, which...
4. How to grant permission to a user Hi There! Would anyone let me know syntax of...
5. inserting multiple rows using a data block Hi all I want to insert multiple rows in...