Hey Mike You script totin' bandit you.. You can do about anything in this environment it seems. I'm curious about one part of your solution here. When you in the loop that RBase is running/checking for this file, does it take a lot of the system resources to run this contiual loop? Seems to me I have seen some points on the list in the past about doing this and wondered if this applied here.
Thanks for all the good suggesions Jim Limburg MikeB wrote: > > Steven, > > You can launch IE from within a VBScript called from RBase. This will > give you the context to collect User password and Record the DateTiime to (A > log File or The Database). If you want to pause RBase while this goes on, > you will launch the script at the entry of an RBase while loop that checks > for the existence of a file in the %Temp% directory. The file is created on > Exit from IE within the context of the VBScript. RBase can't be shut down > in a non-violent means when it is in this state, so it has to wait until it > exits the while loop. This is not a hard thing to do. There are means to > pass values to RBase from the VBScript without any ODBC, for example the > file that is created in the %Temp% directory could contain direct RBase > Commands that are written from values collected while in the context of the > VBScript file and then RUNed after exiting the IE session. I recommend that > everyone take some time to learn a little VB by using Scripts. They are > very powerful and handy and a worthy extension to your RBase Toolbox......If > you want to see some examples of passing info back to RB, check out the > Better Message box script on my website. The Better Message Box has example > code from RBase to VBscript and collecting the result back in RBase.... This > would get you started.. If you get hung up on the particulars, email me and > time permitting, I will attempt to help. > > mike > > ----- Original Message ----- > From: "Steven Hoggan" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 03, 2001 4:50 AM > Subject: Controlling Internet access through Rbase > > > Hello all, > > > > I am hoping that I can control access to IE using RBW 6.5++ > > > > I know there are products that allow Internet Usage to be monitored (Proxy > > Server, etc), but my need is more simplistic than that. > > > > I simply want to have the user log in and enter a/the relevant password. > On > > validation the date/time will be recorded, they will be prompted for a > > company reference against which their Internet access will be recorded and > > then IE will be launched. On exiting IE, I want the date/time to be > > recorded again. At this early stage itt's really all very simplistic, I > > hope, and is intended to allow us to make a first stab at accurately > tieing > > Internet usage to the company job-costing process. > > > > My problem stems from the fact that once I have launched IE, I can > > independantly close Rbase and therefore my means of recording the user > > 'logging off' from IE has disappeared. > > > > I hope I've given enough of an outline above for my needs to be clear > > enough. > > > > Has anyone else done something similar? It may be that RBase is not the > > best vehicle for this, so I'm open to suggestions, but at the moment don't > > have a great deal of time to invest in learning VB or whatever (I > > suspect/expect this would be extremely straightforward in VB). > > > > Anyway, any and all replies greatly appreciated. > > > > Thanks > > > > Steven > > > > > > > > > > > > > > > > Confidentiality Notice > > ---------------------- > > > > This message and any attachments is confidential and may contain > privileged > > information. It is intended only for the identified recipient. Anyone > else > > must not copy, use, store or disseminate it. If you are not the intended > > recipient, please email it back to the sender and then delete it from your > > mail system. Thank You. Fitzpatricks. > > > > Tel: +44 (0)141 306 9000 > > Fax: +44 (0)141 306 9090 > > Web: www.fitzpatricks.co.uk > >
