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:

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


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

]]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


At 18 MAR 1999 02:18PM SBerger wrote:

Thanks

View this thread on the forum...