Hi all

Sorry to do this to you but a site search and a OpenInsight specific search just returned every ref with the word ?records? in it when I asked for the exact word ?%RECORDS%?.

What is %RECORDS% ie it is appearing in my client?s tables with a list of keys for the whole table (excepting itself) and I don?t know why. It doesn?t appear in our development site.

It is being retrieved when you do one of these

<FONT

    Call RLIST( 'SELECT MYTABLE BY MYTABLE_KEY', 5, '', '', '')

Or an Open Record from System editor and refresh.

It is ruining my processing when I want to build an edit table or report containing details from all records in MYTABLE.

So I have to change my Select to this

<FONT

    'SELECT MYTABLE WITH MYTABLE_KEY # ?%RECORDS%? BY MYTABLE_KEY'

I Didn?t have this problem before, and I don?t know why I have it now. Haven?t changed NLMs or upgraded OI recently at the client site. Have done some LH Verifies and every now and again the network crashes.

So what is %RECORDS% and is it ok if I just delete it.

Scott.

keyword: percent records percent

Hi all

Tell me how to make my single and double quotes come out properly please. A bit of a font fiddle and I got the single quotes, but it ate my double quote then.

For the previous post please replace all question marks (not at the end of sentences) with single or double quotes as appropriate. Thanks.

Scott

%RECORDS% is the row used by Quickdex/Rightdex to keep track of keys (hence the 64K limit on Quickdex/Rightdex). Normally you don't see it as quickdex.mfs ensures that it is removed from all select statements.

What you need to do is remove the mfs from the offending table (see SET_MFS) then save the database definition. If you actually want it back then add the mfs back to the table(see SET_MFS) then save the database definition.

The Sprezzatura Group

World Leaders in all things RevSoft

We susepct that what you are using is not actually the single quote (') character. There is character that looks like a single quote but is not. Double quotes (") should present no problems.

The Sprezzatura Group

World Leaders in all things RevSoft

… and then delete the %RECORDS% record or the Select statement will still use it !!

Simon

Rebus

Hi Sprezz

My single quote is not a single quote. Well I don't believe it. MS Word interprets it as single quote and even automatically angles the thing.

Ironically the double quotes I put in

'SELECT MYTABLE WITH MYTABLE_KEY # ?%RECORDS%? BY MYTABLE_KEY'

Got converted to ? but the single quotes I put at the beginning and end, didn't. The difference here was not the key on the keyboard I used but the fact that I put font tags around it in an attempt to get the browser to do courier.

I use the same key on the keyboard for single and double quotes, just add shift for doubles.

So something else is going on. Probably related to the thing that eats the percents in the searches.

Scott.

PS using netscape for this post instead of IE

Hi Sprezz

So I can run SET_MFS and the define database and the set/save env with the runtime, I don't have to set the app to dev mode first?

And just to prove to Oystein I know nothing again,

What are the MFS for. What happens if you have more than 64K records (and therefore keys) in a table. What are right dex and quick dex for. Which bit of the manual are they in? The help for the routines said how you use them but not why.

Scott

Scott,

Quick answer. Didn't read your postings properly. Might be off the mark:

Are you sure you use the plain, old-fashioned double quote - Char(34)? Did you say you copied your text from Word? If you key this ||-like double quote character into Word, Word is prone to change it into other quote character that look like ]. For diciplining Word on that and other matters - see the book Word 97 Annoyances. Recommended!

- Oystein -

Scott,

Sprezz can answer this better than me. But quickdex and rightdex are special, fast indexes - some old Arev thing. Or can they still be used in OI? I never used them at least. They are stored in a special row in the data table itself. (Must be that %RECORD% row.) Because of that there's a limit to how much data they can index. After all a table row can only be 64K. Quickdex is left justified, rightdex right.

An MFS is is a Modified File System (or something similar). It's a layer or shell or thing that sits on top or around the table. Every access to the file goes via the MFS. I assume the quickdex MFS sits there and watches for writes and deletes. Every time a row is written or deleted the quickdex MFS looks at the row data and updates the quickdex. And then it forwards the write and delete to the regular table handling routines.

The normal indexing is also implemented as an MFS - SI.MFS.

One can also write one's own MFS's. I tried once, as an exercise. Guided by Carl or Andrew at Sprezzatura.

- Oystein -

If it automatically "angles the thing" then it is not a single quote. What you have just said is that Word represents what you type in using two different characters depending on whether it is used at the beginning of a string or the end of a string. Single quotes always stay the same .

Are you using the key next to the enter key below the " key?

Or are you as Oystein suggests cutting and pasting from Word?

Here's something pasted from word which was single quoted in the document - ?hello?

and here is a single quote followed by a double quote ' "

The Sprezzatura Group

World Leaders in all things RevSoft

Hi all

Hmm, it could have been the word cut and paste. I use the key with the single and double quote sign on it, which lives one left of the key on my keyboard.

Word quotes

?single quote? more single quotes ?????

?double quote? more double quotes ???

'single quotes' out of word with the angling turned off

"double quotes" out of word with the angling (autoformat) turned off

For fun program word to autocorrect your boss's name to something inappropriate like 'Genghis Kahn' or "Mary Poppins". Quotes out of IE.

where I usually cut and paste from is notepad

I hate it when I get halfway through writing a post and I miss a button on the keyboard and the whole thing gets eaten.

Word 97 annoyances?! - like I need a book to help me, eek. It could be good for one of those tragic laughs where you laugh so you don't cry which must be how some people must be feeling after an uncertain election.

notepad 'single quote' "double quote"

Now lets see how this posts

Scott (no hair)

Hi All

After much digging and poking and guessing - since I cannot find a single acknowledgement in any OI documentation - I found that

1. my copy of MYTABLE has a %RECORDS% and a RIGHTDEX.MFS (field 4 in SYSTABLES]MYTABLE lists the index types associated with MYTABLE)

2. my client's copy of MYTABLE has %RECORDS% and no RIGHTDEX.MFS or QUICKDEX.MFS which explains why the %RECORDS% came up in the refresh, and select lists.

3. I deleted %RECORDS% out of MYTABLE on my copy of the client's database and this solved the problem I was having with the record selects. So far it hasn't crashed anything. I guess I could have used SET_MFS to put RIGHTDEX.MFS back but I don't know why I would want it.

MYTABLE is a small table that is not changed often and is used as a lookup type table ie to mark MY_TRANSACTION types. I use keyed reads on MYTABLE not searches, sorts or selects on any other fields in MYTABLE. Would this situation need a *DEX.MFS to speed things up or is it fine without it. Seems fine without it.

Scott

Scott,

'single quotes' out of word with the angling turned off

So Word "angles" single quotes as well. I didn't know. I never noticed. But I'm sure I've turned it off a long time ago, along with a lot of other "smart" stuff.

where I usually cut and paste from is notepad. I hate it when I get halfway through writing a post and I miss a button on the keyboard and the whole thing gets eaten.

Sure. For the same reason I use Word and cut and paste from there.

But to get Word to behave more like say a programmer's editor, you have to switch off a lot of stuff.

Word 97 annoyances?! - like I need a book to help me, eek. It could be good for one of those tragic laughs where you laugh so you don't cry…

What's wrong with that?

But that book is not just for laughs. You sure get to laugh a lot. And feel good when the author lets his righteous wrath loose. But first and foremost you learn to master a great tool. Word is bloated for sure, but a great tool, and I love it.

…which must be how some people must be feeling after an uncertain election.

Ah - don't worry about the election. All that will be taken care of. See .

- Oystein -

As Oystein has indicated, Quick/Rightdex is an MFS that keeps an ordered list of keys and is automatically used wherever a SELECT is done on the file so that records are displayed in alphabetical or numerical order without the need for any further sorting.

It's use is generally for small code tables where the row count is unlikely to exceed several thousand.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...