Marc Collins
|
| Posted: 04/17/2002, 11:58 AM |
|
I thought this was a Memo field vs. Text field issue, but after creating a test database with the Memo field converted to Text, the same problem remained: no matter what search criteria entered for the "problem" field, it returns all records. Any combination of searching the other fields return the proper filtered results, including the corresponding "problem" memo field data.
I am totally stumped by this. I have deleted and recreated the search page and fiddled with every setting I can find, but nothing makes a difference.
CC experts: where should I look? What could/would cause only 1 field to not search properly?
Thanks!
Marc
|
|
|
 |
Alex Alexapolsky
|
| Posted: 04/18/2002, 1:28 AM |
|
1) Is Search Form created with Page Wizard ?
2) Check required box at FProperties/Input tab against your input variable.
|
|
|
|
Marc Collins
|
| Posted: 04/18/2002, 6:57 AM |
|
1) It is a simple modification of the YellowPages example.
2) Checking "Required" makes no difference.
The coding is all standard from your example. Are there any obvious things I could (and probably am) be overlooking? What are the high level reasons 1 field would act differently from all the others?
Marc
|
|
|
|
Marc Collins
|
| Posted: 04/18/2002, 7:02 AM |
|
By the way, I also replied in the newsgroup and attached some code.
Thanks,
Marc
|
|
|
|
Artur
|
| Posted: 04/19/2002, 12:53 AM |
|
Marc,
I suppose it make sense to contact CC support and ask them to look into your project and db.
|
|
|
|
Marc Collins
|
| Posted: 04/19/2002, 7:22 AM |
|
Is CC that finicky? I am using their example design (YellowPages) with a database that reads and connects fine. Something is causing the search to not function on just one field...I wish someone could list some possible causes of that problem.
I have no problem contacting or paying for CC support on this, but if every little thing like this doesn't work, it would make more sense to pay a professional programmer to do it from scratch.
Nervous and hoping I am wrong,
Marc
|
|
|
|
Nicole
|
| Posted: 04/20/2002, 2:17 AM |
|
Marc,
I suppose you're missing something simple. I also use YellowPages example and I perform search on Memo fields successfully. What db do you use? What do you mean that "1 field to not search properly"?
have you modified sample project or db? If yes, what are the modifications?
|
|
|
|
Peter
|
| Posted: 04/20/2002, 3:05 PM |
|
Hi Nicole and Marc
Yesterday I ran again into the same issue. The problem is as follows:
1. I have added a text search on a "memo" field to an already existing search form. It did NOT work. The search returned ALL records in the DB.
2. I made a new search form (same page) for all the fields I wanted. Still it did NOT work. The result was as in Bullet_1.
3. I made a dummy page with the desired search form and copy/pasted it into my existing page. This still did NOT work. The result was as in Bullet_1.
4. Finally I did a complete REDO of the desired page with the new search form. --Now it works fine!
It appears that the new page wizard is the only item that lets you modify a search on a text in a MEMO field.
|
|
|
|
Nicole
|
| Posted: 04/22/2002, 4:04 AM |
|
Hello guys,
could one of you give a link for uploaded project and db? I really want to look at forms settings and see generated SQL.
Or can you print sql and see is memo field added to where clause or not?
|
|
|
|
CodeCharge Support
|
| Posted: 04/24/2002, 6:51 AM |
|
Marc,
While on Search form there’s search field citations with variable name citations, then Entries (result grid form) and Total forms should have input parameter called citations and assigned to field citations. Set Data Type to Memo and Operation to Like’%...%’. While it is done, search will work.
|
|
|
|
Marc Collins
|
| Posted: 04/25/2002, 8:34 AM |
|
Just to confirm this missing parameter was the problem. It is working fine now.
Thanks to the CC support team.
Marc
|
|
|
|
Petr
|
| Posted: 04/25/2002, 10:03 AM |
|
Thanks CC! It was trivial but I missed it too.
IT WORKS!!!
|
|
|
|
