DBView Professional User's Manual
Contents
1. BY REDLEDGE DBView Professional v1 0 8 0 User s Manual RED EDGE DBView Professional User s Manual Contents LES E lel NO DE ues E E E E 5 Be FUE LSS US ware separa coat wnte enacts cotsnwearo us assG neem A cs maieioonmanecdcapasonuee 5 FNS CNV DEVION orscterce tates ida ssa a ADO PAG Ad OS RD SS tea eee ateeoesaed 5 Installing Outlook Support for DBView cccccseccccssseccceesececeesececceeceeseesececsunececeunceeseneeeetsusesetseneess 5 DOC Ds ds dai di DD 6 Accessine CHE SOU UD UNION saunsasiaas diodo padre Le duis nisi o ni cr OU india sido ND a ai nene dinda 6 TRE COMME EOI SO cara pernoite 7 Create a NEW Connec Moreira r inalterada caia a gas dani a aad ani one nada gira gas aonde 7 Remove an existing connection cccceeccsseceseccsccesccesecesccesecessceseceseccseecaeeseetaeetaeeseeteeeseeesaesseetes 8 VIEW TS CC o CARNE sce chee cob T E NR CR RENDER CORE O DR RD PIER semis 8 Chance ine update OS Sene S sao SS CUSCO OIE eee a SS ROD en ne assa as 8 Change the configuration TIC aigeaseaesssinosineiaidasadidssidesiaga nad dialoga dana did aid saca nossa ANSIEN ENE SENE 9 Control access to the configuration File eee ceseccceesscccceesececeeececceeeececsesececsuneceeeeneeeeseuecesseneces 9 Tne protecieo Melos SD sos asnoisia dai ones da c e pn sd da Cn dr sino Dt esco 11 TRE CIO NAVES MI East ne O a re ee ee eee 12 TRE TUN CUO SE E E EE A E o A 13 Create a nem TUNCHON serene rrenan 13 Usine elas I2. Your search criteria cannot be more than 8000 characters in length Note The search criteria is case insensitive Number and date time fields To search for records with a number or date time field equal to a value enter that value in the search criteria To search for records with a number or date time less than or equal to a value enter that value in the search criteria preceded by a vertical bar To search for records with a number or date time greater than or equal to a value enter that value in the search criteria followed by a vertical bar To search for records with a number or date time within a range enter the lower and upper limits of the range in the search criteria separated by a vertical bar To search for records with a number or date time field having a null value enter a question mark in the search criteria To search for records with a number or date time field containing certain digits you can use the following wildcards o Any sequence of digits Use a asterisk o Single digit Use an underscore o Range of digits Use the range of digits enclosed in square brackets e g to search for a digit from 4 to 7 use 4 7 Note When searching for numbers using wildcard characters the decimal place is ignored and should be omitted from your search e g both 1234 5 and 1 2345 would be a match for a search criteria of 123 Boolean Yes No fields To search for records with a Boole
3. Second Edition Runtime To do this run vstor exe and follow the on screen instructions Page 5 of 35 i fessional REDLEDGE a a Set up Accessing the set up functions From the menu screen click the Setup button to access the set up functions This will show the connection list Note The Setup button won t be visible if you are not on the list of users permitted to access the setup functions on the current configuration file See Control access to the configuration file Note You will be asked to enter a password if a password has been set on the configuration file See Control access to the configuration file Page 6 of 35 RED FDGE DBView Professional User s Manual The connection list EAR Sess MIO a2 Adventure Works Game uso ny isis ewe Ao Gute pise ssa uy Avene Nola sas fomo E AdventureWorks Database Log MSSQL kusiy __ AdventureWorks dbo Datsbaselog N Advertueioks HR Dept mssaL rusty AdvertureWorks HuranResouces Depainet E AdvertureWorks HR Employee MSSOL finty Acerte HurenResouces Emoe m The connection list shows the list of connections in the current configuration file The toolbar contains the following icons E Create a new connection Remove an existing connection w Access the protected fields list Access the field values list a Access the function list Access the watch list View the update log la Change updat
4. Edition Runtime vstor exe If you can t email a chart from DBView you can export the chart and attach the file to an email message manually Auto refresh a chart To automatically redraw a chart at regular intervals click the gt button and enter the number of seconds you require between redraws The gt button s background will change to yellow to indicate the auto refresh feature is activated To deactivate the auto refresh feature click the gt button again Page 31 of 35 RED EC DBView Professional User s Manual Email watch status To email the status of all watches according to their email settings run DBView with the command line parameter w i e run DBView exe w Page 32 of 35 RED ECE DBView Professional User s Manual Appendix A Search criteria Text fields To search for records with a text field equal to a value enter that value in the search criteria To search for records with a text field not equal to a value enter that value in the search criteria preceded by an exclamation mark To search for records with a text field having an empty or null value enter a question mark in the search criteria The following wildcard characters are allowed as part of a value o Text of any length Use a asterisk o Single character Use an underscore o Range of values Use the range of values enclosed in square brackets e g to search for a character from a to e use a e
5. RR a a i a peel Open Notepad SHELL notepad exe Do you want to open notepad Notepad has been opened The function list shows the list of functions in the current configuration file The toolbar contains the following icons F Create a new function 5 Remove an existing function Create a new function To create a new function click the button on the function list toolbar Page 13 of 35 RED EDGE DBView Professional User s Manual Create Function Connection Name Function Name Type Command E Insert Field Contimation Message Completion Message Users E Choose a connection name with which to associate the function from the drop down list and give the function a name Note The function name must be unique for the entire configuration file not only unique for the chosen connection Choose the type of function you wish to create from the drop down list You can choose either SQL Statement which will execute the command on the SQL Server connection associated with the function or Shell Command which will shell run the command in Windows Enter the command you wish to run You can get DBView to substitute values into your command when it is run by using a field See Using fields in a function Note Make sure that the command you enter is correct If it is incorrect you could accidentally alter data that you don t want to change Page 14 of 35 pu
6. log click the L button on the watch list toolbar Page 20 of 35 RED EDGE DBView Professional User s Manual Viewing data Opening a data view v1 0 1 0 To access the data for a given connection choose the group from the first drop down box and the connection name from the second The data view will open Page 21 of 35 ER RED FDGH DBView Professional User s Manual The data view E Reagent Results Updatable BGUL2E 4S FOABBIKNI gt WiORZOElY Result Type Lot_Number Archive ID Assigned Value Delta Value moa TR DR e OO m san O o E q CC fesa 5 amem uz o 0 s mm Ju a sp O Co m uz O ma Le T a Re TT resutRecondiD f795a27 c9bc 465e al5e 6 Reagent ID 1 Result_Type Lot_Number 20081112 Analyte Calcium Archive ID 0 Assigned Valu 1 Delta Value 05 rowguid 95c841304890 43d2 9726 321 32365 records The data view allows you to use data retrieved from a connection It consists of a search grid in blue a data grid in white yellow and a box view It also contains a toolbar The toolbar contains the following icons Start search Stop search Continue search Export data Print data Email data Sort data server side Auto refresh data Analyse data View favourite charts Create new chart View watch status Show hide columns View search history View favourite searches Add current search as a favourite PHOHOHGAL aVTEOORAN Remove current search from favouri
7. password in the box If you want to limit access to the configuration file to certain windows users only type the user names into the box and click the Add button Note Your own user name is shown at the bottom of the form Make sure your list of users contains your user name if you want to have permission to change the file in the future Note The user name is case insensitive Page 10 of 35 a RED HG DBView Professional User s Manual The protected fields list You can use the protected fields list to stop certain fields being changed during an update To access the protected fields list click the U button on the connection list toolbar Protected Fields Choose a connection name from the first drop down list and tick the fields that you would like to protect Page 11 of 35 ES RED DC DBView Professional User s Manual The field values list You can use the field values list to create a list of predefined values for a given field To access the field values list click the button on the connection list toolbar Field Values Choose a connection name from the first drop down list and a field within that connection from the second Use the Add and Remove buttons to create a list of predefined values for the field Page 12 of 35 A REDLEDGE DBView Professional User s Manual The function list To access the function list click the BE button on the connection list toolbar
8. 1eDy py 188 2407 aig aE PH H ony apr N Aqua puog eyte To add a chart as a favourite chart click the button on the chart view toolbar You will be asked to enter a name for the chart Changing the y axis range To change the y axis range click the TIL button on the chart view toolbar Change Range Y Axis Range 8 Automatic Manual If you would like DBView to calculate the range for the y axis for you make sure Automatic is selected DBView will select whole number values below and above your data for you If you would like to specify the range yourself make sure Manual is selected and fill in the minimum and Page 30 of 35 RED ECE DBView Professional User s Manual maximum values Click the OK button to accept your changes If the chart was loaded from a favourite chart these changes are not saved to the favourite chart Exporting a chart To export a chart click the E button on the chart view toolbar The chart is exported in bitmap bmp format Printing a chart To print a chart click the E button on the chart view toolbar Emailing a chart To email the chart click the I button on the chart view toolbar DBView will open a new message in Microsoft Outlook and attach the chart in bitmap bmp format Note To email a chart from DBView you must have Microsoft Outlook 2003 or later installed together with Microsoft Visual Studio 2005 Tools for Office Second
9. REDLEDGE qe If you want a user to confirm that they want to run the function when it is selected enter a confirmation message If you want to notify a user that the function has completed enter a completion message If you want to limit use of the function to certain windows users type the user names into the box and click the Add button Note User names are case insensitive Using fields in a function To add a field to your command click the Insert Field button Insert Held Data Fi Select the type of field to wish to enter by selecting the appropriate tab across the top of the window The Data Field type will use the value of the selected field for the row that is selected when the function is run Insert Field The String type will ask the user to enter a string text You can optionally give a maximum length of the string Page 15 of 35 RED EDGE DBView Professional User s Manual Min Value blank for none Max Value blank for none Precision blank for none The Number type will ask the user to enter a number You can optionally give a minimum value maximum value and precision number of permitted decimal places for the entered number Date Time Date Time The Date Time type will as the user to enter a date and time You can also choose to enter only a date or only a time The Yes No type will ask the user to ch
10. Y REDLEDGE O eit DBView will select whole number values below and above your data for you If you would like to specify the range yourself make sure Manual is selected and fill in the minimum and maximum values Finally click the OK button The chart will appear in a chart view View a favourite chart To view a list of favourite charts click the gt button on the data view toolbar To view a favourite chart highlight the name of the chart and click the gt button on the toolbar Remove a favourite chart To remove a favourite chart click the button on the data view toolbar to show a list of favourite charts Highlight the name of the chart you wish to remove and click the button on the toolbar Page 29 of 35 BD REDLEDGE The chart view pe i m O im E a a A C qui Sh2k E EA Y 09El appe OOzL Odd oat zod oozL Hd opel UNI Geel GPel qHOS Sor qJHEN SOF aqHzo Sor Pq O0zL asconjy O02 qHH SFZ qHZO SFZ IT S9ZL ng Gal Y S9ZL JHN S9ZL qHz0 S9ZL Hd S9zL qHi SSZ eg SOF qHH SOF Hd Gor Hd unig goz qHZO SZL The chart view toolbar contains the following icons Add to favourite charts qt Change y axis range E Export chart S Print chart Email chart amp Auto refresh chart Adding a favourite chart DBView Professional User s Manual as gea 2094 1 cel 1 LIM pioi uy qHZO Hal zgd duna JHE fdoq winipos SAYIN
11. activate the auto refresh feature click the amp button again Page 27 of 35 FS EE E REDLEDGE Caine Charts Create a new chart To create a new chart click the gt button on the data view toolbar In the group by field enter field you wish to use on the x axis of the chart and specify whether you wish to use all the data in the table or data matching the current search criteria Then choose the field you wish to chart and the function you want to apply to that field You can choose from count distinct count sum min max average std dev or variance Note You will only have the choice of count or distinct count for non numeric fields Choose a colour for the series by clicking the Choose Colour button and choose if the data points should be connected by setting the Join Data Points checkbox Finally click the Add to Chart button to add the series to the chart You can add more series by choosing the chart field function and colour again and clicking the Add to Chart button again To add a horizontal line to the chart choose it s y axis value and colour then click the Add to Chart button in the Horizontal Lines section of the screen In the Other Information section of the screen fill in the labels for the x axis and y axis If you would like DBView to calculate the range for the y axis for you make sure Automatic is selected Page 28 of 35 E x E i fessional B
12. an field equal to true enter T in the search criteria you can also enter Y True Yes or 1 To search for records with a Boolean field equal to false enter F in the search criteria you can also enter N False No or 1 Page 33 of 35 RED ECE DBView Professional User s Manual e To search for records with a Boolean field having a null value enter a question mark in the search criteria Note The search criteria is case insensitive Using AND and OR e To search for multiple criteria on the same field you can use the AND amp and OR characters e You can use brackets to enclose criteria e g to search a text field to values containing the letter e and either the letters s or t use the search criteria e amp s t Page 34 of 35 RED ECE DBView Professional User s Manual Appendix B Version history v1 0 8 0 e Added copy record functionality e Added protected fields functionality e Added main menu status bar v1 0 7 0 e Fixed OR searches ranged searches e Notify when invalid search criteria is entered e Offer to open exported files v1 0 6 0 e Warn if printing or emailing a large amount of data 1000 rows e Double click a cell in the data grid to copy its value to the search bar e AND and OR searching e Added field values functionality e Settings file in use is carried over to new versions v1 0 5 0 e Fixed bugto allow field names to include spaces v1 0 4 0 e Changed format of d
13. ate fields to include seconds v1 0 3 0 e Fixed bug when searching fields with a data type of text As a result search criteria cannot be more than 8000 characters in length v1 0 2 0 e Fixed bug when upgrading from v1 0 0 0 to v1 0 2 0 v1 0 1 0 e Added version number to the menu screen e Can manually set the range of the y axis for charts e Remove some x axis labels for charts to prevent label overlap e History and favourite screens no longer stay open when running search v1 0 0 0 e Initial version Page 35 of 35
14. ch Criter asas atm RSS DNS a Ga ROUGE ee ee 33 TS TICO ca coger et sence etcetera rats ve pct ecient gaia sen tonto E aun eq one Sere poate guna A R 33 Number ana date TIME tielas savincicnusenscesaruecaorasueevasarwectos aivendesavnccoreduvedensaudohenuiuenivssrmionenvacsnvessnlencends 33 Boolean es NOTICIAS is 33 Using AND ana OR assassina daserisasfadssad Guest ads dia s aaa Goa O Sand lia US US 34 POS E Version ARISTON as suse eco sect scree cas aceon toca ce eects E 35 ML O a cece A E E E vero naga E ona nea aiemenaeedeearne 35 VLOT O gas rage eo 9 E oh sort ead es sous goa ce ecoarene eva cove E 35 TOGO ISSN erecta voces copes ate SOR E CO NA RR RD RS 35 VLO DO RARE ODM NRO RODADA RC REAR DR RN RR DO 35 VOO cas 35 Page 3 of 35 bu REDLEDGE eee VEO O ARARAS ERR MR DR E RR RR PR 35 NTO ae oa are Sees seats E E P A E E E A E E E RE 35 AI a TE OE E N ee eee 35 VLO OUr E E aida Eae rea 35 Page 4 of 35 bu A REDLEDGE ga Installation Your installation media should contain 3 files setup exe DBView NET Setup msi and vstor exe Requirements DBView requires the Microsoft NET Framework v2 0 to be installed It also requires Microsoft Outlook 2003 or later to send emails via Outlook Installing DBView To install DBView run setup exe and follow the on screen instructions Installing Outlook Support for DBView To send emails from DBView via Outlook you must install Microsoft Visual Studio Tools for Office
15. e log settings i Use default configuration file Use remote configuration file c g Control access to set up functions Create a new connection To create a new connection click the button on the connection list toolbar Page 7 of 35 RED ECE DBView Professional User s Manual Fill in the server information and the server authentication type Fill in the user name and password if using SQL Server authentication Then click the Next button Create Connection Database Schema fi Add To Group Name Allow Updates Allow Deletes ss ss Select the database schema and table from the drop down lists Give the connection a group and name you can select an existing group from the drop down list or type in a new group Choose whether the connection can update and or delete the database using the tick boxes if the table chosen does not have a primary key you won t be able to update or delete from the table Finally click the Finish button The new connection will be saved and added to the connection list Remove an existing connection To remove an existing connection select the connection in the connection list and click on the 5 button on the toolbar You will be asked to confirm that you wish to remove the connection Note Removing a connection will also remove any functions and or watches associated with that connection Note Once you confirm that you wish to remove the con
16. ernadeacisdosunaeneddavsianvasveeiwednerandesais 25 Save a favourite search cccccccccsssssssececccccucaeessececcccesseeeseeececeessueusseeeeccesssauusseeeseeeessuuaaeeeseesenaaas 26 Removing a ca VOU INS Search sambar a dana p dad aii EEES 26 HVS STUN T NEWTFECO Ci a csc esses ctr ets ccc ae cee des donas EE E E 26 Copying an existing record to a new record cescccesscccesececesececencceeeneceeeneeesescesauecessuecenseceeeness 26 Editing an eXiSting 6 0 o MARR RR Ran RAS AR RC RN RD CORRE RR RE A RO 26 REMOVING am ex unge reconO ass solares asda E dude LARUE sa ada ds head da o LTS ia 26 EE WY ECTS E a esoneevyst seiecaa EE E A evadheee aun E E easements T 27 Auto refresh watches cccccccccssssssseecccceceeaeesseeeccccessaassseeeeceessseuessseeseeeessaueesseeeeeeessuauaaseeeeeesenaaas 27 Eea E E E A E O 28 Create ECN ANE ag E E E E E EE A E E E EE 28 View a favourite chal teseeris eare enra EE EE E EEA AEE 29 REMOVE a TaVOUNITS Chart sorrerari E E E A 29 TRE CIR N a E A S 30 Adding a favourite Charles iss asas ado a lapa ee a iss Sa 30 Changing the y axis range acces sane as Ui SAD inns dio his LEDS nn Gsi s nai Roads Ena assa dE 30 FNS OCS el a rese ress tens PR LERDO RR DN CRER RIR DENEGRIR SRD RUI RN 31 BUM UU A CRANO spas rasas dE asia sie TS SS O E OS SS 31 SE el VAI OO DR E ERR RE ERR E RD O A T O E E 31 PROP eres a COM aa rate lcd e adiando tr a 31 PVN WV AICI Set OLS E E A E EIE A AEA EN E 32 Appendix A Sear
17. es the top result returned from the database you can specify a field to order the data by either ascending or descending using the drop down lists Choose the test you wish to apply to the result in the drop down list You can choose from equal to greater than greater than or equal to less than less than or equal to or not equal to Type a value to compare the result to in the value box Enter the email addresses you would like to send email notifications to in the email box separated by semicolon Choose whether you would like to send email notifications when test condition is true and or false by ticking the checkboxes Click the OK button to save the watch Remove an existing watch To remove an existing watch select the watch in the watch list and click on the button on the toolbar You will be asked to confirm that you wish to remove the watch Note Once you confirm that you wish to remove the watch the action cannot be undone To add the watch again see Create a new watch Change the watch email settings To change the watch email settings click the 5 button on the watch list toolbar ES Email Settings SMTP Server mail yourcompary com From Address dbview yourcompany com Enter the SMTP server and port to use and the email address from which to send emails Click the OK button to save your settings Note The default port number for an SMTP server is 25 View the watch log To view the watch
18. na ECU asas gare ysis cctv sate draes walcenc caw act Sataecnu Sama ndousseeacimaeeearais 15 Remove ale 1 SUIS TUACHO cense 16 TS ANA Len S Essas coe USE E E O SU coongauauaverare coonneeanecestee sooner 18 Create a men RC sis gaia 18 Remove an existing watch ccseccccsseccceesececcesecccceseceesusececeusececeuaeceeeeusecessesecesseneceeseneceesageeetas 20 Change the watch email Setting S sisser utecontoccasoneouaanenanatacnandsduienaassa asa ia ass dsie Diino nadas dadas 20 VIGA UNE MACEIO assi as aa agencies neers auc eects eine D O ca 20 VEn NE ATA sanear A E CU na She asm ato va tien nate ee s 21 Opening adata VIEW arson aseruc dese Hds asaDa a Eos s Asa sanita ad Gsm adriana rodadas Hess a Es ad eei 21 TRE data VIE ssa es a EU ERR A DO eeeaoanyss 22 SE Arce TOR ALA essas go saint ads nd UU A o dO SUS 23 ap de jo q S O a j tr PARREIRA RA RA RENDER UM GR RR RR OR 23 PANONE O AN pr PR ser NR RSRSRS TERRE PAR EAR ONCE A DRI AR SAE SPREAD ERR E RR 23 EME G tez PARE RDRRR PNR NE RD RR ERON PAPA EAR RIPAR SR RP 23 SOFtINE COL eee na a OU a o GD SOS e ea ee 24 AONE SS CA ai as none aie E N E AE E E E 24 Page 2 of 35 RED ECE DBView Professional User s Manual PALEY SINS the CA a PD RD DR AR RR RR A ER RR O aa 24 View and use your search history ccccccesssecccceseccccesccccesececceseceeeueecceeausecessuaecessenceeeseneeetseneess 25 View and use your favourite searches vases scsvcnssatsivssdersnssocidanvewaseeve
19. nection the action cannot be undone To add the connection again see Create a new connection View the update log To view the update log click the L button on the connection list toolbar Change the update log settings To change the update log settings click the Le button on the connection list toolbar Page 8 of 35 RED ECE DBView Professional User s Manual Update Log Settings Use Text File Text File Settings Path 4 Use MS SQL Server Do not create update log not recommended OK Cancel You can choose to write the update log to a text file MS SQL Server 2000 or 2005 or not to create an update log Change the configuration file To use the default configuration file stored in your windows user profile click the button on the connection list toolbar To use a different configuration file click the button on the connection list toolbar After you change the configuration file the connection list will close Note Don t forget that changing the configuration file will change the access settings to those of the new configuration file Control access to the configuration file To control access to the current configuration file click the g button on the connection list toolbar Page 9 of 35 RED ECE DBView Professional User s Manual Setup Access Password Users Note Your current user name is krusty Chris To password protect the configuration file enter a
20. nter the new criteria into the search grid and click the gt button Exporting data To export the currently retrieved records click the E button on the data view toolbar You can export the data in the following formats e Comma separated values csv file This format is best for importing into database applications e XML spreadsheet xml file This format is best for opening in spreadsheet applications e HTML html file This format is best for viewing and printing Printing data To print the currently retrieved records click the E button on the data view toolbar Emailing data To email the currently retrieved records click the I button on the data view toolbar DBView will open a new message in Microsoft Outlook and attach the table in HTML format Page 23 of 35 RED ECE DBView Professional User s Manual Note To email data from DBView you must have Microsoft Outlook 2003 or later installed together with Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime vstor exe If you can t email data from DBView you can export the data and attach the file to an email message manually Sorting data To sort the currently retrieved records by a certain field click the field header above the search grid To sort the data in the other direction click the field header above the search grid again To sort the l l A data at the server before the data is retrieved click the zt button You can sor
21. oose between a Yes option and a No option Click the OK button to add the function into your command at the current position Remove an existing function To remove an existing function select the function in the function list and click on the button on the toolbar You will be asked to confirm that you wish to remove the function Page 16 of 35 RED ECE DBView Professional User s Manual Note Once you confirm that you wish to remove the function the action cannot be undone To add the function again see Create a new function Page 17 of 35 BR REDLEDGE DBView Professional User s Manual The watch list To access the function list click the gt button on the connection list toolbar The watch list shows the list of watches in the current configuration file The toolbar contains the following icons a Create a new watch 5 Remove an existing watch Change the watch email settings Ly View the watch log Create a new watch To create a new watch click the button on the watch list toolbar Page 18 of 35 RED EGE DBView Professional User s Manual Create Watch Connection Name Watch Name Function Field Search Criteria Field Add To Search Criteria Emailon TRUE 7 Email on FALSE Choose a connection name with which to associate the watch from the drop down list and give the watch a name Note The watch name must be unique for the entire configuration file no
22. recent 20 searches in your search history To see your search history click the iG button on the data view toolbar To re run one of these searches double click on the appropriate line View and use your favourite searches To view your favourite searches click the button on the data view toolbar Page 25 of 35 RED EGE DBView Professional User s Manual To re run one of these searches double click on the appropriate line Save a favourite search To save a favourite search enter the search criteria into the search grid and click the C button on the data view toolbar You will have to enter a name for your search Removing a favourite search To remove a favourite search first run the search see View and use your favourite searches Click the 3 button on the data view toolbar to remove the search from your list of favourite searches Inserting a new record To insert a new record into the table click the button on the data view toolbar Enter the new data into the box view Click the button on the data view toolbar to insert the new record or the button to cancel Note To enter a null value press Ctrl 0 while editing a box Copying an existing record to a new record To copy an existing record to a new record click the Em button on the data view toolbar You can edit the data in the box view Click the button on the data view toolbar to insert the new record or the button to cancel No
23. t by up to three fields in order in either an ascending or descending direction Auto refresh data To automatically trigger a search at regular intervals click the gt button and enter the number of seconds you require between searches The gt button s background will change to yellow to indicate the auto refresh feature is activated To deactivate the auto refresh feature click the gt button again Analysing the data To perform a mathematical analysis of all data matching the search criteria click the button o Dont use search criteria Use current search criteria tet Choose the field you wish you analyse in the top drop down list If you wish to group by a field select it in the second drop down list Finally select whether you want to analyse all the data or data matching your current search criteria Click OK to see the analysis Page 24 of 35 B REDLEDCE a 1245 tHb 180 anaco onra ara r rere fazana Jamie KOO smesso as e o 825 36051851851850 2381618233700034 Conduciviy 3727928990990968 501 ar rnat 74409660638722531 3 4en6ea57ezi04e 1245 Bini 502299899990090 8 7 o da roasisesaaaaaa 724902017101043 mst hm ho nho ha ha f o O a a O E meme rsrs ee as fie n emas meer meo cento et o isa fora g_ 68835009621530677 a Ea OO Nosso ATAC BALL IL 100 hee A Oh i177 2 AMnCA ATENA one am In CMW mt TT do Di View and use your search history DBView stores your most
24. t only unique for the chosen connection Choose the function you wish to use on the relevant field You can choose from average count distinct count max min std dev sum top and variance You can choose a field in the table you wish to apply this function to in the drop down list or type your own by ticking the advanced checkbox You can also type a combination of functions or apply scalar SQL functions for example add two fields together or use a CASE statement Note The result must be a number If you want to test a text field use a CASE statement in the advanced field box For example to test whether a field named type is equal to example use the statement CASE WHEN type example THEN 1 ELSE O END and test whether the result is equal to 1 Page 19 of 35 RED ECE DBView Professional nd User s Manual You can specify search criteria by choosing a field from the drop down list and typing the search criteria into the box The search criteria is in the same format as searching in a data view see Appendix A You can also type in your own criteria in SQL format by ticking the advanced checkbox for example to compare two different fields use a SQL scalar function or use an OR operator To add the search criteria to the list click on the add to search criteria button Note The watch will only use data that matches ALL of the search criteria If you have selected the top function which us
25. te Calculated fields identities and rowguids will not be copied from the existing row they will be regenerated for the new row Note To enter a null value press Ctrl 0 while editing a box Editing an existing record To edit an existing record highlight the record you wish to edit and click the amp button on the data view toolbar Edit the data in the box view Click the button on the data view toolbar to save the changes to the record or the button to cancel Note To enter a null value press Ctrl 0 while editing a box Removing an existing record To remove an existing record highlight the record you wish to remove and click the button on the data view toolbar You will be asked to confirm you wish to remove the record Note Once you confirm that you wish to remove the record the action cannot be undone To add the record again see Inserting a new record Page 26 of 35 B REDLEDCE q aaatien The watch list To view the watch list click the button on the data view toolbar Max Reagent Result gt 50 For each watch associated with the current connection you will see a status of f true x false or error Auto refresh watches To automatically refresh the status of the watches at regular intervals click the amp button and enter the number of seconds you require between refreshes The amp button s background will change to yellow to indicate the auto refresh feature is activated To de
26. tes Page 22 of 35 CARO i fessional BIREDLEDGE Users Manual Move to first record Move to previous record Move to next record Move to last record Insert new record Copy current record to a new record Update current record Delete current record Accept changes x4 O TOYA Reject changes The toolbar also contains a drop down list to execute associated functions Searching for data There are three ways to enter your search criteria e Enter any search criteria for each field by entering it into the blue box beneath the field name in the search grid e Double click a cell in the data grid to copy its value to the search grid e lf there are any predefined search criteria values for the field you can select one from the drop down list that appears when you enter blue box for the field in the search grid For more information on how to specify your search criteria see Appendix A Once you have entered the search criteria click the gt button on the data view toolbar You will see the number of records currently returned in the bottom left corner of the data view To stop the search and see the records currently returned click the 6 button If you wish to continue your search click the 2 button Note The search will automatically stop once all records have been returned Note Clicking the button will continue the last search even if you change the search criteria To search using new search criteria e
Download Pdf Manuals
Related Search