When an index is not an index (OpenInsight Specific)
At 12 JUL 1999 12:38:12AM Steve Carmichael wrote:
I have this interesting anomaly in OI.
Deployed my app, got into it and ran it. I realised that the indexes weren't copied across (because I'd removed them earlier).
Deleted the app, went back to OI, created a Btree index, then deployed again.
Still no index.
Back in OI, Database Mgr, List indexes, No Indexes ?
Go to add a Btree again, the Btree is already there !
I can't remove the Btree, because OI tells me there are no indexes.
Nor can I rebuild it, same reason.
So, my questions are:
Can I deploy with indexes intact ?If not, how do I build them in a runtime?How do I set up Sysprog access to my deployed app so I can do these System-type things ?How the hell do I get rid of this Btree that isn't there ???Is it OK to serve a Caesar Salad with a Curry ?Steve (having more fun in the kitchen than the office) Carmichael
At 12 JUL 1999 03:08AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Did you save your database definition after adding the index?
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 12 JUL 1999 08:53AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
There are some issues with deploying indexes in OI 3.7. Revelation has a planned fix for 3.7.2.
For now, I'd recommend swapping out the engine, adding the indexes in the app, then putting the runtime back before shipping the app to the customer.
akaplan@sprezzatura.com
At 12 JUL 1999 06:53PM Eric Emu wrote:
On no account deploy a Caesar Salad with a Curry before removing indexes. Could be a problem with ANCHOVIE_MFS.
Eric
At 12 JUL 1999 08:13PM Steve Carmichael wrote:
I used Andrew's idea of running List_Index, and found a corrupt file, which I then removed. Went back into Database Manager, rebuilt the index and saved the definition. I also put in a button on my System admin form which did the following:
Declare Subroutine Create_Index
Create_Index("1","CATALOGUE","ARTIST","0","1")
RETURN 0
But when I run this from the deployed app, I get a beep from the machine and nothing else. It seems to work OK in dev, but not at runtime. I've swapped OIEngine from dev to app, same result.
A debug steps to the Create_Index statement, but not into it. Can I interrogate any return values from Create_Index, and what do they signify ?
Regards
Steve (anyone for curried emu ?) Carmichael
At 13 JUL 1999 02:20AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Creating indexes on a runtime has been disabled, checkout Kurt's last posting on the subject
amcauley@sprezzatura.com
World Leaders in all things RevSoft