BTREE.EXTRACT PROBLEMS? (OpenInsight Specific)
At 03 AUG 2000 11:32:19AM SASHA wrote:
I using OI-3.7.2 and have migrated to the web using AREV tables.
Currently my web page has an option to allow a user to search a specific column in a table that consists of :
FIRSTNAME LASTNAME AGE SEX
and I have the following code:
open TABLE_DICT to dictVar then
Btree.Extract( COLUMN:@VM:Words, TABLE , dictVar , Keys, '', flag )
This works fine for some searches, however, for certain searches such as a Lastname=smith", the program crashes?!
Is this because OI can't handle specific number of keys returned ?I know that certain results may return over 200 keys…
How would I get around this?
Thanks for any help!
Sasha
At 03 AUG 2000 12:29PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Depending upon the size of key, btree.extract should be able to return thousands of keys.
What is the error message?
World Leaders in all things RevSoft
Pull down this menu to choose whereabouts on the Sprezz site to go
Home Page
What's New
SENL
Download S/LIST
Send mail to support at Sprezzatura
Send mail to sales at Sprezzatura
</FORM
At 03 AUG 2000 01:49PM WinWin/Revelation Technical Support wrote:
Sasha-
The sixth paramater you pass in btree.extract, named 'flag' in your example, indicates what the error might be.
In the system editor, open this program, put the cuursor on the btree.extract call, and press the F1 key. The online help will tel you some of the possible values it returns.
Hope it helps-
Mike Ruane
At 04 AUG 2000 09:03AM SASHA wrote:
THE ERROR MESSAGES STATES:
OpenInsight -- Server ErrorFatal error while processing request
-I AM AFRAID I AM WITHOUT MY PROGRAMMER'S REFERENCE
MANUAL FOR A FEW DAYS SO I MAY HAVE TO GET BACK TO MIKE'S
SUGGESTION AFTER THE WEEKEND.
SASHA.
At 04 AUG 2000 09:23AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
OK - can you run the gateway in local development mode so it goes to the debugger and shows you where the error is occurring?
World Leaders in all things RevSoft
Pull down this menu to choose whereabouts on the Sprezz site to go
Home Page
What's New
SENL
Download S/LIST
Send mail to support at Sprezzatura
Send mail to sales at Sprezzatura
</FORM