Hello:
Is it possible that there is a syntax error in the SQL or some other reason
that the execute method is failing? Try executing the SQL statement from
SQL Plus (or other tool) to verify the syntax. You may also want to check
the succeeded() method of the data object to see if it is failing, or not.
It may be that the data object is not succeeding and that the last results
are being reused.
Anyway, hope this helps.
Regards,
Bob
-----Original Message-----
From: DEVSUPPORT DEVSUPPORT [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 26, 1999 9:59 AM
To: [EMAIL PROTECTED]
Subject: [ND] Search not working when DO changed to upper
Hi there. I have a Dataobject, main page, and a search page that orginally
works fine. When I customize the SQL in the Dataobject and put an UPPER
oracle function on one of the fields used in the search page it no longer
works. Whatever I type in on the search page brings ALL the results back on
the main page instead of the correct search results.
Why is this?
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
