OraFAQ Forum: Forms » Failed to query data

Home » Developer & Programmer » Forms » Failed to query data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failed to query data [message #175187]

Thu, 01 June 2006 04:01

juicyapple
Messages: 92
Registered: October 2005

Member

Hi, I have a form with add and query button. When I add new record to it, I can view the data by query out from sqlplus. But I failed to query out the data to show in the form.

What are the possiblity of the condition? I have other forms with same function (add and query) but it works well...

Thanks.

Report message to a moderator

Re: Failed to query data [message #175193 is a reply to message #175187]

Thu, 01 June 2006 04:27

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you receive an error message? If so, which one?

Do you have a default WHERE clause in block properties which prevent newly added record to be displayed?

Can you see records that already exist in the table so this is the problem only with new records, or can you not see anything at all?

Is it possible that one (or more) form items is wrongly declared (for example, there is EMP_ID in the table, but you have an item called EMPID in the form)?

Report message to a moderator

Re: Failed to query data [message #175205 is a reply to message #175193]

Thu, 01 June 2006 04:42

juicyapple
Messages: 92
Registered: October 2005

Member

No error message received.
Where clause is blank.
No one record can be displayed (insert throught form or sqlplus have same condition)
I have checked each item and its column name is correct.

Any other possible cause?

Report message to a moderator

Re: Failed to query data [message #175206 is a reply to message #175205]

Thu, 01 June 2006 04:47

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Does execute query works at all? Did you, maybe, write code into the KEY-EXEQRY trigger which prevents its default task?

Report message to a moderator

Re: Failed to query data [message #175356 is a reply to message #175206]

Thu, 01 June 2006 22:00

juicyapple
Messages: 92
Registered: October 2005

Member

in the datablock, no trigger is created. It is stranged that I can insert data through the form, but cannot query out...

Any idea ?

Report message to a moderator

Re: Failed to query data [message #175357 is a reply to message #175187]

Thu, 01 June 2006 22:27

juicyapple
Messages: 92
Registered: October 2005

Member

emm, I solved the problem by drop the whole datablock and recreate...now the data can be query out...strange!

Report message to a moderator

Previous Topic:	when i call a new form using new_form it is not displaying some times
Next Topic:	DIfference Between

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:28:21 CDT 2024