by Rush Strong <rpstrong@[EMAIL PROTECTED]
>
Jun 25, 2007 at 06:58 PM
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
<a class="moz-txt-link-abbreviated"
href="mailto:accademia@[EMAIL PROTECTED]
">accademia@[EMAIL PROTECTED]
> wrote:
<blockquote
cite="mid:1182794798.917874.292750@[EMAIL PROTECTED]
"
type="cite">
<pre wrap="">Rush Strong ha scritto:
</pre>
<blockquote type="cite">
<pre wrap="">
<a class="moz-txt-link-abbreviated"
href="mailto:accademia@[EMAIL PROTECTED]
">accademia@[EMAIL PROTECTED]
> wrote:
On 25 Giu, 18:47, <a class="moz-txt-link-abbreviated"
href="mailto:accade...@[EMAIL PROTECTED]
">accade...@[EMAIL PROTECTED]
> wrote:
I am using a DBF that has the following structure:
field1 Numeric 5 0
field2 Char 5
The DBF has an index CDX. The key expression is str(field1,6)+field2
I use function relate4queryset("str(field1,5) <> ' 0'").
Why function relate4optimizeable return 0 (Not optimizeable) ?
Thank you for the help
Regards
Catello
Italia
Sorry for the mismatch.
The key expression is str(field1,5) + field2
Regards
Try:
relate4queryset("str(field1,5) + field2 <> ' 0'")
The entire key expression needs to be referenced in order for
optimization to kick in.
- Rush
</pre>
</blockquote>
<pre wrap=""><!---->
Thank you Rush for the quick response.
You are right ! If I use the tag's exact key expression Query
Optimization works.
But in the Codebase User's manual (page 90) I read :
"Specify a query expression that contains in whole or in part, a top
master tag key compared to a constant" so I suppose that I may use a
partial tag's key expression (the n first left characters).
Why instead this doesn't works ?
Regards
Catello
</pre>
</blockquote>
Sorry - my answer comes from the FoxPro world; I can't give you a
Codebase specific answer. <br>
<br>
- Rush<br>
</body>
</html>
