Volume 4 Issue 2
Contents
1. Date ZD 6 Tabs Purpose Commuter module for 2 4 2Spaces C 3Spaces Note the shaded check to show there are items checked in this subsection Now we re going to add a click event to the BTN OK and the BTN CANCEL so expand these U1 gt Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 16 of 44 TEXT_1 STATIC BTN_OK PUSHBUTTON 97 Commuter Program Generator Cancel CLICK C1 corFocus Please note that HELP 2 is signed LOSTFOCUS SOLELY to be NOTES used with events OMNIEVENT added removed 13 SUBMIT by Skeleton and WINMSG expects all commuter calls CLICK Ns the form GOTFOCUS STPROCEXE DEM 1 GWINDOW If LOSTFOCUS will not report NOTES other events nor will it remove them Options Standard header Delete existing commuter if UNchosen Include DAIN Comm Init Author e T abs D ate D AME 2Spaces Purpose Commuter module for Zw 3Spaces gt And double click the CLICK event O Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 17 of 44 SPREZAATUR Je Commuter Program Generator 227 TEXT 1 STATIC BIN OK PUSHBUTTON CLICK GOTFOCUS HELP LOSTFOCUS NOTES OMNIEVENT SUBMIT WINMSG BTN CANCEL PUSHBUTTON CLI2. end else call msg you didn t escape from the message end return I A sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 42 of 44 SPREZATURA Because it s so much fun almost as much fun as being in Vegas you can work out the other key scan codes for yourself If you use a Microsoft ergonomic keyboard with the keys split at funny angles this activity can take up to seven weekends You also tend to see everything as italics eight becomes infinite and so on As my fine old grandfather once said as he slaved over the card reader in the Vax PDP 11 in his garage used to catalogue his home brewing beer inventory You can always tell the pioneers they re the ones with the arrows in their backs Celebrity Interview Bill Caisley Revelation EMEA Support Who are you Bill Caisley Who do you work for The wife and kids But seriously Revelation Software What is your role in the RevSoft community Tech Support for Revelation UK I am committed to gleaning as much knowledge as possible on the full Revelation product range How long have you been involved with RevSoft Since June 2003 With Multi Value systems since 1990 Which products do you use Arev and OI the moment What do you most like about RevSoft products 3 The simplicity and power Also the way the products are evolving an
3. 41 Celebrity Interview Bill Caisley Revelation EMEA 44 2 2 tent tentent 42 fetal eem Reese e eR Red 44 CS PAYA Mast 2225 44 a e 44 Sprezzatura Electronic Newsletter Volume 4 Issue 2 NO MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 3 of 44 SPREZATURA Welcome Welcome to the latest SENL from Sprezzatura although arguably that should be the Enl from Sprezzatura or the latest SENL I suspect I ve been hanging around comp databases theory too long and the normalization debates have gotten to me What have we been up to Sprezzatura have been very busy over the preceding months a lot of the sort of work we were doing has been invalidated by the introduction of 32 bit OI you ll recall that we were successfully marketing a set of add on tools for OI that delivered true 32 bit functionality in 16 bit OI so we ve been refocusing somewhat Our core business of being the consultant s consultancy has continued of course we ve solved long standing GFE issues for clients customized aspects of the tool set in a way that is possible only with a very in depth knowledge of the internals provided tools for tracking Universal Driver performance delivered AREV compatibility tools for new converters provided in depth XML tools for clients allowing
4. Next execute the following in the System Editor Exec line or the System Monitor RUN DECLARE FCNS DLL UXTHEME Now to use in we simply do this declare function SetWindowTheme get Property hwnd get Property window GRP LINE HANDLE call SetWindowTheme hwnd One other thing to note here If you try this on a pre Windows XP system Like Windows 2000 Windows 98 etc you ll hit the debugger This is because uxTheme dll does not exist on those systems so you should check for its existence via the isLib function before you try and use it E g declare function SetWindowTheme get Property isLib jf ishib UXTHEME DLL then hwnd get Property window GRP LINE HANDLE call SetWindowTheme hwnd end Securing Menus via S MS The latest addition to the Sprezzatura utility fold is S MS Sprezzatura s add on menu security module for OpenInsight This grew out of a custom project for two different clients One who wanted to be able to attach a different menu to a window at create time and one who wished to be able to individually secure those menu items on a case by case basis Thus was born S MS OO UJ Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 39 of 44 SPREZATURA One of the few areas of lack of flexibility in the current ve
5. REZ ATURA 45 St Mary s Road e Ealing LONDON W5 5RQ Tel 020 8912 1010 Fax 020 8912 1011 info sprezzatura com SENL November 2004 Sprezzatura s Electronic Newsletter For Revelation developers by Revelation developers MARING DATABASES HAPPEN http Avww sprezzatura com Registered Office 31 Horn Lane London W3 9NJ Company Number 2339731 VAT Number 521 7242 75 2010 Sprezzatura Ltd Rights Reserved Page 2 of 44 SPRE Contents EE 3 Voile RENE CSR le 3 oc E T ce cnr Mee 3 Revelationis MOVEMENTS I A A 4 5 Skeletonifon Ll Delapsus Resurgalmi ss ottenere OOOO O M 6 Commuting our Execution OO E 6 WE tac aee eem i dra Kit ing IR Ke 225 21 Tie Wniversalinive nl let eene eem 27 Errors commonly associated with the Universal Driver esent 28 5 0151 3 0 Changes to license Martyn Phillips 28 Volume MFSs Aaron Kaplan Managing Director Sprezz Inc 30 Openinsight XP Carl Pates Technical Director Sprezzatura Group 34 EmablingiVisualistylesfin Om MN te eer 34 Turning off visual style for a control l Ate o EE 35 RUE 38 Anumportantimeteralb out 7 39 ren DEE
6. That program then becomes the next program in the chain Your program does what it needs to with the data archives it compresses encrypts validates adds tracking information or whatever purpose you can come up with and then calls the next program down the chain As the next FS in the list is called the preceding programs may have added or removed various parts of various sections of the file Your MFS does not care what happens to the data above itself on the chain nor for that matter what really happens to it down below You should be able to see that this is a layered set of calls giving each operation a pre and post call You should also see how this allows you to modify the behaviour of the base system This is why it s called a modified filing system That was a quick and brief explanation of the simplest form an MFS can take The next form is more complicated than that In this form we ll use the MFS concept to allow our MFS to act as a BFS The programming behind this is very simple but the concept and potential is what takes time to get used to What we do is set up our program to act as the base filing system for a volume which places it on a par with RTP57 RTP52 and RTP59 LH LNK and ROS Our program then receives all calls for access The trick to making this work is calling the appropriate file system yourself You already know how to pass to the next FS list In this format you simply call the actual base fil
7. UW Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Create Event Calls 2Z_Menu_Secunty Does Menu Exist On Source Window Was Callback Function Given Install Menu on Target Window According to showMenu Flag Page 40 of 44 Check Each Menu Item and Pass to Callback Function Callback determines if Enabled Visible lave all menu items been processed So as you can see the operation is incredibly simple you simply place a call to the routine on the create event of the window or on a promoted create event if appropriate and take it from there S MS is licensed on a per developer copy of Openinsight basis and is priced at less than a day s consultancy For further details please Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd Rights Reserved Page 41 of 44 Eric the Emu s AREV Trips Recent discussions in the Revelation forum well this has been delayed Ed http www revelation com 85256DB80017688B nsf 0 DAA27C2893F8210085256C02003A217A Ope n from 26 July 2002 hail back to one of the emu s long lost utilities There are some early versions of AREV and REVG which don t really provide a mechanism to reveal the last keystroke pressed Once upon a time possibly on an adrenaline charged Monday the enquiring emu was faced with several angry payroll officials who insisted t
8. 22 wINLOCK ig 22 wiz AREVCONVERSION ZZ ML SCHEMA System Editor l Stored Procedure Debug T ables Stored Procedure Executables Reports Scripts Launch App And Shift Enter or Shift DbICIk OO Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 9 of 44 SPREZATURA 7 Commuter Program Generator Please choose the windows you want to add edit commuter modules for then press OK ok Please note that this screen is designed SOLELY to be used with events added removed by Skeleton and expects all commuter calls to be of the form APPID STPROCEXE WwINDOW If will not report other events nor gt will it remove them E133 EDITFRM Standard header Delete existing commuter if UNchosen Include OlwIN_Comm_Init Author Tabs Date zD z 2Spaces Purpose Commuter module for 22w 3Spaces s The ZZ_SKELETON window appears and the main listbox populates with all of the Windows in the current application The Options as the bottom allow you to determine whether any existing commuter logic should be overwritten although this is not implemented currently whether OpenlInsight Window Common ought to be included in the program See http www sprezzatura com senl senl18 htm _ Toc447361865 and whether the resultant commuter program should use tabs or spaces for i
9. DLL and the so called Common Controls TreeViews ListViews Tabs and so on from ComCtl32 dll With the advent of Windows XP Microsoft created new version Version 6 of ComCtrl32 dll which handled all the processing for both types but it also hooked into the services of uxTheme dll so that all these controls would now adopt whatever visual style was chosen by the user However so that no applications were broken the default behaviour in Windows XP was to use the old way Visual Styles would not be used for an application unless it was explicitly set to do so Enabling Visual Styles in OI Enabling Visual Styles in OI is actually quite simple but we have to let Windows know that it s OK to do so as Ol itself currently does not implement them We do this by creating an Application Manifest file which is simply an XML document that describes an application and any components required to run it When an application creates forms and controls Windows XP looks for a manifest file to see if it should use ComCtl32 dll version 6 to create them or if it should use User32 DLL and ComCtl32 dll version 5 to draw the controls instead Normally these manifest files are compiled into resources and embedded directly into an application s executable file along with bitmaps icons and suchlike However they may also be created as standalone files in the same directory as the application they apply to All we need to do is adopt the approp
10. a form as you can see in the example below UI UJ Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 36 of 44 SPREZATURA Filter Selection Filter Selection Select the type of filter you want to use followed by the Filter options and the destination ES For the results Filter Option statement x Enter an RjList SELECT statement in the box below and click Ok to execute it IF you want help building your statement click the options button at the side or press F2 Statement SELECT 100 SYSREPOS i Destination Active Window Active List Saved List Enter a list name here Now take a look at it with XP Visual Styles enabled it s almost completely invisible except for the new style rounded corners at each end O UJ Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 37 of 44 SPREZJATURA Filter Selection Select the type of Filter you want to use Followed by the Filter options and the destination For the results Filter Option SELECT statement v Enter an RjList SELECT statement in the box below and click to execute it IF you want help building your statement click the options button at the side or press F2 Statement SELECT 100 SYSREPOS BY ID Desti
11. that writing commuter programs one program to encapsulate all of the logic associated with an entry form was a great idea Sprezzatura even Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 7 of 44 SPREZATURA released a utility for subscribers to REVMEDIA called SKELETON that made this ideal easily achievable Then with the introduction of Openinsight it seemed that people moved away from this idea Firstly people used lots of individual events Then when they realized what a bear this became from a deployment perspective they moved to using Omnievents as a pseudo commuter we were guilty of this too Finally they came to the realization that the old commuter idea was actually still as valid as ever and commuters are once again with us With this in mind Sprezzatura decided to revisit the idea of the commuter program generator only this time with a slight difference Rather than make the utility available only to those who subscribe to a paid journal we ve decided to make it available as a source code release to the Revelation Community under a modified version of the GNU GPL license We re doing this because we believe that there are others in the community who could add value and by so doing help us all in our mission to deliver better software whilst becoming more productive But before looking further at the distribution of the s
12. them to go above and beyond that which is possible with the core toolset and encapsulated some very cool OLE technology in OI systems Of course we haven t been neglecting our existing user base especially our S Web users For those of you who aren t familiar with S Web it is our scaleable middleware solution for high performance web sites back ended with AREV or OI We have new versions planned for Q2 next year that will deliver even more bang per buck but in the meantime we ve revised the pricing to make it more attractive to existing developers with a lower upfront cost and a weighting towards actual deployment Our biggest S Web site is currently delivering upwards of 2 million hits a day so we re very confident of the scalability You can read about a couple of our success stories at TV Shopping Network Huge Growth With Small Costs Courier Services Firm Brings Mission Critical ARev Application To The Web Using OpenInsight Sprezzatura and The United States National Weather Service To speak to someone about how S Web can help your web enablement just drop us a line at sales sprezzatura com Office Move For about a decade we ve been based in the same building in Ealing a town on the outskirts of London situated conveniently for London s Heathrow airport We love the location not least because it IS so convenient for Heathrow enabling us to get to most of our US customers for less than the Sprezzatura Electronic
13. to say that the system worked perfectly with licenses less than 12 months old being upgraded without any communication with us other than downloading the software itself from our web site Those people with older versions of S List 3 x were as expected prompted for an installation code and those people needed to contact our office to obtain the said code As a good will gesture these have been supplied free of charge during this trial period So what does this mean for our existing and new users How you will be affected depends greatly on when you bought your original S list product license OO MN Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 29 of 44 SPREZATURA S List bought and supplied as version 3 01 44 or later You will not have to do anything You have and will continue to benefit from free support and maintenance for the 12 months following supply of your original S List installation files and your unique installation code At the end of the 12 month period you will have the opportunity to renew your support and maintenance as detailed below S List 3 x bought prior to version 3 01 44 You will need to contact our office to obtain a new installation code to install the latest version of S List As a goodwill gesture we are continuing to provide all S List 3 x customers with FREE upgrades and maintenance until the end of the year 31st Dec
14. yourself We ve continued to work closely with both end users and developers globally The past 12 months have seen Sprezz personnel in the UK Europe America and the Caribbean working with some of the Sprezzatura Electronic Newsletter Volume 4 Issue 2 d MARING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 6 of 44 SPREZATURA biggest and smallest names in our community We always try and ensure that our pricing is competitive with market rates and we make sure that if you re not geographically adjacent to our resource that you don t suffer because of it So if you ve got any projects that you feel Sprezz expertise would be useful on drop us a line at sales sprezzatura com As ever we ve been busy creating new product sometimes as an internal project that just grew and other times as a joint project with an existing client were the client pays a lesser amount to develop a utility they need so that we can then offer it to others in the Rev community One such routine is our Menu Security Utility S MS which we review in an article later in this issue We re also pleased to finally have caught up on documenting our S List 3 x product This coincides with an alteration to our licensing and support policies so we d refer you to the article on this too Those of you who aren t yet S List users might like to follow the links to check the documentation to see if it could be of interest to you Fi
15. CK LI cus HELP LOSTFOCUS NOTES Author Date ZD Purpose Commuter module for 2w Wm And collapse them again EL Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 18 of 44 SPREZATURA 97 Commuter Program Generator Please choose the windows you want to add edit commuter modules for then press OK Ok 27 SKELETON DEMO 4 ZZ_SKELETON_DEMO WINDOW Cancel 19 LB wINDOwS LISTBOX TEXT 1 STATIC Please note that BTN_OK PUSHBUTTON e lend is CANCEL PUSHBUTTON SOLELY to be 1 CHK DELETE CHECKBOX Gun ah RUPEE EB HEADER EDITBOX added removed 145 TEXT 7 STATIC by Skeleton and 14 TEXT 4 STATIC expects all FR CHK COMMUN CHECKBOX ace RB TABS RADIOBUTTON GROUP 1 GROUPBOX STPROCEXE ZZ TABLEBROWSER NINDDW If ZZ UTILITY AREVCONVERSION L will not report ZZ UTILITY DLL other events nor gt will it remove them Options Standard header Delete existing commuter if UNchosen 7 Include OlwIN_Comm_Init Author AMc Ze T abs Date zD m Purpose Commuter module for 22w 2z 3 Spaces Finally we ll add a CHAR event and a CHANGED event to the HEADER OO Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserve
16. G 3 ZZ LICENSING 3 ZZ MAILSHOT 2 72 PROMOTED EVENTS j ZZ READ CODING 22 SKELETON 27 SKELETON DEMO WINDOW LB WINDOWS LISTBOX TEXT 1 STATIC OK PUSHBUTTON BIN CANCEL PUSHBUTTON CHK DELETE CHECKBOX iil xi Standard header Delete existing commuter if UNchosen 7 Include OlwIN Comm Init Ze Tabs 2Spaces 3Spaces Author 40 Date Purpose Commuter module for Zw This expands all of the controls the Window Now we re going to double click the ZZ SKELETON DEMO WINDOW entry to see the events for the Window MAKING DATABASES HAPPEN Page 11 of 44 FATURA Please note that this screen is designed SOLELY to be used with events added removed by Skeleton and expects all commuter calls to be of the form APPID STPROCEXE WINDOW If will not report other events nor will it remove them Eprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd All Rights Reserved Page 12 of 44 SPREZATURA ACTIVATED 13 RRANGEICONS 23 BUTTONDOWN Please note that BUTTONUP this screen is designed See SOLELY to be EE used with events CLEAR added removed I2 CLOSE by Skeleton and CREATE See all 4 commuter calls SHEET 1 APPID GENEE STPROCEXE ined WINDOW If DSOCOMMIT will not report DSODELETE other events nor xf will it remove them Options St
17. LF ACTIVATED Return value in Control Property Index lookup Close window Read the row Write the row Clear the form Delete the row Internet You ll notice that ZZ SKELETON has inserted STPROCEXE name of SKELETON_ WINDOW It has done this so as not to overwrite a routine with the same name as the window If we now go to the UJ MN Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 24 of 44 SPREZATURA system editor we can open the routine SKELETON_ WINDOW or more accurately in this case SKELETON_ZZ_SKELETON SYSPROCS SKELETON 22 SKELET unction Skeleton Zz skeleton ctrlEntID branch pareml parem2 param3 parem4 paremS param Date 17 November 2004 Purpose Commuter module for 22 SKELETON Notes Insert Logical WinID BRUindow Insert Comm Init RetVal True Declare Function Get Property Set Property Get Repos Entities Utility Msg Generic Event Declare Subroutine Get Property Set Property Utility Msg Locate branch In ACTIVATED CHANGED CHAR CLICK CREATE Using Setting BranchFound Then On BranchFound GoSub Activated Changed Char Click Create End Else Call Msgi Window Invalid branch Branch passed to SKELETON 22 SKELETON End Return RetVal Activated Begin Case Case CtrlEntId Windowv The rou
18. Newsletter Volume 4 Issue 2 d MARING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 4 of 44 SPREZJATURA cost of internal US domestic flights This has made our people such regulars on Virgin Airlines that they now help out on moderating some Virgin Websites online However with recent growth we ve finally been forced to move but we refused to give up the convenient location without a struggle so we ve moved just up the road We re still in Ealing but in newer more modern offices with a new VOIP switchboard faster internet access and all mod cons The best thing from the perspective of your editor is that we now ALL have Windows yours truly used to be in a box with no windows and air conditioning I know it will come as a surprise to some of you but a lot of UK offices don t have air conditioning Those naughty Elizabethans just didn t think ahead when designing national monuments The view from outside makes stepping out onto the roof a delight so courtesy of a staff member here s one of the views Revelation s Movements Again we must apologise for the highly irregular publication schedule for SENL the problem is as any consultancy knows these sorts of endeavours are normally fitted in around more normal paying work and there has been quite a lot of this about with the continuing success of OI 7 01 and the forthcoming release of OI 7 1 The community is continuing to expa
19. PPEN 2010 Sprezzatura Ltd All Rights Reserved Page 26 of 44 SPREZ ATURA Begin Case Gase CtrlEntId Window BTN CANCEL GoSub ClickBtn cancel Gase CtrlEntId Window BTN GoSub ClickBtn ok End Case Return Create Begin Case Case CtrlEntId Window End Case Return ChangedEb header Return CharEb header Return OlmckBtn cancel Return Eet ok E Return We can now modify our code to perform the functionality we require CAVEATS Because the ZZ SKELETON routine puts calls in as QuickEvents there are certain things that it will not trap efficiently As a simple example if a WRITE event is added the code will not be called until AFTER the WRITE has taken place The ZZ SKELETON code could be modified to insert a direct call into the MAKING DATABASES HAPPEN O N Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd Rights Reserved Page 27 of 44 SPREZJATURA Script for the WRITE but this has not been done in this version Similarly with this version if code exists on file you will not be able to generate new commuter code for it Finally this code generates small amounts of Sprezzatura specific code This can easily be removed from the generator but we have left it in to stimulate thought in adopters Click here to download the Skeleton zip which contains an RDK install of the utility along with the produ
20. RANGEICONS E is BUTTONDOWN SOLELY ote Cig BUTTONUP Gage CG CALCULATE added removed 169 CASCADE by Skeleton and CLEAR expects all CLOSE commuter calls CREATE NES the form 16 DDEEROR STPROCEXE DELETE WINDOW If DsoABS will not report E183 psocLEAR other events nor gt will it remove them Options Standard header Delete existing commuter if UNchosen Include DAN Comm Init Author e T abs Date zD m Purpose Commuter module for 22w 2z 3Spaces d And collapse the ZZ SKELETON DEMO entry by double clicking it H prezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 15 of 44 SPREZATURA fad Commuter Program Generator O x ZZ SKELETON DEMO WINDOW LB WINDOWS LISTBOX Please note that TEXT 1 STATIC eise OK PUSHBUTTON SOLELY to be CANCEL PUSHBUTTON ined Vai DELETE CHECKBOX added removed EB HEADER EDITBOX by Skeleton and TEXT 7 STATIC expects all TEXT 4 STATIC See piens COMMON CHECKBOX APPD di RB TABS RADIOBUTTON STPROCEXE 1 GROUP 1 GROUPBOX GIWINDOW If DA zz TABLEBROWSER will not report DIS zz UTILITY AREVCONVERSION other events nor will it remove Options Standard header Delete existing commuter if UNchosen Lo Include OIwIN Comm Init Author
21. S volume is attached all files in that volume will have the SECURITY MFS placed on them UJ UJ Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 34 of 44 SPREZATURA There s one small gotcha with this though Some of the system utilities do not like dealing with SYSPTR records with a volume MES so you may have troubles doing a LIST VOLUMES on them You should also not try to save this information to your DBT file but attach the files during your login EE EE E ib E E E process This is a small price to pay for something so powerful don t you agree OpenInsight XP Carl Pates Technical Director Sprezzatura Group When Windows XP was released it came with a slick new user interface built on top of an integral skinning engine that implemented a new way of drawing windows controls Dubbed Visual Styles this system allowed developers to define appearance of controls and forms from simple colours to textures and shapes It was possible to manipulate each defined part of a control as well as each part of the non client frame and caption area of a window Most of this was enabled via a new function library called uxTheme dll but there was also a major internal change to the way in which Windows implemented controls Previously Windows supplied a series of standard controls Edit lines list boxes checkboxes etc direct from User32
22. andard header Delete existing commuter if UNchosen 7 Include OlwIN_Comm_Init Author AMc Ze T abs Date zD m Purpose Commuter module for 22w 2z 3 Spaces Scrolling down we ll see some pseudo events used internally at Sprezzatura for promoted events OF Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 13 of 44 SPRE Please note that this screen is designed SOLELY to be used with events added removed by Skeleton and ZZCHILDACTIVATED pects d ZZPERPETUAL oleis WINDOWS LISTBOX a TEXT_1 STATIC STPROCEXE 145 BTN BK PUSHBUTTON GIWINDOW If CANCEL PUSHBUTTON wil not report DELETE CHECKBOX other events nor gt will it remove them Standard header Delete existing commuter if UNchosen Include OIwIN Comm Init Author Date ZD Tabs Purpose Commuter module for 2 2Spaces C 3Spaces But for now we re just going to go with an ACTIVATED event and a CREATE event so double click these UJ Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 14 of 44 SPREZATURA Cancel 97 Commuter Program Generator ZZ SKELETON DEMO 4 ZZ SKELETON DEMO WINDOW ACTIVATED Please note that LIG AR
23. ct license and a readme As usual with our FREE utilities the files are supplied as is and we cannot accept any liability for any loss through the use of the files The Universal Driver Hints and Tips Bill Caisley Revelation Software EMEA Support With the introduction of the new Universal Driver UD there are a few things you need to be very aware of OI7 ships with the UD client installed and it will default to this unless told to do otherwise when installing OI7 If you are using the UD this is not a problem but if you choose another driver at installation and then wish to upgrade to the UD at a later stage be careful Currently if you install the UD onto and install the client again it corrupts the LH3 DLL and the LH3CLNT DLL and presents 0800 error when attempting to start OI Revelation is looking into correcting this in the near future To fix this you will have to replace the two corrupt DLL s with the DLL s from a clean install of OU which is available on the latest Revelation End of Year CD One of the exciting features of the UD is that it removes the 64KB restrictions of previous drivers and increases the frame size to a possible 4GB To achieve this the header section in the Linear Hash files has been changed to add extra addressing bytes The UD is backward compatible and can understand the header information of older drivers but the converse is however not true The older drivers could not have envi
24. d Page 19 of 44 SPREZATURA 97 Commuter Program Generator Please choose the windows you want to add edit commuter modules for then press OK 27 SKELETON DEMO Cancel ZZ_SKELETON_DEMO WINDOW D LB WINDOWS LISTBOX 145 TEXT 1 STATIC Please note that fa BTN OK PUSHBUTTON this screen is BTN_CANCEL PUSHBUTTON SOLELY tobe 4 CHK_DELETE CHECKBOX ET EE 4 HEADER EDITBOX added temoved CALCULAT y Skeleton an by Skeleton Mam EME expects all commuter calls to be of the form DBLCLK STPROCEXE DDEADVISE 21 GWINDOW If DDEERROR will not report DSOSETPARAM other events nor gt will it remove them Options Standard header Delete existing commuter if UNchosen Include DAN Comm Init Author e T abs Date zD m Purpose Commuter module for 22w 2z 3 Spaces Finally we ll indicate that we want Window Common included MAKING DATABASES HAPPEN WO H Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd All Rights Reserved Page 20 of 44 SPRE TEXT_1 STATIC BTN_OK PUSHBUTTON BTN_CANCEL PUSHBUTTON DELETE CHECKBOX Please note that HEADER EDITBUX TEXT 7 STATIC Rey dp TEXT 4 STATIC used with events CHE COMMON CHECKBOX added removed RB TABS RADIOBUTTON by Skeleton and GROUP 1 GROUPBOX expects all commuter calls to be of t
25. d keeping up with technology What do you most dislike about RevSoft products What s to dislike 4 Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 43 of 44 SPREZATURA If you HAD to use another database what would it be and why I guess I would follow the flock and opt for MS SQL I can t wait for the fuzzy Do what I m thinking release What are your favourite 3 books and why The Hobbit The Lord of the Rings Looks like 4 books but really 2 stories I can read them over and over this is the way history should have been The films brought the story to life for me but much better as a read Supernature Lyle Watson s descriptive and informative explanation of the every day in layman s language It really appeals to my lateral thinking What are your favourite 3 CDs Albums and why Pink Floyd The Wall They don t make them like this anymore The Beatles white album Defines a period in my life when I was young and foolish Chris Isaaks Baja Sessions Best sippin album for me What are your three favourite films and why The Shawshank Redemption Right will prevail and overcome any adversary Surprise ending The good guy wins Die Hard Action action action The good guy wins big The Life of Brian Monty Python s best work It is the most intelligent comic farce I have ever seen Consider the lili
26. ember 2004 Please be sure to download your FREE upgrade as soon as possible to avoid any disappointment S List 2 x users All S List 2 x licenses will need to be upgraded to version 3 x through the purchase of a 2 x to 3 x upgrade This upgrade will also include the free support and maintenance for 12 months from the purchase of the upgrade Please contact mp sprezzatura com for the cost of the upgrade and details of how to obtain your version 3 x upgrade files New licenses If you have not yet bought your S List 3 x license and are planning to do so in the near future you can purchase the full product with support and maintenance for twelve months at the current prices 99 00 169 00 USD for a single user license To address our customers requests for a structured support and maintenance scheme we will be creating a new S list package which will be formally launched on 1st January 2005 This new package will replace the old product only package that we have previously offered Further details will appear on our web site very soon with the new pricing coming into effect on the launch date however it will consist of the following All new S list licenses will cost 125 00 GBP 225 00 USD and the delivered package will consist of a the S List Designer software development license b documentation in electronic format c 12 months email based support support sprezzatura com d 12 months upgrades available from w
27. er Talking the Talk If we now open the form in FORMDES by double clicking it 2 MN Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 22 of 44 SPRE pe Je Commuter Program Generator 0 gt rm insqauuuwaeueuwuuuau au 2 5 Author Date 404 Purpose Commuter module for 2 We can see that the quick events have been added in so for example let s double click the Window to look at the events on the window NO NO Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 23 of 44 SPREZJATURA X QuickEvent for ACTIVATED E Event Send Message to Entity Control window SYSPROG STPROCEXE SKELETON Gw DI Message Start a window Start MDI child window EXE CUTE Parameters Display QuickH elp Display a message SELF ACTIVATED Index lookup Close window Fiead the row Return value in Write the row Clear the form Delete the row Internet Control Property X QuickEvent for ACTIVATED E Event Send Message to ACTIVATED lt q gt d Entity Control Window SYSPROG STPROCEXE SKELETON_ w DI Message CUTE 71 Parameters SE
28. es The good guy gets it in the end What event in history would you most like to have been present at Iwas present at the release of Nelson Mandela and the democratisation of South Africa That was big enough for me And finally Your motto witty aphorism Life is a gas Let it out Me A Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd Rights Reserved Page 44 of 44 Peripheral Trivia As this issue of S ENL was put to bed we fed the inner man with TV Stargate Atlantis F Book Joel On Software Joel Spolksky N CD The Streets A Grand Don t Come For Free E WEB www v flyer com Send Mail to Admin Sprezzatura com with subject SUBSCRIBE SENL or complete our online registration form Leave Us Send Mail to Admin Sprezzatura com with subject UNSUBSCRIBE SENL Change of Address Leave at the old address amp join at the new one Web Info http www sprezzatura com COPYRIGHT NOTICE S ENL 2010 Sprezzatura Ltd All rights reserved Portions copyright Microsoft Corporation Inc Portions copyright Revelation Technologies Inc No portion of this journal other than code segments may be reproduced by any means be it photocopied digitised transcribed transmitted reduced to any electronic medium or machine readable form nor translated into any other language without the prior written consent of Sprezzatura Ltd or S
29. est friend is the new updated release of the Universal Driver Installation Manual Follow it carefully and you will stop almost all of the headaches Errors commonly associated with the Universal Driver 0800 As described above These errors are related to there being a problem with the REVPARAM or INI FS231 amp file s or entries in the file s There is a check sheet available on FS1019 http www revsoft co uk fs231 ts guide htm for the FS231 error as it can be very elusive S List 3 0 Changes to License Martyn Phillips As you will no doubt be aware S List has recently undergone a major overhaul and during this period many of the requests from our customer base have now been included in the latest versions This project has resulted in many different versions of the product being emailed to different people where their issues have been addressed in that version on a case by case basis While new functionality and fixes were easily addressed in the product there remained one fundamental question that many of our S List users had What about support and maintenance and how can I be sure I have the very latest version Many of you will have recently downloaded and installed the latest version from our web site seemingly free of charge This was the final stage in a long pilot during which we were working on a new mechanism for making upgrades more easily and readily available to our users pleased
30. he form STPROCEXE GIWINDOW If will not repart el other events nor gt will it remove them Standard header Delete existing commuter if UNchosen Include OIwWIN_Comm_Init Author Date 20 Tabs Purpose Commuter module for Zw 2Spaces 3Spaces And when we ve finished we ll click the now enabled OK button O N Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 21 of 44 SPREZATURA 97 Commuter Program Generator 22 SKELETON DEMO WINDOW LB wINDOWS LISTBOX 145 TEXT 1 STATIC Please note that BTN_OK PUSHBUTTON 2 x BTN CANCEL PUSHBUTTON SOLELY to be B 4 Cut DELETE CHECKBOX UN EE JEB HEADER EDITBUX added removed 3 TEXT 7 STATIC by Skeleton and TEXT 4 STATIC expects all COMMON CHECKBOX ace RB_TABS RADIOBUTTON 4 GROUP 1 GROUPBOx STPROCEXE 227 TABLEBROWSER WINDOW If ZZ_UTILITY_AREVCONVERSION L will not report ZZ_UTILITY_DLL_DLG other events nor gt will it remove them Options Standard header Delete existing commuter if UNchosen 7 Include OlwIN_Comm_Init Author AMc Tabs Date 4D AT EA Co 6paces Purpose Commuter module for Zw 3Spaces The system pauses whilst it generates the code and updates the window and then returns to the application manag
31. hey were saving data but that data was being lost by their AREV 1 12 payroll system The emu set about logging the critical keystrokes of each user looking for moments of sheer brilliance when the idiot users hit Escape instead of F9 in data entry windows The DOS keyboard buffer is circular located at 0040 001E and there are two pointers in the BIOS in low memory 0040 001A amp 0040 001C which point to the head and the tail of the buffer The emu thought this was a fair place to look for evidence In AREV you can use the following KEYTRAP function to determine the last key pressed This works for all but the Shift Ctrl and Alt keys The Escape key puts a value of 011B 283 in hi lo format the keyboard buffer Check for a return value of 283 which will be the most recently added value in the buffer if the user escapes To create the routine KEYTRAP which you should then catalog 02000000000000000000065253BA4000 8EC226A11C003D1E007508268BOE3C00 EBO7908BF0268B4CFEBE00005B5A07B8 0014BA00002EFF1E0A00CB OPEN BP TO BP FILE THEN WRITE TO BP FILE SKEYTRAP A A A A Here is the RBASIC to test it subroutine test keytrap declare function keytrap This is message now see what key the user pressed to exit the message lastkey keytrap if lastkey 283 then call msg you pressed escape to leave the message
32. ing system you want RTP57 Code FSList TableHandle Name FMC Record Status This passes the code right down to RTP57 which does the READ or the WRITE or the OPEN or whatever other call is required There s not really much of a difference in the programming concept behind it The difference is in the scope of the system and its effects For those who think this is an idea that does not really have much use I refer you to the inner workings of REPOS BFS which does exactly this REPOS BFS parses the record manipulates the various repository index files encrypts the records then calls RTP57 to do all the file access It s simple and powerful powerful enough that most of you probably thought it was a completely new filing system Some people have taken this concept and used it when they wish to place an MFS on a large number of files If there are hundreds of files that require auditing for example placing an AUDIT MFS on each one then this can be a time consuming task However there is an easier way to handle this desired functionality and that s through the third type of MFS the volume MFS NO UJ Electronic Newsletter Volume 4 Issue 2 MARING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 33 of 44 SPREZATURA A volume MFS is like a file MFS but instead of shelling all the access to a file it shells all the access to a volume You write the volume MFS the same way you wo
33. n three basic types The first type is a simple or standard MFS This is what most people talk about when they refer to an MFS In this incarnation the MFS is a shell around the base filing system or BFS The concept behind it is beautiful in its simplicity Here s the contents of the SYSTABLES record for the SYSREPOSLOCKS table RTP57 REVBOOT SYSREPOSLOCKS GLOBAL SLMFS RTP57 According to the dictionary of SYSTABLES field 4 is FS LIST which is short for Filing System List This field contains the list of all the filing systems associated with this particular file When the system executes file based opcodes READ WRITE OPEN etc the opcode interpreter works a little bit of magic Here s a view of the SYSREPOSLOCKS table s handle after an OPEN statement O 9 Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 31 of 44 SPREZJATURA apeninsight Debugger ERASEME Een e 21519 SYSREPOSLOCKSHANDLE 2 Inspect Modify 1 1 1 1 gt SI MFS 1 1 2 RTP57 1 2 1 00024 000000000031REV30046 LK00039DICT RES 1 2 25 RIPS57 1 3 1 000000000032REV30045 LK00030RTP57 lt 1 4 gt 1000000000029 30049 1 00030 5 lt 1 5 gt 1000000000031 30046 1 1 6 SYSREPOSLOCKS Hu Notice that the first 9 VM delimited field is the contents of field 4 This is the file system li
34. nally we re pleased to welcome back our usual stalwart contributors to SENL Aaron Kaplan with an article on the use of Volume MFSs and an apparently resurrected Eric the Emu who is playing with keyboard trapping For those of you who ve been dealing with EMEA support we also provide an introduction to Bill Caisley Revelation Software UK s front line support and as ever the redoubtable Carl Pates contributes a cute but useful tip to those of you wanting to improve the look of your OI apps under XP As an aside if you ve recently moved to 7 0 from earlier versions you might want to take advantage of SRP s free utility to help with this at www srpcs com Finally Andrew McAuley provides a couple of articles on Sprezz product and in the next S ENL a guide to Context Menus for programmers just in time to have this replaced by a 4GL method in OI 7 1 In closing a query for those of you making heavy use of a Rev system When running end of year type reports against your system do you find that data entry slows even when using Network products We don t have an answer yet we re just interested in your real life experience Thanks for continuing to be interested in our outpourings if you have any suggestions for information you d like to see documented then don t hesitate to ask Regards Your friends at Sprezzatura Skeleton for OI Delapsus Resurgam Commuting Your Execution Way back in the day it seemed that everyone agreed
35. nation Active Window Active List Saved List Enter a list name here To stop this from happening we need to tell Windows to draw the group box in the normal way and we can do this with the SetWindowTheme function exported from uxTheme dll SetWindowTheme is defined in the Windows SDK as HRESULT SetWindowTheme HWND hwnd LPCWSTR pszSubAppName pszSubldList Which means takes 3 arguments Handle to the window whose visual style information is to be changed Pointer to a string that contains the application name to use in place of pszSubAppName I SECH the calling application s name pszSubldList Pointer to a string that contains a semicolon separated list of class MAKING DATABASES HAPPEN Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd All Rights Reserved Page 38 of 44 SPREZATURA identifier CLSID names to use in place of the actual list passed by the window s class Well the last two seem pretty complex but we don t really need to worry about them in this instance The important thing is that if we pass empty strings for them then Windows will turn off the control s visual styling 5 0 we need to prototype this function by creating a record called DLL UXTHEME in the SYSPROCS table and add the following lines to it INT STDCALL SetWindowTheme HANDLE LPWSTR LPWSTR
36. nd attracting former AREV developers along with some stalwarts who up until recently were still using RevG We must also give a 4 Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd All Rights Reserved Page 5 of 44 SPREZJATURA warm welcome to those of the Pick community who have joined the Rev community as a result of Revelation s efforts to remind them of our existence There was a time when Pick was a four letter word in the Rev community as the old management strove to make something of the product that it was not do the words We are a Lotus Notes Software Company ring any bells The simple truth is without Pick there would have been no Revelation and we owe that community a debt of gratitude In the UK and Europe it has been gratifying to watch the efforts of Revelation UK bearing fruit especially in relation to raising market awareness It seems that a month doesn t go by without some new mention in the press One of the most impressive achievements recently was a two page article celebrating the success of one of Sprezzatura s favourite VARs Social Software The success of the jointly developed XML pilot scheme for the Government linking Youth Offending Teams into the Criminal Justice system was covered in a two page article in Government Computing the UK s leading magazine for the Government Sector In the States Revelation have been making headway as well with a number of
37. ndentation In addition it allows the specification of a custom header for the program At this stage the OK button is disabled as there is nothing to do add events and to generate a commuter program we firstly navigate to the Window we wish to generate for in this example we ll be all self referential and use a copy of ZZ SKELETON called ZZ SKELETON DEMO XO Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 10 of 44 SPRE Please note that this screen is designed SOLELY to be used with events READ CODING added removed SKELETON by Skeleton and SKELETON expects all i TABLEBROWSER commuter c UTILITY AREVCONVERSION a se Tom APPID UTILITY DLL DLG STPROCEXE PROPERTY INSPECTOR GNINDOW If Wiz AREVCONVERSION XML SCHEMA will not repart el other events nor gt will it remove them Standard header Delete existing commuter if UNchosen Include OIwIN Comm Init Author Date ZD Tabs Purpose Commuter module for 2 2Spaces C 3Spaces Firstly we re going to add Window events so let s double click on ZZ SKELETON DEMO CO E prezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved SPRE ZZ IDE TBLOPENDLG ZZ IDE TBLOPENDLG MULTI 812122 10 TCL ZZ IMPORT LO
38. new User Stories and additional press coverage Planning is already well under way for the next conference in Las Vegas and as ever Sprezz plan to be there in force New Orleans was a great success for all concerned and there were some stunningly informative presentations This year the management team at Revelation are pulling out all of the stops to ensure that the quality of presentation is higher than ever and standards have been set to ensure that all contributors will be even better than last year The bar has been raised at Sprezz Towers and preparations are already under way to ensure that our professionalism is not drowned out by our spontaneity even if this means slightly more scripted presentations Our flights are already booked so we look forward to seeing as many of you there as possible As an adjunct to the article by Bill Caisley don t forget to check out Revelation US s interesting article on using the Universal Driver to hide the DOS files from users at http www revelation com knowledge nsf 07dbcbabb6b3e379852566150064cf25 eac117ad062bc8f78 5256f4a004e04de OpenDocument This complements Revelation UK s article another Bill Caisley assisted by Kevin Ruane at http www revsoft co uk Downloads hidinglkov pdf In This Issue One of the incidental giveaways at the last conference was a reincarnation of our favourite utility for _ AREV Skeleton In this issue we discuss this utility and attach a checkout for you to try
39. oftware let s take a look at what it does Walking the Walk In this instantiation of Skeleton we ve opted to ship as a Windows Executable called ZZ Skeleton It is supported by an underlying commuter program called yes you ve guessed it ZZ Skeleton When the window is run it shows you a list of windows in the current application and asks which one you d like to add a commuter module to Once you ve chosen the window it then asks you for the window and for each prompt which events you d like to add It then adds quickevent calls into the window and generates the source code for the supporting routine Of course there are caveats associated with this but let s look at the routine in action before discussing these So to launch ZZ Skeleton we navigate to the OI window executable ZZ SKELETON MAKING DATABASES HAPPEN Sprezzatura Electronic Newsletter Volume 4 Issue 2 2010 Sprezzatura Ltd All Rights Reserved Page 8 of 44 PRE EX 0peninsight SYSPROG ate Tools Development Help Openinsiah Form Executables DI Ls E aA gt Table Builder d 22 IDE Database Manager 22 IMPORT 1 06 ZS 22 LICENSING W ZZ_MAILSHOT For Designer 22 MDIFRAME iB 22 System Editor 22 PROMOTED EVENTS 22 READ Ul Workspace D SEIN Report Builder IB 22 UTILITY AREVCONVERSION Sl zz DLL DLG Deploy Application ZZ_UTIL_PROPERTY_INSPECTOR ZZ UTIL RECOMPILATION ig
40. prezzatura Inc The moral rights of the authors have been asserted Disclaimer Whilst every effort is made to ensure the accuracy of the information contained herein neither Sprezzatura Ltd nor Sprezzatura Inc can accept liability for the failure of anything documented herein to work nor for damage resulting from the application of methods techniques learned herein TRADEMARK NOTICE Openinsight is a trademark of Revelation Technologies Inc trading as Revelation Software Microsoft Windows and MS DOS are registered trademarks of Microsoft Corporation All other product names are trademarks or registered trademarks of their respective owners Printed in the United Kingdom S ENL Volume 4 Issue 2 20 November 2004 Please encourage your correspondents to send e mail to admin sprezzatura com with SUBSCRIBE SENL in the subject line to get their own free subscription Everyone is welcome Tell your friends about S ENL I4 Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN
41. riate naming convention which is simply appname exe manifest I Ou Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 35 of 44 SPREZATURA E g for OpeniInsight we need to create a manifest file called oinsight exe manifest and place it in the same directory as oinsight exe The contents of the file itself are fairly straightforward lt xml version 1 0 encoding UTF 8 standalone yes gt assembly xmlns urn schemas microsoft com asm vl manifestVersion 1 0 gt assemblyIdentity version 1 0 0 0 processorArchitecture X86 name Revelation OpenInsight Sysprog type win32 f lt description gt Your application description here lt description gt lt dependency gt lt dependentAssembly gt assemblyIdentity type win32 name Microsoft Windows Common Controls version 6 0 0 0 processorArchitecture X86 publicKeyToken 6595b64144ccfldf language 123 lt dependentAssembly gt lt dependency gt lt assembly gt So just paste the XML above into Notepad and save it as oinsight exe manifest in your OpenInsight directory The next time you launch OI you ll have Visual styles enabled Turning off visual style for a control Of course there are instances where you won t want a control to have visual style enabled We regularly use a 4 pixel high group box to draw separator lines
42. rsion s of Opentnsight is in the treatment of Menus on MDI frames and when it comes to it on any Window Frequently the developer needs to customise the menu options that are available to a user based upon their security level and whilst simple modifications may be made using Set_Property ENABLE and VISIBLE this requires that place holders be in place for all potential menu choices which may not always be practical S Menu Security S MS provides a way around this It allows you to decide upon window creation WHICH window to copy the menu from at creation time Thus you could create a dummy window per Security Group with its own menu structure and assign a menu based upon the user s personal profile at runtime In addition you can individually customise said menu by deciding on a menu option by menu option basis whether that option ought to be included for the current user All of this is done automatically for you simply by making one call from your window create event All of this functionality is provided by a single subroutine called ZZ_Menu_Security An important note about licensing S MS is licensed PER DEVELOPER copy of OpenInsight Thus once you have legitimately acquired the software you may incorporate it into all of your delivered applications but you may not redistribute it to other developers or to different developer serial numbers It is perhaps easiest to describe the functionality of S MS with a flow chart
43. saged the new header changes What does this mean Files that are created using the UD will not be recognised by any of the older drivers OI with an older driver will not see the new files So any development that creates new LH tables using the UD will not deploy into a system utilising an older driver This is especially true when using the RDK to create upgrades for existing clients You could however change the driver in OI7 to All Networks 2 1 for example and then create the new tables which will make them useable in any of your systems The REVPARAM file should now not create any more confusion it has been made very simple The UD looks for a REVPARAM file in the directory of the LK file being addressed If it is not found the UD will search up the directory tree all the way to the Root until it knows that there is no REVPARAM file N N Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 28 of 44 SPREZJATURA present or reacts to the REVPARAM it finds So with the UD you now only need a single REVPARAM file if you require it The safest place to put it is in the OI directory where Oinsight exe resides However if you have multiple copies of OI running on the same server and they are in parallel directories you could have a REVPARAM file in each OI directory or just one on the root drive Remember when dealing with the UD your b
44. st and it s how the system knows how to access the file The file based opcodes pull this value out of the handle and then extract the first subvalued field In our example this would be SLMFS The system then generates a function call with the rest of the information in the statement NOTE This is the statement as in the READ or the WRITE and not just the rest of the handle This function is called in the format NextFS Code FSList TableHandle Name Record Status The MFS programming manual from Revelation will give you detailed information on what each variable means since they can mean different things in different contexts The first three variables are always consistent and are the only ones important for our discussion here Code contains a number code informing the program what branch to execute FSList contains the remaining FSList as known by this program TableHandle contains the rest of the table handle or where it s returned in the case of an OPEN Of these FSList is the most important The filing system logic of Revelation products is based on UY Sprezzatura Electronic Newsletter Volume 4 Issue 2 chaining of programs and this chaining is based on FSList MAKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 32 of 44 SPREZATURA When your MFS is called the first thing it needs to do is to strip off the first filing system in the list EE EE E E E
45. tine looks like this Function Skeleton Zz skeleton ctrlEntID branch paraml param2 param3 param4 paramb param6 param7 param8 param9 10 paramll paraml2 param13 paraml4 15 paraml6 paraml7 paraml18 param19 param20 Author AMCA Date 17 November 2004 Purpose Commuter module for ZZ SKELETON Notes 21 4 N Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HAPPEN Return 2010 Sprezzatura Ltd All Rights Reserved Page 25 of 44 SPREZATURA SInsert Logical WinID Window Insert OIWin Comm Init RetVal True Function Get Property Set Property Get Repos Entities Utility Msg Generic Events Beelare Subroutine Get Property Set Property Utility Msg Locate branch In ACTIVATED CHANGED CHAR CLICK CREATE Using Setting BranchFound Then On BranchFound GoSub Activated Changed Char Click Create End Else MsoNeWrndow Invalid branch Branch 2 passed to SKELETON ZZ SKELETON End Return RetVal Activated Begin Case Case CtrlEntId Window End Case Return Changed Begin Case Case Windows EB HEADER GoSub ChangedEb header End Case Char Begin Case Case CtrlEntId Window EB HEADER GoSub CharEb header End Case Return UI N Sprezzatura Electronic Newsletter Volume 4 Issue 2 MAKING DATABASES HA
46. uld write a file based MFS The difference is in the installation On a volume MFS you need to add the information to the SYSPTRS table This is a little used table in OpenInsight Those of you with an Advanced Revelation background might remember the VOC table Records in the VOC table did not correspond to any particular format and could mean program definition records batch TCL commands and volume pointers just to name a few SYSPTRS Openlnsight purpose is to hold all those old volume pointer definitions in ARev Surprise surprise Revelation did not forget about that little piece of the system The format of SYSPTRS is quite simple 0 X Alternative Volume Name 1 VOLUME always 2 FSlisting 3 Real location of the volume For example if you wished to have your F SHARED SYSTEM APPS SPREZZWARE UTILITIES volume stored as something easier you could have a record like 0 SPREZZUTILS 1 VOLUME 2 RTP57 3 FANSHAREDNSYSTEMMAPPSNSPREZZWAREAUTILITIES Then if you need to attach or manipulate that volume you just treat it as the name SPREZZUTILS which is a much easier to remember name Adding your MFS to this record is just a simple matter of adding to the FS list in field 2 Delimit the values with value marks and it s all done 0 SPREZZUTILS 1 VOLUME 2 SECURITY MFS RTP57 3 F SHARED SYSTEM APPS SPREZZWARE UTILITIES When the SPREZZUTIL
47. ww sprezzatura com 0 N Sprezzatura Electronic Newsletter Volume 4 Issue 2 MARKING DATABASES HAPPEN 2010 Sprezzatura Ltd All Rights Reserved Page 30 of 44 SPREZATURA On the anniversary of the original purchase you will have the option to extend your current support and maintenance for further 12 months or remain with your then current version and purchase support as and when required on a pay as you go basis The cost for the support and maintenance renewal will be 50 00 GBP 90 00 USD We believe that this new way of supplying S list will ensure that you and your users will consistently have access to the very latest S List features and innovations via our web site and access to our support and S List development team for prompt response to your S List technical questions p s The new pricing will not become valid until 1st January 2005 Please be sure to order any new S List licenses that you or your users require before the 31st December 2004 to benefit from the new package at the old cost Further details about S List the user manual and ordering details can be found by clicking here Volume MFSs Aaron Kaplan Managing Director Sprezz Inc B One of the least understood yet more powerful components of all Revelation products is the Modified Filing System or MFS This tool goes back to somewhere around Rev E and was then known as an AFS Alternative Filing System An MFS can come i
Download Pdf Manuals
Related Search