XREF and searching for records (OpenInsight Specific)
At 04 JAN 1999 05:34:58PM Greg Hofer wrote:
I'm totally new to OpenInsight and am looking for some help. What I'm trying to do is this. I have a native OI table of people. I created a xref index on the person's name called name_xref. I created a form linked to the people table. I want to enter a person's last or first name on the form and get a list of records matching the name. I am having trouble finding anything in the documentation on how to accomplish this seemingly easy task. Can someone point me to some good examples or to some documentation or provide me with a simple example? I would be very greatful. I'm sure it's not hard but I'm totally stuck. Thanks.
- Greg
At 05 JAN 1999 12:27PM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:
Let's assume you want to place this on the options of the key prompt.
Double click on the key control to display the properties dialog box.
Click on the events button. This will bring up the QuickEvent builder.
In the upper-left corner will be a combo-box with Calculate highlighted. Change this to options.
In the list box, highlight index lookup.
Now, go to parameters (it should be right next to index lookup) and click the up-arrow options button. This will bring up the index loopup options dialog.
In the drop-down, choose the file name. After you choose, dictioanry listing should appear in both left-hand listboxes.
The top box displays which index fields you have. Determine which ones you want the user to search on and click the add buttons to move them to the right hand box.
The bottom boxes tell you which fields the users will see after they made their selections. In your example, choosing by name, you might want to add a social security number or a street address to help your users determine which Joe Bloggs they wish to select.
That's all there is to it.
At 05 JAN 1999 06:22PM Greg Hofer wrote:
Thank you very much for the info. When I select "Index Lookup" for an event option the only columns it displays are ones with a BTREE index. Is it supposed to show ones with XREF indexes as well? I checked the index definitions for my table and it does list my XREF index so I must have it defined correctly. Thanks.
At 05 JAN 1999 09:50PM Greg Hofer wrote:
I found half my problem. The tables I've using were created in Arev. I copied them into a new directory for use with OI only. By changing field names in OpenInsight of the fields that had a cross reference index, I was not able to access them when it came time to create an index-lookup event. Now I try to create a xref index for a field and I get the error "SSP710 Cannot create index for table 'tablename' under different account 'old arev account name'". How can I get the tables into my new OI account? Thanks.
At 06 JAN 1999 03:19AM [email protected] 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 Ltd[/url] wrote:
Sounds as though you hit the old "no periods in column name" restriction.
Well the easiest way is to use the same account name but as we're restricted to eight chars this can be a pain.
The quickest way to do this is to recreate the files in OI, note the DOS numbers then copy the old DOS files over the new ones, so if the old was REV10000.* and the new was REV20000.*, copy REV10000.* to REV20000.*.
World Leaders in all things RevSoft
At 06 JAN 1999 12:20PM Greg Hofer wrote:
Well, I did something wrong. Unfortunately I can't use the old account name as it is too long. I tried what you suggested though. I created a new OI application and created a couple of tables. They began with Rev64. I copied all of the old arev tables which began with Rev53 into this directory renaming them all so they start with Rev64. I was then able to "Add" the tables in the database manager. They all show up but none of them have any fields associated with them.
At 06 JAN 1999 01:23PM [email protected] 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 Ltd[/url] wrote:
Did you remember to do the same for the DICT files?
World Leaders in all things RevSoft
At 06 JAN 1999 07:53PM Greg Hofer wrote:
I copied over the ".lk" and ".ov" files. I assume one of those is a dict file as they were listed when I performed the "add". I also copied over revlocks and revmedia.lk and revmedia.ov with no success.
Thank you very much for your help.
At 07 JAN 1999 05:21AM [email protected] 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 Ltd[/url] wrote:
No, every OI/Rev table is four/six dos files, an LK (primary) and OV (Overflow) for the data, 2 for the dict and 2 for the indexes.
World Leaders in all things RevSoft