[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Rookie Btree.Extract question (OpenInsight Specific) ====
=== At 17 MAR 1999 08:49:26PM SBerger wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I have the following code in a script that will be a custom internet procedure:



open 'PROTOCOL' to hCur else

return Inet_Msg(request, 'An error occurred while trying to open.')

end

open 'DICT.PROTOCOL' to @dict else

return Inet_Msg(request, 'An error occurred while trying to open dict.')

end

search_string=PI':@VM:'123456':@FM

Btree.Extract(search_string,PROTOCOL,@DICT,'','','')

debug



when I execute this code, @reccount is ''. I know that there is a PROTOCOL table and in that table there is a field called PI and that column has the instance 123456. In fact it has 8 instances of 123456.  I have alternately tried to do this with an RList command as well as playing a bit with the REV_SQL procedure all with the same result.



Help me OI masters, your my only hope.



S
</QUOTE>
----

=== At 17 MAR 1999 10:55PM Jonathan Bird wrote:  ===

<QUOTE>]]Btree.Extract(search_string,PROTOCOL,@DICT,'','','')<<



Should be:

Btree.Extract(search_string,PROTOCOL,@DICT,KEYS,'','')

 and the variable KEYS will contain the @VM delimited keys, which you can count if you want

J

</QUOTE>

----

=== At 18 MAR 1999 02:18PM SBerger wrote:  ===

<QUOTE>Thanks

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=A3BAB2E7234C336F85256738000486B5|View this thread on the  forum...]]