Re: relate4query

by Rush Strong <rpstrong@[EMAIL PROTECTED] > Jun 25, 2007 at 05:15 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">
&nbsp;<br>
<br>
<a class="moz-txt-link-abbreviated"
href="mailto:accademia@[EMAIL PROTECTED]
">accademia@[EMAIL PROTECTED]
> wrote:
<blockquote
 cite="mid:1182790346.828849.209440@[EMAIL PROTECTED]
"
 type="cite">
  <pre wrap="">On 25 Giu, 18:47, <a class="moz-txt-link-abbreviated"
href="mailto:accade...@[EMAIL PROTECTED]
">accade...@[EMAIL PROTECTED]
> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">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) &lt;&gt; '    0'").
Why function  relate4optimizeable return 0 (Not optimizeable) ?

Thank you for the help

Regards
Catello
Italia
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Sorry for the mismatch.
The key expression is str(field1,5) + field2
Regards

  </pre>
</blockquote>
Try:<br>
&nbsp;&nbsp;&nbsp; <br>
&nbsp;&nbsp;&nbsp; <tt>relate4queryset("str(field1,5) + field2 &lt;&gt; '
0'")<br>
<br>
</tt>The entire key expression needs to be referenced in order for
optimization to kick in.<br>
<br>
&nbsp;- Rush<br>
<tt><br>
<br>
</tt>
</body>
</html>

5 Posts in Topic:

relate4query

accademia@[EMAIL PROTECTE

2007-06-25 09:47:17

Re: relate4query

accademia@[EMAIL PROTECTE

2007-06-25 09:52:26

Re: relate4query

Rush Strong <rpstrong@

2007-06-25 17:15:55

Re: relate4query

accademia@[EMAIL PROTECTE