SmallBase Corisoft
Contents
1. CALC TXTSHELL SmallBase ProjXpert 2 3 Come back to SmallBase To cancel a password users must set the password again and just press Enter key the old password will be removed 54 SmallBase User Manual 9 Active fields and Automation 9 1 Making a phone call Telephone number field type from SmallBase allows user to make directly a phone call from the device For ER3 and ER5 SmallBase will generate DTMF frequencies For ER6 Nokia 9210 9290 SmallBase will automatically make a call for the selected record lf there is more than one telephone number field in the record SmallBase will open a list box with all telephone numbers Users can select one of them and press Compose to issue the call 55 SmallBase User Manual 9 2 Start a document or an application from SmallBase The File List field type can be used to start documents or applications directly from SmallBase SmallBase can easily become a document launcher Let s go and create a File Launcher with SmallBase Turn SmallBase into Build Mode and create a new table Close the selector and return to normal mode Priority SJELEN TASKMAN 1 Planned 56 SmallBase User Manual Select the new table Calc z Asystem anpsscalcscalc apt Liste of documents C udocumentskphoto gallery Nokia jpg C documents wml Syml We have created a shortcut to CALC application and a shortcut to two JPEG documents Note that2. Select Build Ctrl Date Select Ctrl S Add Ctrl N Variables Ctrl V Filter Ctrl H _ Colors CtrleY Cancel annad 08 01 2002 Progress 09 01 2002 At the first time SmallBase will open the dialog box below in order to enter the name of the first variable Priority Status Due Date We can choose the new name project for this variable 31 SmallBase User Manual Priority Status Due Date The new dialog box allows now variables updates creation Add or deletion Delete To create a new variable press Add Press 32 SmallBase User Manual project i status Press OK Create a new filter which will use this variable in order to display value according the project variable value Mie mid Examples Label Project 2 Active Yes Available Fields r8 Project Criteria w 80 project r2 gt 238r2 lt r3 r4 ER fr5 23 08 1963 r6 gt 1 2 33 SmallBase User Manual xl Add anade Filters omplete yet Edit Project Delete Activate Priority Status Due Date Write User Manual 1 In Progress 09 01 2002 Project project w POCKET 0 status 34 SmallBase User Manual Press OK and let s see the result Priority Status Due Date A new record has been selected Important Note Filters and Colors criterias
3. Exchange Rate Value 1 00 Amount 1 13 Amount Now we can mask the column Value by editing it and set Visible to No 38 SmallBase User Manual Exchange Rate Total 1 00 120 00 1 13 135 60 So how to use the conversion table It s very easy you just have to edit the Variable Value in pressing CTRL W And set the new value to 200 for example Amount 200 00 The display isn t automatically updated but if you press now CTRL H or do a Calculate from the main menu 39 SmallBase User Manual Exchange Rate Total 1 00 200 00 1 13 226 00 The display is now refreshed with the right values You have create a small application to manage Currency Conversion 40 SmallBase User Manual 5 5 Manage Sorting Out Methods and Increase Speed Sorting out methods let s the user sort datas in table according to one or more criterias Let s take previous example and set a sorting out method on the Currency Name File Edit View Control Links Tools Select Ctrl 5 Add Ctrl h Variables Ctrl AY Filter Colors E Sort by Ctrl l Cancel y Label p Currency ee Available Fields r2 Currency Sortby w eas 0 0 0 0 000 0 0 ssl 1 ASC r2 DESC We can add a new method called Currency We have selected the Currency Name field and we have choosen to sort datas ascendingly 41 SmallBase User Manual Actually we can define more than one criteria and create
4. Start the link creation in using the main menu or press CTRL L File Edit Table View Control Links Tools Lust tomer Select Pocketl Palmscape Unselect Corisof Add Link Ctrl l Remove Link Shift Ctrl D Cancel 67 SmallBase User Manual Select another item and Apply Link Customer TUJEGT ap PocketlO Palmscape Customer Corisoft Corisoft Label Liste of documents z system apps calc cal File documents photo gallery Nokia Jpg C documents wml SymbianLogo jpq Folder c documents Select the record and open the main menu and select Apply Link or press SHIFT CTRL L to complete the link File Edit Table View Control Links Tools Select TTE Liste of documents C documents photo Unselect Add Link Ctrl l Apply Link Shift Ctrl l Cancel Link Shift Ctrl C Cancel x Remove Link 3Shift Ctrl D i Note that you can cancel a link in progress in pressing Cancel Link 68 SmallBase User Manual Label Liste of documents z system appsicalcical File C documents photo gallery Nokia Liste of documents G documents photo gall 1 9 CA documentsvwmliySymbianLogo jpg Folder c documents Now the link is established between the both records So what s the use of this In fact users now can turn SmallBase into Link mode If you want to retrieve all records from other tables which are linked to the current item Selec
5. TOT Field R2 must be exactly equal to TOT R2 is of course a text based field R2 TOT Field R2 contains a sub string equal to TOT note that the character means that there can be characters on the left and of LIKE the right of the string R2 20 07 2001 Field R2 is a Date field type and R2 20 07 2001 Note that a date must be enclosed into characters R2 20 07 2001 Note that the date can contain a time in this case the format 11 00 must be conformed to the date time international settings on your device R2 2 Relative date can be defined here in this case R2 is date and 2 means Today 2days So R2 Today 2 days 0 means Today For Date Time field types be aware to not use r2 0 if you want r2 today for a such field use r2 gt 1 AND r2 lt 1 insteed because Date Time field contains a time Negative values are allowed 3 The and signs are mandatory R2 02 50 Relative date from now R2 must be a Date Time field type and 02 50 means now 2h and 50 mns Negative values are allowed too 27 SmallBase User Manual The and signs are mandatory R2 01 44 R2 in this case is a duration field type R2 01 44 Note that durations must be enclosed into characters R2 var1 SmallBase allow filter which depends on variables In this case the variable must contains numeric or floting point string Variables can be used for
6. Write User Manual Font System Size 6 Bold Mo Italic Mo Select the font name the size and the attributes Hotkey is used to associate a Key to a Table Organize technical meeti Write User Manual New if you press or t on the keyboard SmallBase will automatically switch to the TASKMAN table if already open or will open it Card View display and Full Screen Mode are directly manageable with hotkeys Press CTRL D will remove Card View for the current table Preferences are stored in the database for each table SmallBase User Manual Priority status Due Date 2 3 Resize Columns Users can use CTRL SHIFT ARROW to increase or decrease the width of the selected column CTRL RIGHT goes to the next column CTRL LEFT goes to the previous column CTRL SHIFT RIGHT increases column width CTRL SHIFT LEFT decreases column width CTRL UP and CTRL DOWN change the sort order of the selected column 20 SmallBase User Manual 3 Manage Records How to add records in the TASKMAN table Press Add button to create a new record in the table Priority gt Status Due Date Close r b Planned S 08 01 2002 S 08 01 2002 Who Project Todo w CallJohn Woo 0 Priority 1 Status p Due Date Planned Close In Progress Who Complete Project I
7. different kind of formula which may contain variable field types In Build mode SmallBase proposes table creation Add table update Edit table deletion Delete and table duplication Duplicate The Esc key returns to normal mode 1 1 Add a new table Ianagediatabdse Mame TASKMAN 0 Create a table named TASKMAN This table can be used to track tasks for example SmallBase User Manual Add Edit Delete Others Manage fields with SmallBase for the current table SmallBase allows here field creation Add field update Edit field deletion Delete and specific operations for Formula and Choice List field types SmallBase User Manual 1 2 Manage fields Label m Visible Yes Type Text Size 50 The field management lets a high level of customization Tab jFeld Comment gt o Field Type General information Labe Label ofthe field display in the columns header Visible Fiidisvisibleornotincarview ee _ e Position in all views aid view card view entering mode Default User can set a default value to this field In the cases of Variable and Choice List types fields users must create first the field without any default value then set the variables or the choice lists and finally set the default value by editing the field again Card View Concern the card view only JL
8. Available Buttons Press Cancel to cancel the current entry Press OK to save the current entry Press Clear clean the current entry with a blank value Auto is a special button and allows different capabilities according to the field type Field type Auto feature Date Time Set the date or date time to the current date time Folders List Open the Folder browser and allow automatic selection of folders Files List Open the File manager browser and allow automatic selection of files 21 SmallBase User Manual Priority Cancel Status Due Date OK Status Due Date 1 Planned 08 01 2002 Todo Call John Woo Priority 1 Status Planned Due Date 08 01 2002 Who Kevin Project POCKETIO Tel 06 05 04 03 02 Note This 15 a note In this case all labels are displayed but users can decide to not display some of them To do this return in Build mode and change field settings Let s enter more records in order to continue with other powerfull features of SmallBase 22 SmallBase User Manual 4 Copy Cut and Paste Copy cut and paste is supported by SmallBase This feature is appliable on the same table or between table if the both tables have the same structure Select more than on Record with SHIFT UP or SHIFT DOWN keys File Edit Table View Control Links Tools T ren oos cut CTX Copy Ctri l Status Planned Paste Ctrl V Due Date 08 01 2002 Who Kevin Ls Project POCKETIO N
9. build in application are located in the ROM so in Z drive Let s start the CALC select the CALC record and press CTRL G Calculator 126 am Xa Close the calc then you ll return immediately to SmallBase 57 SmallBase User Manual Calc z system appstcalctcalc apr Liste of documents C jdocumentsjphoto gallery Mokia jpg CGdocumentssvwml Syml When there is more than one document in the File List field SmallBase opens a list box which contains the files CAdocumentsiphoto gallery Nokia jpg CAdocumentsvwmlySymbianLogo jpg Rotate Zoom In foom out Close 58 SmallBase User Manual 9 3 Manage Folders The Folder List field type can be used to manage your preferred folders SmallBase allows users to define field which can contain folders SmallBase will open a browser view on the path and let s users start files from It Add a new Folder List field type in the START table and enter a path In this case we have edit an entry and set the Folder field to the path C documents Click OK to confirm update Liste of documents GA documentsiphoto gall jpg C documents wml SymbianLogo jpq Folder cXdocuments Compose Ctr Start File Ctrl Open Folders Ctrl b hianLogo jpg Report Sum Selection Ctrl U Set Alarm Shift Ctrl N Cancel gallery Nokia 59 SmallBase User Manual Open the main menu or press CTRL B to open SmallBase fil
10. every kind of fields See Manage Variables chapter in order to understand how variables can be created and updated project SB ict OR RB Sm is complex condition which is completely supported by R4 2 OR R5 SmallBase LIKE SB In our example we will have We PP pg Add All Planned Tasks Edit Delete SM Activate Note that an activated Color setting is displayed with a prefix Users can see easily what kind of Color criterias are active at any time Priority Status Due Date Call John Woo 1 Planned 08 01 2002 Organize technical meeting 3 Complete 07 01 2002 Write User Manual 1 In Progress 09 01 2002 28 SmallBase User Manual 5 2 Manage Filters Filters are managed the same way as colors Insteed of displaying data with a specific color filters keeps in the view only records which match the active filters at a time If more than one filter are activated at the same moment SmallBase will use a AND combinaison between all active filters criterias The creation mode is the same as for the colors see color chapter In our example we will create a filter which display tasks in progress or planned Use the main menu and select Filter in the Table menu pane or press SPACE BAR to open the Filter selector z File Edit View Control Links Tools select Bulla TEL Due Date Select Ctrl 5 Add Ctrl MN Variables Ctrl Filter E ren Colors Ct
11. using unknown or empty variables are automatically ignored by SmallBase Variables may be used in the Variable field types see below 35 SmallBase User Manual 5 4 How to use a Variable field Type A variable type field is used to allow user set different variable value to a field in a record This is very useful when you have to use this field in calculations typical case consists in managing a Currency conversion Table Let s create a Table which contains Text type field 10 chars the name of the currency Exchange Floating point type field The exchange rate for the currency in Rate your money Value A Variable type field which will contains for example the Variable Amount Total A Formula type field which contains this r3 r4 Exchange Rate Value Add Currency Edit Exchange Rate m Value Delete Total Others Let s define the vari able Amount File Edit Table View Control Links Tools Build Ctrl k Select Ctrl 5 Add Ctrl h Variables Ctrl uy Filter Colors Cancel 36 SmallBase User Manual Exchange Rate We have entered 120 as example So how to use this new conversion table We can add a record into the Currency table It can be the reference 3 SmallBase User Manual Exchange Rate Value Total 1 00 Amount 120 00 Of course 120 1 120 Lets see now EUROS in USD with an exchange rate to 1 13 and add it to our Currency Table Cancel OK
12. without limitation damages for ISBs of business profits business interruption ISBs of business information or other pecuniary ISBs arising out of the use or inability to use this Pocket IQ product The SOFTWARE is supplied as is and no advice or technical support is guaranteed from Pocket IQ or any third party SmallBase Introduction SmallBase is an extended databases manager for EPOC systems SmallBase runs on ER3 Series 5 Geofox ER5 Series 5MX REVO Series 7 Netbook and ER6 Nokia 9210 9290 based devices omallBase use the internal EPOC DBMS system in order to store and manage your datas But SmallBase offers much more Use SmallBase to create easily specific applications and manage important datas omallBase offers a high level of customization with data display Users can define color display for datas according in using specific criterias Apply filters on the fly and retrieve quickly datas with an extended search function Encrypt and secure your databases with a single password Based on a 256 bits encryption engine SmallBase can protect your confidential datas with a high level of security SmallBase User Manual 1 Manage Tables and Databases SmallBase databases are composed with tables table contains fields users must first create this structure before entering datas When started SmallBase propose to create a new database named SmallBase on the main disk SmallBase will automatically turn t
13. Open Folders Ctrl B Write User Manual iReport lily sum Selection Ctrl U Set Alarm Shift CtrlaN Cancel INS Eb Organize technical 1 Write User Manual 881800 Al Jt zum Tel 06 05 Note This 15 a note 65 SmallBase User Manual Press OK to validate l Ifall John Won Organize technical meeting ee Write User Manual Mrite User Hanul The report has been generated in the card view All selected lines has been included in the report Users can now print it with the main menu Note that the last line contains for each numeric field the sum of the all records Users can see the report in details with the TAB key TASKMAN Organize technical meeting Write User Manual 66 SmallBase User Manual 11 Extra Linking Feature SmallBase offers an extended linking feature The extra linking feature allows users to create free links between items into the same table or between different kind of tables This feature must be used onto small tables because the display can become slow if there is too much records in a table Let s see this with an example We will create a link on a record from Projects table and a record from START table Open the Projects table and select an item 2 2 Customer Project SB PocketlO Palmscape Customer Corisoft Corisoft We want to link this record with another record from the START table
14. Preferences Ctrl d Cancel Press CTRL H or choose Calculate SmallBase User Manual Complete 3 250 00 In Progress 8 000 00 Planned 94 506 30 All datas are now updated according to the filter and the Sum calculation SmallBase User Manual 2 Manage Windows 2 1 Windows Navigation The SmallBase table display is splitted into 2 different part the grid view and the card view The display is entirely customizable Each table stores its own preferences Users can switch between the grid and the card views with the TAB key CTRL TAB is used to switch between displayed tables TASKMAN 2 2 Customize display The Card View can be removed separately for each kind of Table The Grid font and the font size can be changed The Zooming feature is applicable either on the card view or the grid view according to the focused window Open the main menu and select Preferences in the View menu panel File Edit Table View Control Links Tools Select Zoom In Ctrl Zoom Out Shift Ctrl fyl Refresh Ctrl R Card View Font shift Etrl F Preferences 1 Show Hide Card View Ctrl D Cancel hul SmallBase User Manual Organize technical meeti Write User Manual Card Ves Card View Size 50 Full Screen Mode No Show Grid No Display or Remove Card View manage size set or not the full screen mode show grid lines or not Organize technical meeti
15. SmallBase The TASKMAN table view will be updated according to the Projects table view If you select an item in the Projects table view the field r2 Project will contain a certain value When you switch to the TASKMAN table view the active filter will be updated with this new value and the filter will be applied on the view Let s see this with an example Activate only this new filter Mot complete yet Project Link to Projects Select an item in the Projects table view 46 SmallBase User Manual 2 2 Customer Project SB PocketlO Palmscape Customer Corisoft SB Corisoft Now the selected project is SB Let s see the result when return to the TASKMAN table view Project Todo Write User Manual Priority 1 Status In Progress Due Date 09 01 2002 Who Ericson Project SB Cost 0 00 Hours 0 m E Js gn gen We can check that only record which refers SB in project field are displayed Let s return to Projects table view and select another project 1 2 Customer Project 0 Pocketl Palmscape Customer Palmscape Dori soft We return again in the TASKMAN table view 47 SmallBase User Manual Todo Call John Woo Priority 1 Status Planned Due Date 08 01 2002 Who Kevin Project Tel 06 05 04 03 02 Note This 15 a note Now records which contains POCKETIQ project are displayed This feature
16. SmallBase User Manual Corisoft Date 03 07 02 INTRODUCTION 5 1 MANAGE TABLES AND DATABASES 6 1 1 ADD A NEW TABLE 7 1 2 MANAGE FIELDS 9 1 3 HOW TO MANAGE A CHOICE LIST 12 1 4 HOW TO SET A FORMULA 13 1 5 HOW TO SET A CALC FIELD 15 2 MANAGE WINDOWS 18 2 1 WINDOWS NAVIGATION 18 2 2 CUSTOMIZE DISPLAY 18 2 3 RESIZE COLUMNS 20 3 MANAGE RECORDS 21 4 COPY CUT AND PASTE 23 5 MANAGE COLORS FILTERS VARIABLES AND SORTING OUT METHODS 24 5 1 MANAGE COLORS 24 5 2 MANAGE FILTERS 29 5 3 MANAGE VARIABLES 31 5 4 HOW TO USE A VARIABLE FIELD TYPE 36 5 5 MANAGE SORTING OUT METHODS AND INCREASE SPEED 41 5 6 MANAGE FILTERS AND COLORS WITH TABLE LINKS 45 6 SEARCH 49 7 MANAGE FILES AND DATABASES 51 7 1 OPEN AND CREATE DATABASES 51 7 2 COMPACT AND REPAIR DATABASES 52 8 PROTECT DATABASES 9 ACTIVE FIELDS AND AUTOMATION 9 1 MAKING A PHONE CALL 9 2 START A DOCUMENT OR AN APPLICATION FROM SMALLBASE 9 3 MANAGE FOLDERS 9 4 QUICK CALCULATIONS 9 5 SET ALARMS ON ITEMS 10 PRINTING AND REPORT 11 EXTRA LINKING FEATURE 12 EXPORT AND IMPORT 12 1 IMPORT 12 2 EXPORT 53 55 55 56 59 61 62 65 67 71 71 71 LICENCE AGREEMENT The Pocket IQ End User Licence Agreement EULA is a legal agreement between you and Pocket IQ Limited By downloading or installing this SOFTWARE you agree to be bound by the terms of this Agreement If you do not agree to the terms of this Agr
17. abel Yesor No label appears or not in card view 56 Foreground color of the displayed data the card view fFont Default or select a specific font to display data Sze Bod bee gt ae YeNo gt Display Concern the dialog box when editing data dit Box Width Size of the edit box Lines Number of lines in the dialog box only for multilines field types Sorted Only for Choice List field types items are or not L de alphabetically order SmallBase User Manual Grid Concem the grid view Column Size Width in twips of the column field is not displayed in the grid if column size 0 Display Value Only for Variable field type in this case the value of the variable is displayed insteed of the variable name SmallBase User Manual Repon Goxemmpots _ Column Size Width of column in number of Chars For our example we create a Table with those fields Field Type Comment _ 0 1 Status Choice List Green Planned In Progress Complete Due Date Date Red The due date of thetodo Note LongMemo Black Notes Files A list of files Floating The unit cost of workload m Number of hours spent on this todo Total Formula Red Total CostHour Press Cancel to stop creation loop Priority Status Due Date Close SmallBase User Manual 1 3 How to manage a choice
18. age Filters and Colors with Table Links Another great feature of SmallBase consists in creating Filters and Colors criterias which support fields from others tables The previous example can become totally dynamic in using a table which contains Project ids Let s create a new table Projects which contain 2 text fields Project and Customer MELET Name Projects ___ Project Customer 1 2 Customer Project PocketlQ PocketlQ Palmscape Customer Palmscape Corisoft We will now open the TASKMAN table and create a filter which refer the Projects Table 45 SmallBase User Manual J rer on r colors Exam JE ples Label w LinktoProjects 0000 Active No Table TASKMAN Available Fields r Project Criteria iB Projeetsi2 0 Note that as for variables the reference to the Projects table fields must be enclosed into 9e chars We can create different kind of link and mix more than one table in the criteria To help users remember valid fields in current database Tables a choice list has been added to select the table so available fields choice list is updated according to selected table How SmallBase deal with this In fact to use a such filter you must open all referred tables in the criteria In our case open the TASKMAN table and the Projects table As for variables if referred tables are not opened criterias are ignored by
19. an be used in the clause condition In our case we enter Active Mo Available Fields r Status Criteria idzplamed r2 gt 23 amp r2 lt r3 r4 ER r5 23 08 1963 r6 gt 1 2 The request is very simple here but SmallBase allows much more complicated for clause What about the Colors Tab Apply on Whole Line Foreground m Background Style Mormal 25 SmallBase User Manual By default the color is applied on the whole line but the color can also be applied on a specific cell corresponding to a column field Change OK Apply on Cell only Select Todo Foreground m Background Style Normal In this case we have selected the Cell corresponding to the todo column Examples are just here as a reminder and can help users to understand what are the capabilities of SmallBase for criterias rl gt 10 amp r2 lt 30 Numeric comparison A Fh A EN Ph Ph Fh iP 26 SmallBase User Manual SmallBase allows complex combinaisons of fields into the clause condition amp Tmscharaderrepresenisa AND condon _ AND AND Keywords iso supported i This character represents a OR condition OR keyword is also supported This charactor represents a LIKE ondion _ I Parenthesis allowed for complex formulas R2 gt 10 Field R2 must be greater than 10 R2 is of course a numeric or floating point field type R2
20. e browser o43 23 08 0 0056 03 08 0 436 30 07 0 88 269 1 110 Browse the folder or select a file and start it by pressing the ENTER key Let s start sheet Ca photo gallery Ca wml devis 1 BAS 23 08 0 Recorder wav 20066 O3 08 0 tg Sheet 436 30 0770 ga SmallBase dat 60 SmallBase User Manual 9 4 Quick Calculations Quick Calculations is another useful feature of SmallBase Quick Calculations allows users to do fast sum min or max calculation on a selection or on the entire view SmallBase will select all numeric and floating point fields in the table and will calculate the fields sum for the selection or for the entire view Select Compose Ctrl Q start File Ctrl G Organize technical i Open Folders Ctrl B Write User Manual Report Sum Selection Ctrl t Set Alarm Shift CtrlaN SP S ERE LI Select Organize technical Write User Manual Cancel I Priority 5 Cost 2 950 10 Hours 78 Organize technical meeting Total 105 756 30 Write User Manual The result is displayed in the card view 61 SmallBase User Manual 9 5 Set Alarms on items An alarm management feature has been added into SmallBase Users can now create alarms on each records of the displayed view The alarms are available ONLY if SmallBase is running Important Note alarms are disactivated on a password protected database when SmallBase goes to the foreground t
21. eement remove this SOFTWARE immediately Pocket IQ END USER LICENCE AGREEMENT EULA This licence refers to any product which is distributed by Pocket IQ GRANT OF LICENCE This Pocket IQ Licence Agreement Licence permits you to use one copy of this product on multiple machines which may include user documentation provided in electronic form SOFTWARE providing it is for the sole exclusive use of the registered user The SOFTWARE is licensed as a single product Its component parts may not be separated for use on more than one computer or by more than one user at any one time COPYRIGHT The SOFTWARE including any images and text incorporated into the product is owned by Pocket IQ and the independent pplication author or its suppliers and is protected by English copyright laws and international treaty provisions REVERSE TRANSLATION The SOFTWARE including all related program files may not be altered in any way Reverse Translation is expressly forbidden without written permission of the Pocket IQ and the independent application author LIMITED WARRANTY To the maximum extent permitted by applicable law Pocket IQ and the independent application author disclaims all warranties either express or implied including but not limited to warranties of merchantability and fitness for a particular purpSBe In no event shall Pocket IQ the independent application author or its suppliers be liable for any damages whatsoever including
22. enu pane Priority status Due Date fj zi Database SmallBase omallBase stores the recents files in a choice list so the database selection is really easy Users can remove a file from the history list by pressing the BACKSPACE key The New button allows the creation of a new database Navigate through the file manager and open a SmallBase file with the Browse Button The selected file will be automatically added to the history list The database can be easily reopened 51 SmallBase User Manual 7 2 Compact and Repair databases omallBase databases can be compacted at any time After lot of updates it s recommended to do a compaction of the database in order to reduce the size of the file This is valuable for ER3 and ER5 devices EPOC DBMS has been more optimized in ER6 this operation is not always required but recommended Use the main menu and select Compact Edit Table View Control Links Tools ke tion Select rer i Open mel Cost 2 950 10 Compact Shift Ctrl k Hours 78 Repair sd Total 105 756 30 Import Export _ Printing Cancel To repair a database choose Repair insteed of Compact When repainring a database SmallBase does first a destroy of all existing indexes on the tables a recover of the database after a damage check and a reindexation of the database according to the permanent indexed fields Use the main menu and select Repair 52 SmallBase User Manual 8 Pr
23. ext Ltr Tel 06 05 04 03 02 Note This is a note Cancel Priority Status Due Date Call John Woo 1 Planned 08 01 2002 Organize technical meeting 3 Complete 07 01 2002 Write User Manual 1 In Progress 09 01 2002 23 SmallBase User Manual 5 Manage Colors Filters Variables and Sorting Out Methods 5 1 Manage Colors Cell or line colors can be choosen according to specific criterias Each table can be color customizable and manages its own parameters Colors are appliable on the fly For example we can set a specific color for records which have a status Planned Open the main menu and select Colors in the Table menu press SHIFT SPACE BAR to open the color selector View Control Links Tools i Build Ctrl k Select Ctrl s Add Ctrl h Variables Ctrl V Filter Ctrl H Colors Cancel Due Date anned 08 01 2002 implete 07 01 2002 Progress 09 01 2002 Users can now Add Edit Delete or Activate new Color settings Add a Color criteria for records which have a status equal to planned Press Add button 24 SmallBase User Manual Active Mo Available Fields r2 Todo Criteria r25 23 amp r2 r3 r4 FER fr5 23 08 1983 r6 2 Define a label to remember easily what kind of criteria has been defined The criteria can be Active or Not at a time Available fields with their labels are displayed for the current table in in a choice list and c
24. he database is closed and encrypted Alarms wakes up your device even if this one is not powered on SmallBase use the default agenda alarm for Nokia ER6 based devices 9210 9290 but can be selected on ER3 ER5 based devices Todo Organize technical meeting Priority 3 Call John Woo Status Complete Organize technical meetinc Due Date 07 01 2002 Write User Manual Close 06 01 2002 Who ESN Project PEX Note Mr bean has been present m File Edit Table View Control Links Tools Compose Ctrl start Filg Ctrl Open Folders Ctrl B Report Sum Selection Ctrl l Set Alarm Shift CtrlaN present Cancel Use the main menu or press SHIFT CTRL N 62 SmallBase User Manual Be PLEN i 2 3 Brose Todo Todo Organize technical meeting OK Project PBX Note Mr bean has been present 3 gn a Todo Organize technical meeting Priority 3 Call John Woo Status Complete Organize technical meetinc Due Date 07 01 2002 Write User Manual Close 06 01 2002 Who ESN Project PEX Note Mr bean has been present Ph Js gam Note the small rect added to the left of the record this means that the record has an alarm positionned For the example we can switch to another table T2 Customer Project PocketlQ Palmscape Customer Palmscape Corisoft For this example press Extra or System button to make SmallBase goes foreground You can a
25. list Go on the Status field and press Others omallBase offers the capability to enter choice list strings Users can now Add Edit or Delete entries in the list Haws manage Goote SL Label w Planned In Progress Complete Press Close to come back to the main list SmallBase User Manual 1 4 How to set a formula Select the Total Field in List and press Others Available Fields r3 Priority Available Functs A0 Formula 2 sin 45 r1 3 r0 The formula is composed by a combinaison of values fields variables and mathematics functions In order to help users to remember what are the available fields for the selected table SmallBase displays the fields and the labels in a choice list The Functs list is also displayed in a choice list to help user with the syntax In our example we can enter r13 r14 in the Formula field Add Edit Delete Duplicate The table has now been created Close the dialog box with Esc key SmallBase User Manual TASKM SmallBase is now waiting for a Table selection We can select TASKMAN in pressing Enter key Priority TASKMAN Table is now displayed SmallBase User Manual 1 5 How to set a Calc field In order to explain the use of a Calc field create a new Table called COSTS This field will contain 2 fields Status Text and Total Calc Add Status Edit T
26. lso turn your device off 63 SmallBase User Manual 10 05 CALC TAT SHELL Smallase broadcast O SmallBase wakes the device up and bring SmallBase to foreground IM TASKMAN P SmaliBase Alari Press a Key to Continue Write User Ma Note Mr bean has been present e M gn The alarm sound will be played 5 times with a pause of 30 secs between each Press OK to stop the alarm and close the dialog box 9 Todo Organize technical meeting Priority 3 Organize technical meeting status Complete Write User Manual Due Date 07 01 2002 Close 06 01 2002 Who ESN Project PEX Note Mr bean has been present Js gn ar omallBase has automatically open the concerned table and has located the cursor on the record 64 SmallBase User Manual 10 Printing and Report The printing feature is really simple SmallBase can print what is displayed in the Card View 50 users can print the current record a Quick Sum calculation or a Report Edit Table View Control Links Tools fc tion T Open Ctrl 0 Cost 2 950 10 Compact Snift Ctri k Hours 78 Repair Total 105 756 30 Import pat Page Setup Shift Ctrl U Printing Print d Users can change page setup before print How to generate a report Open the main menu and select Report File Edit Table View Control Links Tools Bction Compose Ctrl Start File Ctrl Organize technical m
27. o Build mode Table Fields can have different types SmallBase supports the fields types decribed below I HEMNEM PHEME N Memo char 1 288 max Mollinestex fed N Numeric Integer 4byes O ON Floating point Decimal 8byes N Date Date Time 8byes N Duration integer 4byes Duration as 0000 N Date with time I Choice List Char 1 1 255 1 255 List of user defined text dmi Memo Unlimited Multilines text field without any size limitation mali _ 1 255 Text field used pg number by the engine composable Floating point 8 bytes field according to Y user defined arithmetic sets which allow fields combinaison File List Char Unlimited Multilines text field which Y contains a list of files separated with a char Folder List Char Unlimited Multilines text field which Y contains a list of folder separated with char SmallBase User Manual Calc Floating point 8 bytes Calculated field according to Y a referred field in another Table The calculation can be Sum Max Min or Average The calculation is based on a filter applied on the referred table Nm Variable Char 50 Max This field contains the name Y of a variable see variables chapter The field may be displayed by its name or its content his field is useful for formulas Users can define
28. otal Delete Others Card View Sum Table TASKMAN Available Fields 1715 Total In this case we will set the Total field of COSTS table equal to the sum of Total field from TASKMAN this for all records of the TASKMAN table But we can set a filter insteed of summing all records This filter can be set on the Status for example In our case we can link the Status field of the current record from COSTS table with the Status field of the TASKMAN table Press the Filter Tab SmallBase User Manual Calc r2 gt 23 amp r2 lt r3 lird ER r52123 208 1963 r6 gt 2 The filter syntax is the same as for the Filter Color feature see below Now the calculation will be done on each record and the filter will be applied on the oum request according to the contains of the Status field from the COSTS table SO we can create 3 records in the COSTS table with a Status equal respectively to Planned In Progress and Complete Complete In Progress Planned We can notice that after the added records are not automatically updated This is normal in order to not slow down the application the calculation update is manual Open the main menu and select the View Pane File Edit Table View Control Links Tools In Progress Zoom Out shift Ctrl hl x i menu Zoom In Planned Refresh Ctrl F Calculate Ctrl H Card View Font Shift Ctrl F
29. otect Databases A really great feature of SmallBase consists in protection of your confidential datas SmallBase integrates a powerful encryption engine This encryption engine is based on the popular Encrypt it software for EPOC devices from Peter Csutora SmallBase use a 256 bits encryption key based on user defined password Users can use the same password for all databases the file encryption will be different each time Without the right password for a protected database the datas are definitively lost Encryption is automatically applied on the file after closing the database or when SmallBase goes background When SmallBase regains the focus SmallBase will ask for the requested password will decrypt the file and will finally reopen the database Without the password the database can t be reopen Users must take in account the encryption calculation delay depends on the EPOC device when using this feature for opening a database It is recommended to activate this feature on small databases File Edit View Control Links Tos lt Due Date 3 01 2002 Select Add Ctrl N Variables CtrlH V Filter Ctrl H Colors Ctrl Set Password Shift Ctrl s Priority Status Due Date 53 SmallBase User Manual Priority Status Due Date Call John Woo 1 Planned 08 01 2002 Write User Manual 1 In Progress 09 01 2002 The file is now password protected Switch to another task Extras b 1158
30. rl Cancel anned 08 01 2002 omplete 07 01 2002 Progress 09 01 2002 Add Edit Delete Activate Press Add button to add a new filter 29 SmallBase User Manual Label Motcompleteyet Active Yes Available Fields r Status Criteria e 4o complete 0000 0 r2 gt 23 amp r2 lt ra lird ER r52 23 08 1963 r6 gt 1 2 Note that the Color and Filter dialog boxes are the same Colors Tab is grayed because not available for filters Add Edit Delete Activate Priority Status Due Date Call John Woo 1 Planned 08 01 2002 Write User Manual 1 In Progress 09 01 2002 30 SmallBase User Manual 5 3 Manage Variables SmallBase Filters and Colors criterias support variables Variables must be enclosed into characters A variable is represented with a label and a value There is no limitation for the number of variables but memory A variable is a string of 255 chars max A variable can contains anything A variable can be a numeric a floating point even a date Actually variables are stored into the database as entered no check is done after entering the value Variables are very useful because they make filters and colors become dynamic Variable must be created manually Variables are available for all Tables in the same database Use the main menu and select Variables in the Table menu pane File Edit Table View Control Links Tools
31. sofisticated indexes The fields must be separated with a comma and must have a keyword ASC for ascending sort or DESC for descending sort Every kind of fields can be used in the sorting out methods A database with lot indexes may take time on compaction or on repair GULEN ALT SE gt 1 made Sortine Add Currency Currency Edit Delete Activate The sorting out method must now be activated to be available Press ACTIVATE do set it as the default sorting out method Add Edit Delete Activate Now the datas are sorted according to the Currency name You can increased data search in selecting the right index according to what you are searching Example We have a dictionnary table composed with a word and its translation Its a good thing to add a sorting method on the Word field When you re looking for a word SmallBase might find it 10 times faster 42 SmallBase User Manual Currency Total EUR 1 00 200 00 USD 1 13 226 00 We can also create a sorting out method on the Total and sort datas according to the total descending Currency Total Activate the new sorting out method Note that only ONE method can be used at the same time For combinaison with more than one field create more than one Sorting Out methods 43 SmallBase User Manual TET V Currency Total USD AE 226 00 EUR 1 00 200 00 44 SmallBase User Manual 5 6 Man
32. t the current item and press CTRL Y 11 Current item Selected Customer Project SE Customer Corisoft The current table contains only records which are linked to the selected one The current selected record is displayed with a In this table no more linked items are found Open the START table to see if the linked items are also displayed 1 1 Label Liste of documents File C documents photo gallery Nokia IPG C documents wml SymbianLogo jpq Folder c documents 69 SmallBase User Manual We retrieve the current linked item displayed To come back SmallBase Normal Mode users can press SHIFT CTRL Y or select again the selected item Label Calc Calc Re ttn File z system apps calc calc app Tahle Liste of documents C documents photo gall Add Find SmallBase has returned Normal Mode 70 SmallBase User Manual 12 Export and Import 12 1 Import Users can import datas into SmallBase from text files CSV or from FoxPro DBASE ILIV IV files Users can also import tables from Power Data ProjXpert DCP Business Warrior OPL applications and some of other EPOG applications Users can also import tables from other SmallBase files with the Merge item menu i Account LE Ctri 0 4 970 00 9 470 00 5166665544 DUC Compact shitt Ctrl k Repair Merge Import jJ csv Text Export DBASE DBF Prin
33. ting EPOC Cancel Before importing from CSV Comma separated value files users must create the database structure and datas must be in accordance with the table and fields format Its recommended to add some test datas in the table and do a CSV export to understand what s the expected input format For CSV format strings must be enclosed into characters Users can t have to create table structure when importing from DBASE files The table structure will be automatically generated by SmallBase 12 2 Export Users can also export datas from SmallBase into text files The files can be CSV or HTML 71 SmallBase User Manual Select Open Ctrl 0 IE CU S TORBEI Pals Compact Shift Ltrl k Repair Import CSV Text Shift Ctrl Q Export HTML Printing Card View Cancel Another useful feature of SmallBase consists in exporting the card view Users can easily export the current record a Quick Sum calculation or a report into a text file 12
34. works also with Colors 48 SmallBase User Manual 6 Search SmallBase offers an extended search feature Use the main menu or press directly the Find button PTR zx Cut run il Due Date Copy Ctrl C 1 Planned 08 01 2002 Paste Ctrl V Find Ctrl F Next Ctrl Keyword w m nal 0 0 0 0 0 0 0 0 0 As Filter No Field All Direction Forward Case sensitive No search feature is working 2 ways Classical search SmallBase goes on the first matching row Extended search SmallBase filter datas and display only matching rows In this case this new filter is added to the active ones SmallBase can perform the search on all fields or on a specific field SmallBase can search data from the current row forward or backward The search can be case sensitive Search can be done on a substring or on the exact word 49 SmallBase User Manual For classical search SmallBase will locate the next row matching the condition in pressing Next in the main menu or CTRL 4 50 SmallBase User Manual 7 Manage Files and Databases 7 1 Open and Create Databases SmallBase can manage more than one table in one database but only one file at once For this reason file selection has been improved to make it much easier Open or create new SmallBase databases with only one dialog box Press File button or use the main menu and select Open in the File m
Download Pdf Manuals
Related Search