I have form that has been working for a year or so that…

cmd=SELECT SOMETHING"

x=UTILITY('CURSOR','H')

rtn=Set_Status(0)

CALL RLIST(cmd,Target_Savelist$,savename,"","")

StatusCode="

If Get_Status(StatusCode) Then

 x=Msg(Parent,StatusCode)

End Else

RCmd=REPORTER.EXE /AP=BTS /UN=BTS /PW=blah /REP=1 /PV=1 /QU=1 /RP=BIP1.RPT'

 x=Utility("RUNWIN",RCmd)

End

Now it will not launch the reporter. I have put a debug into the Else before the x=Utility() and nothing happens.

I have taken the RCmd line and made a shortcut and launched it from the desktop OK. For some reason???? This stopped working.

Am I missing something obvious here?

New machine requiring a client install?

The Sprezzatura Group

World Leaders in all things RevSoft

Did that first. It's happening on three different machines.

As mentioned. I created a shortcut on this desktop and copy/pasted

the reporter.exe blah blah blah line and it ran.

But, as I write this, maybe the drive mapping? At first, I did have to get the mfcoleui.dll. It mysteriously disappeared.

BTW - Not being as familiar with the AREV/OI logic of the SYSLISTs

What is the recommended way of deleting lists since the rlist command

creates more than 1 record/row in the syslist table when saving the list?

TIA

It was not finding the reporter.exe! Works now.

Use the Delete_Save_Select subroutine docced in the on-line help. (Though the logic of changing "GETLIST" to "activate_save_select" seems a little warped…)

The Sprezzatura Group

World Leaders in all things RevSoft

Thanks for the info!

While I have your attention… Let's say I have a edittable

with 3 columns, 1 row. The user can dblclick on a cell and

a character appears (sort like pick A and/or B and/or C). I haven't begin coding this yet but how can I/can I put a bitmap of say a check mark?

And sort of staying in the same topic, what about a drop down in a cell? I haven't searched through the discussion threads yet but will.

Regards.

This sort of funtionality requires a newer version of the DataTable than is distributed with OI - meaning it can't be done. Protoview do have this functionality - Donald Bakke has more experience with the newer version, it might be worth waiting for him to chip in here.

The Sprezzatura Group

World Leaders in all things RevSoft

Maybe I jumped the gun on this one.

savename=@STATION:"*RPT1"

When the list is saved with the CALL RLIST(cmd,Target_Savelist$,savename,"","")

OI puts 3 items in the SYSLIST table.

1. BMC*RPT1 (this is savename)

2. Q*BRUCE*BMC

3. W*BRUCE*BMC*12078.520069444

The Delete_Save_Select(savename) only clears the BMC*RPT1

I'm assuming Q=query ComputerName User then

W=???? ComputerName User Time??.

I'd rather these go away too!??

Bruce,

What is that edit table for? Is it tablebound? Are you sure you cannot use something else completely? Like 3 edit lines and 3 check boxes or bitmaps???

- Oystein -

Oystein,

Well the form is max'd out on controls. (Yikes, hate admit it but the client HAS TO HAVE everything on one page)

So I made and edittable 3 columns and 1 row. I am planning on using the dblclick to put in an 'X' in the cell but then thought maybe a check mark would look nicer. No biggie, the X will work.

Bruce,

Well the form is max'd out on controls. (Yikes, hate admit it but the client HAS TO HAVE everything on one page)

Real control freaks in other words.

In the app I'm developing now I was far beyond the max from the start. What I hate to admit is all the time I spend getting a tabbed multi-page interface to work.

So I made and edittable 3 columns and 1 row. I am planning on using the dblclick to put in an 'X' in the cell but then thought maybe a check mark would look nicer. No biggie, the X will work.

Is one symbol all you want in each cell? If you can find some font with a check mark-like symbol you could set the font of the edit table to that font. Wingdings has a symbol you might use (a "V"-like thing, but without a frame). Note! You must make sure your clients have got that font too. (But Wingdings should be OK.) (You must also find out which character that check mark-like symbol corresponds to in a normal font, because it's that normal character you have to put in the cell.)

Btw - can you live with having that row of 3 cells as a column instead? Then you can use a listbox with bitmaps instead of an edit table. It's still just one control.

- Oystein -

Good joke.

This is what I did in the dblclick event of the etable… Works fine.

eTable=.SELECT_TBL"

pos=Get_Property(@WINDOW:eTable,"SELPOS")

acode=Get_Property(@WINDOW:eTable,"CELLPOS",pos)

if acode then

 Rtn=Set_Property(@WINDOW:eTable,"COLDATA","",Pos)

end else

 Rtn=Set_Property(@WINDOW:eTable,"COLDATA","*",Pos)

end

The edittable has 3 columns A,B,C and 1 Row. I set the

text width to 3, centered for each.

I'm done.

]In the app I'm developing now I was far beyond the max from the start. What I hate to admit is all the time I spend getting a tabbed multi-page interface to work. I pretty much followed it verbatum

and have done several since.

Hope this helps. Thanks for the response(s). (All)

Hi All

I have clients who want everything on one page. They insist on using 800x600 resolution even though most of them now have 21" monitors because they said they couldn't read the OI Forms.

Other perfectly normal things that clients do: Change their mind about what they want after you built it. Doesn't matter if you did a specification with detail (including pictures) of what you were going to build and they ok'd it.

They won't tell you why they ask for particular function. Usually when I extract from them the why, I can give them something quicker and more appropriate, usually because it is already there.

And my favourite: Our company gets paid on completion of a job and user acceptance, so they don't test or accept anything, and they give me new things to do at such a high rate (each new thing is naturally the most important thing) that I cannot finish anything.

I'm still bored though.

Scott, LMS

Bruce,

The way I implement the multi-page interface is with MDI, so it's not the most straightforward one. I have one child per page. (The child is slightly larger than the MDI client area, and maximized, to make it blend seamlessly with the frame.) To save resources only one child is open at a time. So I have code saving and restoring fields when the user changes between pages.

To make it more difficult I use the same frame and programming for several tables, and several instances of the frame can be open simultaneously (e.g, in master-detail relationships). Also the frame and its programming handles several modes (e.g, data entry, query, browse). And so on.

So I brought it onto myself.

- Oystein -

These seems to be related to functionality that was implement really nice in ARev but not at all in OI. These items are here for the recently used query list. OI will eventually delete these records, in theory.

The Q record is your station and user names. This record holds 10 W records, representing the last 10 selects.

As each select is saved and added to the list, OI will go and delete the oldest W record in the Q. This explains why some selects seem to take longer than they did the last try. OI has a large amount of W records to delete for the oldest select.

You shouldn't get stray records there, however the system does use the full @STATION value, which means if session info (MYSTATION*XXX) is used, the next time you log in, you might not get the same XXX values, so it creates a new Q record.

The W records are treated list list records, so it would append *2, *3, etc. for the various parts.

The Sprezzatura Group

World Leaders in all things RevSoft

Janet,

I assume then that you get to bill for the change order requests?

[email protected]

SRP Computer Solutions, Inc.

Hi Scott ..

For the past umpteen-tity years I've been in the same spot. I rarely say "No" - just how much .. or "Start piling $100.00 on the table and I'll tell you when to stop." Seriously, though, old tatty AREV and PICK were a little easier (it was more difficult for their eyes to get bigger than their tummies). Windows is a whole different critter. I had a client of mine kvetch last week. He decided to set his screen resolution to 800 x 600 .. no biggie, but when he chose the "Large Fonts" option, then some of the text labels and the tab headers were truncated. Since there is an option in the Display properties to select almost any magnification factor for fonts there's no way to write code to support this in a generalized fashion.

Well…he got a choice .. use standard size or smaller or learn to figger out what's there .. that's the name of that tune. If he really has to have what he wants, then … I'll be glad to do it … at $125.00 / hour FOREVER …and I'll be glad to bill him monthly and he can treat it as an annuity.

Don Miller

C3 Inc.

View this thread on the forum...