Question 1. Is there an equivalent to Pick's QSELECT in OI (Without writing one myself)?

Question 2. Can you use SELECT INVOICE PART_NO then LIST PARTS? (I.E. In Pick (undocumented)you can do this whereby your returned cursor is a list values from the column you specified. In the above you would not get a list of INVOICE keys but a list of PART_NO's. The caveat is that you can get and duplicates etc. but if you know your data…)

Question 3. How do I add a key (row) to a SYSLIST item so that the system handles the 32k limitation automatically? Can I do this without writing my own id*seq# ?

Thanks.

Question 1. Is there an equivalent to Pick's QSELECT in OI (Without writing one myself)?

The last of the ARev Developer's Series Disks contained a program called FSELECT, which should be what you are after. I believe source shipped with the program.

Question 2. Can you use SELECT INVOICE PART_NO then LIST PARTS? (I.E. In Pick (undocumented)you can do this whereby your returned cursor is a list values from the column you specified. In the above you would not get a list of INVOICE keys but a list of PART_NO's. The caveat is that you can get and duplicates etc. but if you know your data…)

Once a key list is in memory, it's not associated with a file. If you are using Basic+ selects (REDUCE and so forth) then you have to remember to use the USING and/or ASSIGNING keywords.

Question 3. How do I add a key (row) to a SYSLIST item so that the system handles the 32k limitation automatically? Can I do this without writing my own id*seq# ?

Depends on what you want to do. If you know the SYSLIST key, then you can just insert data into the record. The list processors do not care how long the record is after creation.

The Sprezzatura Group

World Leaders in all things RevSoft

Apologies - we misunderstood 2. You cannot use the contents of a field as the key for a select list as you have described. Rather you would have to use a SQL select along the lines of SELECT FILE1.FOREIGN_KEYS FROM FILE1 and use the resulting list in your program. Or write a simple program

The Sprezzatura Group

World Leaders in all things RevSoft

Actually, the FSELECT program on the DUDS disk is designed to do just that. It allows you to specify a field name to use as the result list, so instead of having an active cursor of @ID, you would have an active cursor (or at least a saved list) of FIELD_43.

The Sprezzatura Group

World Leaders in all things RevSoft

Ahh thanks for clarifying that!

The Sprezzatura Group

World Leaders in all things RevSoft

Question 3. How do I add a key (row) to a SYSLIST item so that the system handles the 32k limitation automatically? Can I do this without writing my own id*seq# ?

Depends on what you want to do. If you know the SYSLIST key, then you can just insert data into the record. The list processors do not care how long the record is after creation.

Can you give me more details here.

If I….

 select reallybigfile

 loop

    readnext...

 until

    if key matches my criteria

       pf=another.key.that.is.stored.on.Reallybigfile.item

       write pf on SYSLIST,@station

    end

 repeat

What if item @station on SYSLISTS reaches the 32k boundary?

(BTW - I need to do this on OI 16bit too)

In both systems there is really no reason why you can't go to 64K but if on OI16 you are going to exceed this you'll need to split it into multiple list records, *1 *2 etc.

The Sprezzatura Group

World Leaders in all things RevSoft

Sprezzatura - are you talking amongst yourself?

Perhaps if you included a "real name" it would help us old timers…

Yes we are. Old timers should recognise who's talking See you at New Orleans? If so you gonna bike in?

The Sprezzatura Group

World Leaders in all things RevSoft

Well I figured that and that was my original concern. (read…not wanting to reinvent the wheel).

A questions pops up though. I had thought up until 2 weeks ago that I could store 64k worth in one item in an LH table. I had to however rewrite with a seq# because the routine blew up reading into memory 32k+. Can anyone provide the specs?

It depends how you're storing it is the bottom line. If you're using a pre-32 bit driver then no - as the filing system had no clue records could be ] 64 K. You can find the DUDS at http://www.revelation.com/SOFTWARE.NSF/76c3ba2a4214609785256421006d5324/f4747aeb1047084a852563fb006949eb?OpenDocument

The Sprezzatura Group

World Leaders in all things RevSoft

Doubt if I'll make it. Taking three weeks off in July to bike around in NorthWest USA…!!!

Dave

Dave,

When you say "bike", are you talking about bicycling or motorcycling? If it is bicycling and you want to get a jump on the season, I highly recommend Maui, I can take you on some awesome rides! Here is a sampler: Go Cycling Maui.

Aloha!

Pat

I ride a BMW Motorcycle. About 11,000 miles per year.

Thanks for the invite. I was in Maui in 1980 and loved it.

Dave

PMFJI, but I appreciate the info.

Next major vacation my family take we will GoCyclingMaui! Didn't know something like that exist and it is so appealing. See Hawaii and biking.

THANKS!

Ray

There is also an Arev Utility QSELECT written years ago by Mike Pope. It was distributed through the UK Arev user group…did not Spretzz put a copy on one of their utility disks?

It makes a list of keys as you describe, and is 64K proof, creating 'overflows' in Lists as needed. It is an Arev utility, but most likely will work OK in OI.

Let me know if you want more info.

View this thread on the forum...