Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do I use Oracle hints?

How do I use Oracle hints?

How do I use Oracle hints?

Hi all,
      Does anyone know how to force Oracle to always use the right index when sorting tables? I know that Hints can be used but how do you implement them in Clarion? I have tried putting the corresponding index name into the External name field on my keys in my Clarion dictionary but it doesn't make any difference. I have also tried implementing the hints in code using Prop:Hint(the hint is set in code whenever a tab is changed) whenever I change tabs on a generated Clarion browse which works sometimes and always throws up this error after changing 2 tabs

Record retreival error
Error: (ORA: - 01480: trailing null missing from STR bind value(-1480))
       attempting to access a record from the BCW.DIARY file.
       Returning to previous window.

(BCW.DIARY is the name of the file I am accessing)

I have my file set to Enable field binding in the dictionary.

I currently set PROP:Hint to the right index whenever I change tabs. Is this the right place to do this? Is there a better embed point in which to set the Hint?

The way my application is currently working means that any sorting on a browse is really , really slow.

Any help would be much appreciated.
Thanks in advance

Gordon McClintock

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close