button search [message #574078] |
Sun, 06 January 2013 14:34 |
|
goldray
Messages: 108 Registered: December 2012
|
Senior Member |
|
|
Hi,
I have a tabeau that contains the data on my database, and I above table a "search" button that allows you to search for my DB, the problem must be the Result shown in the table or it already contains records!
what should I do?
|
|
|
Re: button search [message #574082 is a reply to message #574078] |
Mon, 07 January 2013 00:07 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I don't understand a word you are saying.
- What is a "tabeau"?
- "Search for my DB" is, I suppose, wrong terminology (I noticed that in your previous messages, but didn't pay attention): I *think* that "DB" is, actually, an Oracle "table" that resides in your schema. Is that so, or are you really searching through the whole database?
- The last part of that sentence ("the problem must be ...") means what, exactly?
So, what should you do? Try to compose a meaningful and understandable message, for beginning.
|
|
|
|
|
|
|
Re: button search [message #574117 is a reply to message #574113] |
Mon, 07 January 2013 05:21 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You are right - I don't understand you at all ...
goldray
the table already contains the result of "execute_query"
Which table? Who/what put execute_query results into that table and, above all, why?!?
goldray
when I press on the "search" button the new result will be displayed in the table
Nothing is displayed in a table. Table is a database object; it contains data. Front end (whether SQL*Plus, TOAD, your Forms application, whatever) DISPLAYS data stored in a table. So, is it the old wrong terminology issue? Is your "table", actually, a "tabular form layout" form block?
What do you need that cursor for? Are you SURE that it really does something (single quotes around :search.item)? If it is a data block, inserting records from a cursor into it will bring new problems (different FRM- error messages, such as "Do you want to save changes", possibly unique constraint violation and similar).
Unless you convince me opposite, I think that what I posted in the message #574111 is still valid. You enjoy in making simple things complex (and I'm unable to get the point).
|
|
|
|
|
|
Re: button search [message #574130 is a reply to message #574123] |
Mon, 07 January 2013 06:23 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
The where clause you want to be applied to the select statement that forms issues to the database.
Since your requirement still isn't clear to us we can't really tell you what to put.
|
|
|
|
Re: button search [message #574181 is a reply to message #574169] |
Mon, 07 January 2013 12:45 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
goldray wrote on Mon, 07 January 2013 11:01
how I can use the apostrophe ' ?
You would use 2 apostrophes to represent one.
instead of
|
|
|
|