UPDATED August 11 1998 LIB 4 - Superbase 2.x 2BODY.ZIP/Binary Bytes: 65697, 05-Jul-95 Uploaded by: [73113,3355] Title : Example of 2-Body Report. Working App Version 2 KeyWords: 2-BODY REPORT CALCULATED Comments: This is a working version of an app that has a 2-body report. You must click the statement button at the bottom of the main form. This was mostly done in 2.0 style. No object stuff here. Sorry. Others have asked for info on the 2-body reports and I think this will help. Goodluck. 4028.TXT/Text Bytes: 8661, 09-Jan-97 Uploaded by: [74774,561] Title : Error deleting key, error reading block KeyWords: TECHNOTE ERROR DELETING KEY READING BLOCK Comments: The solution to the error messages "Error deleting key - Error 100/101/102/103" or "Error Reading Block - Error 200/201" etc. is to reorganize the file. This technote is intended to explain what these errors are and to give some hints as to how to help avoid them. 4029.TXT/Text Bytes: 3643, 09-Jan-97 Uploaded by: [74774,561] Title : Mouse event in Superbase KeyWords: TECHNOTE MOUSE EVENT Comments: An event procedure is a SUB procedure that is triggered by an event, such as a mouse click or a keystroke, and responds by executing the code for the event. Superbase supports seven event classes. This technote concentrates on a mouse event and its use during data entry in a multi-file form. This technote uses the example files from the STOCK directory to illustrate the example. 4030.TXT/Text Bytes: 3529, 09-Jan-97 Uploaded by: [74774,561] Title : Superbase Menu Bar KeyWords: TECHNOTE MENU BAR Comments: This technote explains how to create a customized menu bar and how to get back to the Superbase default menu. 4031.TXT/Text Bytes: 2837, 09-Jan-97 Uploaded by: [74774,561] Title : Query-By-Form using Superbase KeyWords: TECHNOTE QUERY FORM Comments: This technote addresses a different method of creating queries than the usual filter dialog, Quick Reports, or Query by Example (QBE). This method is generally referred to as Query-By-Form. It is a simple method of building queries providing a no training query interface for end-users. This technote takes advantage of the extra procedure libraries provided with Version 2.0 of Superbase to make an easy and intuitive query interface. 4032.TXT/Text Bytes: 5551, 09-Jan-97 Uploaded by: [74774,561] Title : Setting the state of an icon button KeyWords: TECHNOTE ICON STATE Comments: Setting the state of a particular icon button using the ICON command in SBL lets you control whether an icon is displayed as Selected, Enabled, or Disabled. However, when an icon bar button is attached to an internal procedure, the state of the button becomes the responsibility of Superbase and cannot be set or controlled by the programmer. Also, once an ICON command is issued to change the state of an icon bar button, it is only necessary to issue an ICON ON command to refresh the icon bar. 4033.TXT/Text Bytes: 5725, 09-Jan-97 Uploaded by: [74774,561] Title : Creating a Report with different output choices KeyWords: TECHNOTE REPORT OUTPUT Comments: This technote shows you how you can create a report quickly and be able to modify the corresponding SBL program so that the report can be sent to a different destination than those available from a Report Designer Report. 4034.TXT/Text Bytes: 7200, 09-Jan-97 Uploaded by: [74774,561] Title : Modifications to the .SBP generated by the Dialo KeyWords: TECHNOTE DIALOG EDITOR MODIFICATIONS Comments: After you create a dialog with the Dialog Editor, there are certain steps you need to take to be able to call the dialog from within a program. If your dialog contains list boxes, combo boxes, or nested dialogs, you must make additional changes. 4035.TXT/Text Bytes: 2906, 09-Jan-97 Uploaded by: [74774,561] Title : Object Linking and Embedding KeyWords: TECHNOTE OBJECT LINKING EMBEDDING Comments: Object Linking and Embedding (OLE) is like Dynamic Data Exchange (DDE) in that it enables you to access objects that are stored in another product. However, instead of requesting data from another product, OLE lets you use the other product as if it were an extension of Superbase. 4036.TXT/Text Bytes: 2819, 09-Jan-97 Uploaded by: [74774,561] Title : Deleting Records from Master and Detail File KeyWords: TECHNOTE MASTER DETAIL DELETE Comments: When deleting records in a master file, it is often necessary to delete matching records in a detail or transaction file. Superbase 2.0 provides a menu item, specifically, Data | Remove | Cascade, which does this for you, but the option is only available when a linked form is open. This technote demonstrates how to delete a record from a master file along with all matching records from a detail file using SBL. 4037.TXT/Text Bytes: 5469, 09-Jan-97 Uploaded by: [74774,561] Title : Creating Scalable Forms KeyWords: TECHNOTE SCALABLE FORMS Comments: This technote illustrates how to create a form that scales depending on the screen resolution which is currently in use. This is useful for developers who wish to keep the form at a constant size in relation to the form's actual developed resolution when displaying the form on systems with different resolutions. 4038.TXT/Text Bytes: 2645, 09-Jan-97 Uploaded by: [74774,561] Title : Separate Queries to the Same Output Window KeyWords: TECHNOTE QUERY OUTPUT WINDOW Comments: Querying to a window is a common way to view data. Unfortunately, if you use only the SELECT command, there is no way to APPEND to an output window so that multiple queries output to the same window. This technote shows you a method you can use to output multiple queries to the same window. 4039.TXT/Text Bytes: 4173, 09-Jan-97 Uploaded by: [74774,561] Title : Reporting Totals Using SBL KeyWords: TECHNOTE REPORTING TOTALS Comments: This technote describes how to calculate totals for a database file using a short SBL program. You will find that once you have learned the basics, you can do more sophisticated tasks by modifying the SBL code. 4040.TXT/Text Bytes: 3050, 09-Jan-97 Uploaded by: [74774,561] Title : Debugging Custom Reports KeyWords: TECHNOTE DEBUG CUSTOM REPORTS Comments: Custom Reports are often difficult to debug. When a report is saved, the associated .SBP file that is created has several OUTPUT REPORT PAGE statements, but does not contain details about the actual report page. To better troubleshoot your reports, you need to combine the .SBP file that is generated when the report is saved with the .SBP file that is generated when the report is saved as a program. 4041.TXT/Text Bytes: 12080, 09-Jan-97 Uploaded by: [74774,561] Title : Developing Runtime Applications KeyWords: TECHNOTE RUNTIME APPLICATIONS Comments: This technote covers the fundamental concepts of developing runtime applications using the powerful SBL. The Stock Control System application which comes with Superbase 2.0 is a good example of a complete runtime application with the exception of its use of Query-by-Example, which is not available in the Runtime System. The application has complete error trapping and always remains under program control. 4042.TXT/Text Bytes: 4624, 09-Jan-97 Uploaded by: [74774,561] Title : Modifying Forms to Point to Data Files KeyWords: TECHNOTE FORMS DATA FILES Comments: Superbase 2.0 stores the path and filename of each data file that is used on a form when the form is designed and saved in the Form Designer. Here's how to modify form files so that they point to data files in a specific directory. 4043.TXT/Text Bytes: 3178, 09-Jan-97 Uploaded by: [74774,561] Title : Printing Forms with Detail Blocks KeyWords: TECHNOTE PRINT FORMS DETAIL BLOCKS Comments: This technote explains how to print a form with many detail records without the detail records repeating and with the last page of the detail records having blank rows if the number of detail records remaining is less than the number of detail rows on the form. 4044.TXT/Text Bytes: 3386, 09-Jan-97 Uploaded by: [74774,561] Title : Suppressing Blank Lines in Reports KeyWords: TECHNOTE BLANK LINES REPORTS Comments: When you print a report you may have optional fields that you only want to print when the field contains a value. This typically happens when multiple line addresses are allowed, for example. Address1, Address2. 4045.TXT/Text Bytes: 2480, 09-Jan-97 Uploaded by: [74774,561] Title : Building an Array from a Data File KeyWords: TECHNOTE ARRAY UNIQUE DATA FILE Comments: Building an array with unique values from a data file is a useful technique for displaying a pick list in a Request Box 20 or in a combo or list box in a dialog box. Building an array so that it contains only unique values from a data file requires the use of the Superbase SELECT query statement and the AFTER SELECT statement. 4046.TXT/Text Bytes: 1060, 09-Jan-97 Uploaded by: [74774,561] Title : Hiding the Superbase MRU List KeyWords: TECHNOTE HIDE MRU LIST Comments: This technote explains how to hide the MRU (Most Recently Used) list of files. By modifying the menu bar using the Menu editor, you can avoid seeing the MRU list of files. 4048.TXT/Text Bytes: 14789, 09-Jan-97 Uploaded by: [74774,561] Title : Running on Local Area Networks KeyWords: TECHNOTE LAN NETWORKS Comments: The Superbase version 2.0 Install program allows you to decide the type of locking to install for Superbase (single user, LAN, or distributed LAN locking) and for the LAN versions only, the maximum number of users to set Superbase up for. This information is contained in the SBINFO.DLL file. 4049.TXT/Text Bytes: 4005, 09-Jan-97 Uploaded by: [74774,561] Title : Superbase 2.0 Third Party Books KeyWords: TECHNOTE THIRD PARTY BOOKS Comments: We are frequently asked if there are any publications on Superbase 2.0, Here is a listing of books we know to be available. 4050.TXT/Text Bytes: 3879, 09-Jan-97 Uploaded by: [74774,561] Title : Manipulating Records of a Detail Block KeyWords: TECHNOTE DETAIL BLOCK NETWORK Comments: Manipulating detail blocks that reside on a network often requires you to use different, and often complex, techniques to do tasks which in the usual single user environment requires little or no coding. 4051.TXT/Text Bytes: 9495, 09-Jan-97 Uploaded by: [74774,561] Title : Merging Superbase Data into MS Word via DDEPOKE KeyWords: TECHNOTE MS WORD DDE DDEPOKE Comments: This technote illustrates an alternative method to placing data into Microsoft Word for Windows documents from Superbase. Unlike the prior methods of placing a paste linked field onto a document, this method relies on using Word bookmarks and Word reference fields to place data into a Word document. This method provides greater control over what is being sent to the Word document. 4052.TXT/Text Bytes: 2828, 09-Jan-97 Uploaded by: [74774,561] Title : Printing Avery 5160 Labels Using a Form KeyWords: TECHNOTE LABELS 5160 FORM PRINT Comments: This technote explains how to design the layout of a mailing label form and print the form. 4053.TXT/Text Bytes: 1911, 09-Jan-97 Uploaded by: [74774,561] Title : Using Long Text to Create Memo Fields KeyWords: TECHNOTE MEMO LONG TEXT Comments: You can use long text fields as memo fields in Superbase since a long text field can accommodate up to 4000 characters. An ideal memo field has scroll bars attached to it (for easy reading). In addition, it's probably a good idea to make the field read only. This technote explains how to create a read-only long text field with scroll bars on a form. 4054.TXT/Text Bytes: 5915, 09-Jan-97 Uploaded by: [74774,561] Title : Creating a Summary Report KeyWords: TECHNOTE SUMMARY REPORT Comments: This technote explains how to create a custom report that prints only the summary information of a report. The scenario used here is based on the Customer and Order files found in the Samples/Stock directory. The report prints the number of orders by state as well as the number of orders for a particular month. 4055.TXT/Text Bytes: 14559, 09-Jan-97 Uploaded by: [74774,561] Title : Creating a Dialog Box with Linked List Boxes KeyWords: TECHNOTE DIALOG BOX LIST Comments: This technote demonstrates how to mimic the Superbase Field Selection dialog box (with some minor differences). The Superbase Dialog Editor allows list boxes to be used, but not to select items from one list and display them in another. This technote explains how to accomplish linked list boxed through program control. 4056.TXT/Text Bytes: 10782, 09-Jan-97 Uploaded by: [74774,561] Title : Date Calculations KeyWords: TECHNOTE DATE CALCULATIONS Comments: This technote explains how to do date calculations giving examples of some common applications. You may also want to review technote 4025: All About Dates for a review of how Superbase handles and stores date types. 4057.TXT/Text Bytes: 4489, 09-Jan-97 Uploaded by: [74774,561] Title : Merging .SBF Files KeyWords: TECHNOTE MERGING DATA FILES Comments: In the majority of applications, files to be merged have the same file structures. Consequently, this technote describes the merging process as applied to .SBF files with identical file definitions, so the records in both files contain an identical number of fields with the same field order, data types and formats. 4058.TXT/Text Bytes: 2047, 09-Jan-97 Uploaded by: [74774,561] Title : Rearranging the Order of Fields in Data Files KeyWords: TECHNOTE REARRANG FIELD ORDER Comments: This technote explains how to rearrange the physical order of fields within data files in Superbase. It is common, when creating a file, to forget key elements of data, or to uncover a need for additional information during application development. The following steps show you how to permanently rearrange the order of fields in your files. 4059.TXT/Text Bytes: 4345, 09-Jan-97 Uploaded by: [74774,561] Title : Creating a Custom Report with Columns KeyWords: TECHNOTE CUSTOM REPORT COLUMNS Comments: This technote explains how to create a custom report with columns using a single database. Creating columns requires placing field variables in the Report Designer to represent the columns and then assigning values to the variables in the report program. This technote explains how to setup the report and then modify the report code. 4060.TXT/Text Bytes: 1439, 09-Jan-97 Uploaded by: [74774,561] Title : Formatting a Social Security Number Field KeyWords: TECHNOTE SSN FORMAT Comments: This technote explains how to format a valid social security number field. 4061.TXT/Text Bytes: 4788, 09-Jan-97 Uploaded by: [74774,561] Title : Outer Joins in Reports KeyWords: TECHNOTE OUTER JOINS REPORTS Comments: This technote explains how to do an outer join in Superbase using Custom Reports with one or more linked files. 4062.TXT/Text Bytes: 3335, 09-Jan-97 Uploaded by: [74774,561] Title : DLL Calls to Windows System Functions KeyWords: TECHNOTE DLL CALLS Comments: This technote provides a few hints for developers creating end-user applications. For example, when your user is running the Superbase application, you might not want them to accidentally close it by double clicking on the application control-menu button (the icon in the upper left corner). This technote shows you how to turn off the control-menu button, maximize, and minimize buttons in the Superbase Window. 4063.TXT/Text Bytes: 7555, 09-Jan-97 Uploaded by: [74774,561] Title : Working with INI Files KeyWords: TECHNOTE INI FILES Comments: This technote describes how to use Superbase to manipulate INI files. It makes use of user defined functions to achieve these manipulations. 4064.TXT/Text Bytes: 2305, 09-Jan-97 Uploaded by: [74774,561] Title : Calculating a Time Span Across Midnight KeyWords: TECHNOTE CALCULATE TIME MIDNIGHT Comments: Employees working third shift at a manufacturing plant start work at 11:30 p.m. and end their workday at 7:45 a.m. the following morning. Subtracting their starting time from their ending time produces an incorrect value. This technote explains how to solve it. 4065.TXT/Text Bytes: 2299, 09-Jan-97 Uploaded by: [74774,561] Title : Quick Report Using NOT LOOKUP Filter KeyWords: TECHNOTE QUICK REPORT LOOKUP Comments: Scenario: The Dean of Students has asked for a list of full-time students and their phone numbers who do not live in a dormitory. The list must be in order by the last name and grouped by the phone number area code. BACKUP.ZIP/Binary Bytes: 1519, 07-Jun-96 Uploaded by: [74172,1364] Title : BACKUP.ZIP KeyWords: BACKUP PKZIP Comments: Simple example using PKZIP and SBL for backup and restore. Needs pkzip and pkunzip. Mark Lyon BARCOD.ZIP/Binary Bytes: 2053, 27-Mar-94 Uploaded by: [100331,1260] Title : Barcode Extender KeyWords: BARCODE Comments: Alphabetic characters for SB BOUNCE.ZIP/Binary Bytes: 4261, 09-May-95 Uploaded by: [100121,1001] Title : Bounce.zip KeyWords: CARET BOUNCE SIDE Comments: Small EXE to "bounce" keystrokes back to the active application. Use to jump to start/end of an edit control/dialog, or simply try out some other weird and wonderful effects you can get... BUILDP.SBP/Binary Bytes: 4738, 13-Dec-94 Uploaded by: [76550,3374] Title : COMPILE IT KeyWords: SBP COMPILE OPTIMIZE Comments: This is a way to have a master file that will build a START.SBP from a list of individual code files... just edit the FILELIST array with the files to include in the program and set the compress%% to -1 to remove REM statements. Just something for you to play with John A. Binhammer CALEN1.SBP/Binary Bytes: 2958, 22-Jul-98 Uploaded by: [75512,3005] Title : A Toy KeyWords: calendar Comments: Found this toy while "cleaning house". Added the subs to get rid of menu and sys controls. Its too bad V2 isn't freeware so that little toys like this could be written by kids in grade school (or non ambitious diletantes) and distributed freely to people who could actually run them. JDK CALEND.ZIP/Binary Bytes: 1043, 13-Oct-92 Uploaded by: [100026,1456] Title : Calendar Dlg KeyWords: DLG Comments: This is a calendar dlg and returns the Julian and txt date selected CALENDAR.SBP/Binary Bytes: 10647, 29-Jan-96 Uploaded by: [102402,1110] Title : Calendar.SBP KeyWords: CALENDAR DATE DIALOG Comments: This is an update to the Calendar Dialog. Can plug it into a Textbox or a CommandButton. Press esc and original contents unchanged. Indicates todays date in current month. Generally functions better now. Enjoy. Robert Geiger, R J Geiger & Associates, Cary NC, USA CDPLAYER.ZIP/Binary Bytes: 36602, 29-Apr-96 Uploaded by: [100016,2775] Title : Superbase CD Player - Source code included KeyWords: RTS FREEWARE SOURCE EXAMPLE SBDPLC Comments: This is a CD Player and information management software. Plays Audio CDs under Windows. Written completely in Superbase. Very comfortable interface. Freeware. Source code included. This is an example of how to make use of the MCI commands in Superbase, as well as using eventclasses, the Windows API, etc. Completely network capable and runs with the RTS. CHECK.ZIP/Binary Bytes: 2784, 05-Apr-96 Uploaded by: [100335,1246] Title : SET FORM ON/OFF KeyWords: CHECKBOX FORM AFTER Comments: This is a small sample application that demonstrates a problem I am having when making fields read-only using "AFTER" triggers on a form. It relates to the "SET FORM ON / OFF" message in the Superbase forum. CLCRPT.ZIP/Binary Bytes: 6375, 25-Aug-94 Uploaded by: [75103,1364] Title : A Multi Column Report Example KeyWords: EXAMPLE REPORT PROGRAM V2 MULTICOLUMN Comments: The Following is an example of One way to produce a multi column report, including a semi-generic version which receives the parameters for the report. CLSPAN.ZIP/Binary Bytes: 3655, 24-Jan-92 Uploaded by: [76004,2300] Title : VCR Control Panel from DML KeyWords: CLSPANEL SUPERBASE 4 EXAMPLE VCR CONTROL PANEL DML Comments: This example shows you how to emulate the VCR control panel in Superbase 4 using DML. COLTAB.SBP/Binary Bytes: 2904, 02-Jan-96 Uploaded by: [100121,1001] Title : Colour Table Utility KeyWords: COLOUR SIDE Comments: Just a little utility to print the standard Superbase colours: if you're looking for a colour match it's essential... Enjoy! Phil CONTRO.ARJ/Binary Bytes: 5590, 25-Aug-94 Uploaded by: [75200,2045] Title : Control Utilities (Control experiment...) KeyWords: SB2.0 - WINDOWS CONTROLS Comments: I'm trying to create windows controls directly in the SB main window,... only for play and learn windows basics. Here there are a ComboBox example, but don't work and I need help to put the thinks working... Someone want play...?. Please if you have suggestion write me. Also I have include a CTL3D.DLL demo to SB 2.0,.. good 3D looking in dialogs box. (Warnign when work with the windows API the crash are frequently ... Save your work each minute,...or second,.... CUSTHE.ZIP/Binary Bytes: 4844, 27-Jul-92 Uploaded by: [100026,1456] Title : Custom Help KeyWords: SUPERBASE Comments: Let the user create the help text DATECHK.SBP/Binary Bytes: 2862, 03-Sep-96 Uploaded by: [100121,1001] Title : Date check utility KeyWords: SIDE YYYY DATE CHECK Comments: With turn of the century approaching, a utility to check date fields to see whether only 2 digits of year are used. Enjoy. Phil DBCON.ZIP/Binary Bytes: 8457, 11-Jan-93 Uploaded by: [76004,2300] Title : DBase memo field import utility KeyWords: IMPORT DBASE MEMO Comments: This is an example application that allows you to import a dBase file with one memo field. DDEDLG.ZIP/Binary Bytes: 1456, 18-Jan-94 Uploaded by: [71201,2357] Title : DDE Dialogs KeyWords: DDE DLL DIALOG Comments: This is an example of how to close down a dialog in a server instance of Superbase. In order to run execute the CLIENT.SBP program. Please feel free to modify and enhance this code Uploaded by Justin Hearn GeoMetrix Data Systems DDEREQ.ZIP/Binary Bytes: 19475, 08-Sep-95 Uploaded by: [75200,2045] Title : DDEREQ Test routine KeyWords: EVENT DDEREQ Comments: That is a DDEREQ test example to learn how trap DDE event's. Please take a look and send me back your comments. Thank's DDETES.ZIP/Binary Bytes: 1456, 18-Jan-94 Uploaded by: [71201,2357] Title : DDE Dialogs Update KeyWords: DDE DIALOG DLL Comments: This example file demonstrates a method of controlling and closing down a dialog in another application by using Windows API calls. Please run the CLIENT.SBP file to see the example. Feel free to modify or extend this code, there are several ways of managing dialogs within other applications. If you have any questions or require assistance, call GeoMetrix Data Systems, in North America at (800) 661-1488 or elsewhere from (604) 361-9300. Good Luck, Justin Hearn DDEWOR.SBP/Text Bytes: 10762, 21-Feb-95 Uploaded by: [74130,3162] Title : Superbase DDE example to Word 6.0 Win KeyWords: DDE SUPREBASE WORD WINDOWS Comments: This file is part of a program that does DDE commnications to Word for Windows. If you like it but don't understand see Leave me mail Mike G. DELRIN.ZIP/Binary Bytes: 990, 01-Dec-93 Uploaded by: [73730,2527] Title : Fax with SB 2.0 and Winfax 3.0 KeyWords: FAX DELRINA WINFAX Comments: Superbase 2.0 SBL application to send faxes from superbase to Winfax Pro 3.0 using DDE. DLLMEN.SBP/Binary Bytes: 3035, 13-Apr-93 Uploaded by: [73730,2527] Title : Menu Library KeyWords: DLL MENU DLLMENU.SBP Comments: This program allows you to modify, remove, enable, disable menu options in the text editor windows. EMSDLL.ZIP/Binary Bytes: 30721, 06-Feb-95 Uploaded by: [100441,224] Title : EMSDLLS - 3 SB-aware DLLS KeyWords: LITTLE DLLS Comments: As promised - here are me little DLLS - EMS's little shop of horrors, you could say. More details in the README.1st in the zip but the functions will 1) Generate Windows BMPS's for Code 39 barcodes - dump them onto a form and print. 2) Get at who's on on a Net via the SUPERBAS.NET File 3) Make DLLs for SB ICON BMP's and a String Table Enjoy for what they are worth - see readme file!! Antony Shelley - EMS EMSDLLS2.ZIP/Binary Bytes: 12051, 02-May-95 Uploaded by: [100441,224] Title : EMSDLLS - Sample Icon BMPs and Directory CmnDlg KeyWords: EMSDLLS Comments: An Update to the previous DLL Pack. It is a sample of 30+ Icon BMP's we've done compiled into a BMP and a new Function in SBUSERS.DLL - to allow you to Select a Directory in a Drive without having to see the Files involved. Sample.sbp in the ZIP shows how. Enjoy. Antony. ENTRUST1.ZIP/Binary Bytes: 8693, 23-Feb-96 Uploaded by: [75553,2304] Title : GMTime KeyWords: FUNCTION Comments: Function calculates time at a remote location automatically. ERRCOD.LST/Binary Bytes: 12329, 30-Apr-93 Uploaded by: [74066,2610] Title : ErrorCode KeyWords: ERRORCODE Comments: This is a list of all currently identifiable error codes in Superbase. EVENTS.ZIP/Binary Bytes: 15094, 26-May-93 Uploaded by: [76702,774] Title : Event Examples for SB 2.0 KeyWords: EVENTS DML SB 2.0 DDE EXAMPLES Comments: Individual examples of each of the 7 events within Superbase. Good examples of each individual event in action even one featuring DDEREQ. Also, included is an example of a scalable form so the form looks the same at any resolution. EVNTPA.SBP/Binary Bytes: 2631, 24-Jan-94 Uploaded by: [76004,2300] Title : Panel and Key Events KeyWords: EVENTS Comments: A program which demonstrates the coding for using panel and key events FILEDEF.SBP/Binary Bytes: 4474, 04-Dec-96 Uploaded by: [100135,3152] Title : CREATE/MAKE FILE program generator. KeyWords: SBP PROGRAM MAKE CREATE Comments: My little programette for generating SBL code to create and make a file based upon an existing Superbase file. Useful for re-ordering fields within a file definition at development time - which the macro recorder can't do for you. Feel free to hack about. FINDAP.DLL/Binary Bytes: 2048, 23-Jul-93 Uploaded by: [73730,2527] Title : Find a window without an exact title match KeyWords: DLL FIND Comments: Returns the hWnd without having to specify the exact heading/title of the window. FINDTX.SBP/Binary Bytes: 2869, 03-Mar-95 Uploaded by: [100121,1001] Title : FindText in SBP file KeyWords: FIND TEXT SIDE Comments: A simple tool to allow you to search multiple program files for a text string, & loads all those which contain such text into your program editor. FRM1.SBP/Binary Bytes: 2604, 23-May-96 Uploaded by: [75512,3005] Title : Rotation KeyWords: ROTATING POINTS Comments: This is a "tutorial" regarding rotation of lines on form. I am not a programmer. GETDAT.SBP/Binary Bytes: 17410, 30-Nov-94 Uploaded by: [73021,2434] Title : GetDate Version 2.0 KeyWords: DATE CALENDAR FUNCTIONS Comments: This is an upgrade of my "Date Calculator". The GetDate will display a dialog box containing an actual calendar for date selection (no extra buttons). The month and year can be changed through dialog boxes. Once the month or the year has been changed the GetDate will update the calander to accurately display the selected month and year. The code is as the fastest and the smallest that I have seen that is available. I have also added several other date related functions and the ability to disable date buttons. GO_WIZ20.SBP/Binary Bytes: 4827, 01-May-96 Uploaded by: [75553,2304] Title : Sharp Wizard II Export (missing quote) KeyWords: EXPORT Comments: Correction: Somehow a quote disappeared after a date in field eight (8). This program filters and exports eight fields from a database to a Sharp compatible file format. If you have any questions please feel free to email me. HLPGEN.ZIP/Binary Bytes: 79094, 05-Jan-95 Uploaded by: [100121,1001] Title : HELPGEN KeyWords: HELP SUPERBASE Comments: Help generation tool for Superbase IFRUN.SBP/Binary Bytes: 2293, 02-May-96 Uploaded by: [100044,1311] Title : Programette to check if it is already running KeyWords: DDE INSTANCE Comments: Several people have asked for code to prevent an app being run more than once. This code could be added to any SB application. It was originally written for SB v2 and uses no special SB30 syntax IMAGEC.TXT/Binary Bytes: 7142, 17-Mar-95 Uploaded by: [73361,2563] Title : IMAGE UNDER PROGRAM CONTROL KeyWords: OLE SHOW WAIT Comments: v2.0 This is 3 calls to handle image control under program control. It determines editmode and ole presence to either show or insert an image. It keeps focus on the image window until the window is destroyed. It does not effect other window programs. Uses windows API calls under SBL. This supercedes my previous upload INVENTUS.EXE/Binary Bytes: 80766, 02-May-95 Uploaded by: [100600,1325] Title : msd-Library for SB2.0 incl. Demo-App KeyWords: SBP LIBRARY MSD GERMAN Comments: msd's Library Version 3.12ß -> Includes some maybe useful procedures for application-creation. Completely documentated in german language. The library allows you to create e.g. search-procedures under use of only 4 commands. Demo-App included! Very nice Error-Handler! Completely written in SBL 2.0 and tested on SB's-Runtime-System. You may use the code if you sent me an e-mail containing your user-id (and later comments on the code)! Long life to SUPERBASE! - Greetings to Piotr of Bader GmbH, HG, FRG. msd - 100600,1325 - 30.04.1995 KALAND.ZIP/Binary Bytes: 1279, 16-Feb-95 Uploaded by: [100542,465] Title : Diary / Calendar pop up dialog KeyWords: DATE Comments: This is a general purpose pop up calendar. I use it in my workflow management tool for selecting dates. The title of the box is picked up from an assigned variable (so it can be used for different field names). The returned value is either 0, a date or nul. Any chosen date is validated. You can page back and forward or enter a date. Any comments as to how to handle page up / page down to go forward and backward would be appreciated. LABELS.ZIP/Binary Bytes: 10005, 13-Sep-94 Uploaded by: [74172,1364] Title : Avery Label Routine KeyWords: LABELS Comments: This routine can be used to create a picklist of predesigned Avery label formats and then print the labels using any database. I use a variation of this with one program in which this works with 16 different client databases. You can add additional formats and databases to the picklists. I've even created envelope templates and added them to the lists. Feedback welcome. Mark Lyon LIB4.TXT/Text Bytes: 49956, 22-Jan-98 Uploaded by: [74774,561] Title : Text file listing of all files in library 4. KeyWords: LIBRARY FILE LIST Comments: This is an ASCII listing of all the files available in this library. It contains information about each file including Filename, Title, Keywords, Uploader, and Abstract. LICAPP.ZIP/Binary Bytes: 20194, 29-Jul-92 Uploaded by: [76004,2300] Title : non-functioning shell of an application KeyWords: LICENSE Comments: Forms application LKUPINDX.ZIP/Binary Bytes: 1977, 05-Oct-95 Uploaded by: [73534,2704] Title : Lookup index error KeyWords: LOOKUP INDEX SUPERBASE Comments: Files includes used to demonstrate an index error caused by the use of the LOOKUP function. MAIPROG.EXE/Binary Bytes: 47695, 13-Feb-96 Uploaded by: [76300,1772] Title : MAIPROG.EXE KeyWords: MDI MAI CHILD WINDOWS Comments: This is a basic multiple application interface. It launches additional instances, and makes them behave like child windows. They can have their own menus, icons, MDI, whatever you throw in. Remembers sizes and position thru .INIs. Cascade and Tile up to six. v2 and v3 Superbase. Thanks to Neil, Mark H., J Barrs, Fred D., etc. - Pete Barus MANY.ZIP/Binary Bytes: 2908, 14-Oct-93 Uploaded by: [73730,2527] Title : One to many to many example KeyWords: ONE MANY Comments: Example form on how to use one to many to many. METER.SBP/Binary Bytes: 3636, 24-Aug-93 Uploaded by: [73730,2527] Title : Meter program iin SBL KeyWords: METER SBL GAUGE Comments: Meter,gauge percent complete SBL program using form on the fly. MISDDE.SBP/Binary Bytes: 9967, 05-Jan-93 Uploaded by: [76004,2300] Title : Fix for the MISDDE.SBP Program (Superbase 2.0) KeyWords: DDE MIS Comments: This fixes the problem in the DDE example that was reported in the Dec 21 issue of Info World. MPLIB1.ZIP/Binary Bytes: 1366, 13-Jul-93 Uploaded by: [73730,2527] Title : Net/DLL Library Proc for SB KeyWords: DLL NETWORK LIBRARY Comments: A Library that includes additional DLL calls not included in DLL.sbp that supports some network calls and more attributes for the SB Window and others. More to come... MPLIB2.ZIP/Binary Bytes: 870, 23-Jul-93 Uploaded by: [73730,2527] Title : DLL Library Menu Function KeyWords: DLL MENU POPUP Comments: A DLL function to create a popup menu anywhere on the screen or the mouse pos using a windows API. MULTIS/Binary Bytes: 2304, 06-May-93 Uploaded by: [100270,10] Title : Multimedia & API Tools for Superbase 2 Info File KeyWords: API MULTIMEDIA Comments: Complete Tools- Windows-API Function, MCI & AVI Programs include Sourcecode. NUM2WO.ZIP/Binary Bytes: 955, 23-Jan-95 Uploaded by: [100026,1456] Title : Cheque text printing KeyWords: CHEQUE Comments: Converts a number to text for printing of cheques etc. PARSE.ZIP/Binary Bytes: 4354, 05-Oct-94 Uploaded by: [70670,3446] Title : SBP XREF Program KeyWords: PARSE Comments: This is a Quick and dirty Program cross reference lister. It will number the lines in a program and cross reference Sub routines, Functions, and variables. If you make improvements please place them back in the forum so everyone can benefit. Some of the routines used were downloaded from this forum. I use this program for quick documentation on existing programs. PRCNTB.ZIP/Binary Bytes: 10586, 29-Nov-93 Uploaded by: [72714,3024] Title : Percent Complete DLL Upgrade KeyWords: DLL PRCNTBOX DIALOG Comments: This DLL creates a dialog box modal to Superbase with a percent complete bargraph that is updateable from within an SBL program. Additional functions for modifying the color, position, range of values, and a static text window have been provided. Included is a write document defining the API. PROCFI.ZIP/Binary Bytes: 48193, 30-Apr-93 Uploaded by: [76550,3374] Title : Procedure Database KeyWords: PROCEDURES Comments: Tim Attached is the Procedure Finder program I uploaded recently. There have been a number of changes implimented and there is a note included for you to see where this is headed John PROFIL.SBP/Text Bytes: 2302, 15-Mar-93 Uploaded by: [76550,3374] Title : Profile2.sbp KeyWords: API INI SB4 Comments: After reviewing some of the functions for adding and retrieving information for private INI files I decided some quick functions were needed...3 functions here that use WINDOWS API calls to 1. Add to Private INI files 2. Retrieve Information from private INI files 3. Delete Information from Private INI files... These are faster than anything shipped with SB4 Ver 2.0. Try 'em, I think you'll Like 'em. John A. Binhammer 76550,3374 QUERY1.ARJ/Binary Bytes: 758, 06-Jun-94 Uploaded by: [100026,1456] Title : Quick Reports KeyWords: QUICK REPORT Comments: Supplies Quick reports to users, can save and create a library of queries. Work under Runtime. READQRY.ZIP/Binary Bytes: 3597, 01-Jul-96 Uploaded by: [100016,2775] Title : Read Query Function Library KeyWords: RTS GENIAL TOOL PROGRAMMING Comments: This is a set of functions which can be used for reqding in and writing out Superbase query files, along with a function for modifying the filter and order clauses of the query. Code is provided as is. Please do not upload modifications to this code, but send corrections either as a forum message or via email, to the author: Neil Robinson, 100016,2775. Enjoy! RORGUT.ZIP/Binary Bytes: 1144, 24-Oct-94 Uploaded by: [100026,1456] Title : Reorganise utility KeyWords: REORGANISE INDEX Comments: Re organises all or selected file within a directory, all related files (lookups & validations) must be in the same directory. Utility is not tested with a Runtime yet. SAMPLE.ZIP/Binary Bytes: 899970, 15-Apr-93 Uploaded by: [76004,2300] Title : Superbase 2.0 extra sample applications KeyWords: SAMPLES Comments: Superbase 2.0 extra sample applications. To install, 1. Type PKUNZIP -d SAMPLE A: 2. Insert the diskette into your floppy drive, choose Run from the Windows file menu, and choose a:\install or b:\install. **Please note -- this file takes about 17 minutes to download. SAYNUM.SBP/Binary Bytes: 4265, 28-Aug-95 Uploaded by: [100271,3710] Title : number to words for cheques KeyWords: NUMBER SBP CHECK PRINTING Comments: simple function that turns an integer to words for cheque printing. Code includes main subroutine that calls function with example numbers. Includes differentiation of one pound one dollar to x pounds x dollars also knows about the use of "and" as in 3006 = "three thousand AND six" SB4DLL.COM/Binary Bytes: 6448, 13-Mar-92 Uploaded by: [100032,103] Title : Superbase 4 DLL - Includes GetEnv KeyWords: DLL FREE GETENV ENVIRONMENT Comments: This small DLL only includes one function that is GetEnv. This was created because of a thread in the SB4 ADV Area. Any suggestions for other functions would be appreciated SB4MER.ZIP/Binary Bytes: 5852, 29-Nov-93 Uploaded by: [72233,1077] Title : Superbase Merge To WordPerfect KeyWords: WORDPERFECT WINDOWS SUPERBASE MERGE Comments: WordPerfect Macro that will get data placed into Clipboard from Superbase. Thereafter will strip HardTab's & HardReturn's and replace them with {END FIELD} and {END RECORD} markers. Program is freeware, just give me credit and let me know what you think! John Vester 72233,1077 SB4TBA.ZIP/Binary Bytes: 45471, 29-Sep-92 Uploaded by: [76004,2300] Title : SB4 - Toolbar KeyWords: TOOLBAR Comments: A user-defineable Toolbar/Toolbox for Superbase. Create your own Toolbar frobitmaps drawn with Paintbrush and execute menu or DML cmds. Beta version released for evaluation only. SB4TOO.ZIP/Binary Bytes: 3868, 30-Mar-93 Uploaded by: [76347,3351] Title : SB4TOOLS v 1.0 KeyWords: DLL SB SUPERBASE SB4TOOLS Comments: This is the Original Upload from 1/10/91. Various tools for sb. In particular, a neat way to find a window on a partial match of the window name. Also a way to see what's running by getting a list of windows. This has been extensively added to, and the new version will be available soon (q2/93). Uploaded by the author. SBAPP.ZIP/Binary Bytes: 65697, 09-May-95 Uploaded by: [73113,3355] Title : SBAPP.zip KeyWords: SB SUPERBASE APPLICATION Comments: This is the Application that I did in SB version 2 style. Though not elegant, it works. It also has some interesting ways of doing things. It is an app for an auto garage. It has some test data. Please let me know what you think! Let's see more of this kind of UL's! Don't sell this app without my permission, Please. This app was UL'ed months earlier. This is an updated version. SBCNTR.ZIP/Binary Bytes: 7484, 14-Feb-94 Uploaded by: [72361,2107] Title : SB Controls-Meter and Popup Message Box KeyWords: SB CONTROL METER POPUP Comments: SB Control Pack - A meter guage in the SB Status Bar and a popup shadowed message box (like you see in help files) to replace some of the SB REQUEST msg boxes. AND THERE FREE!!! SBGOOD.ZIP/Binary Bytes: 21512, 08-Dec-93 Uploaded by: [100047,111] Title : SBGOODIES DLL KeyWords: SB4W GOODIES DLL Comments: This is an updated version of the Goodies DLL. It contains facilities to search for files in directories, obtain superbase field information and open a text box. Evironment variables can also be used, and file attributes read and set. SBGREE.ZIP/Binary Bytes: 109659, 21-Feb-95 Uploaded by: [100272,3706] Title : the ultimate Windows wallpaper KeyWords: WALLPAPER SERIOUS DEVELOPER Comments: This is the ultimate wallpaper for every serious Superbase user or developer. SBICON.ZIP/Binary Bytes: 32297, 17-Jul-94 Uploaded by: [100270,2526] Title : Icons SB STYLE KeyWords: ICONS SUPERBASE STYLE Comments: New icons "SB STYLE" in order to celebrate SB phoenix-like resurrection. Long life for SuperBase Inc.! SBPSRH.ZIP/Binary Bytes: 3491, 07-Nov-93 Uploaded by: [76702,1761] Title : SBP Search / Documentor utility program KeyWords: SBP PROGRAM UTILITY SUPERBASE Comments: This is a utility program written to search for procedures, functions, labels, comments, and text in all tokenized SBP programs in the selected directory. It is uploaded here to allow you to see how this preliminary program works and to allow others to contribute to it's completion. It is ziped with PKZIP v2.04g, enjoy it. Andy SBTIPK.HLP/Binary Bytes: 125638, 08-Oct-93 Uploaded by: [75430,1066] Title : SBTips Help File KeyWords: TIPS Comments: Superbase Tips 4001 - 4055 in a win3.1 help file SBUG01.ZIP/Binary Bytes: 4661, 08-Jul-96 Uploaded by: [100016,2775] Title : Optiizing Single- and Multi-File Filters KeyWords: INFO DOC Comments: This is a document in RTF format which contains an article I wrote for a book project I started and which was published in the German Superbase User Group magazine (this article was translated to German for the magazine, this one is in English). It discusses in depth the issues surrounding optimization of single and multiple file filters and also discusses the problems for those using extended ASCII characters with Superbase with respect to indexing, searching and sorting. SCALES.SBP/Binary Bytes: 7969, 28-Oct-93 Uploaded by: [70134,1723] Title : IMS Scalable Forms Generator 1.1 KeyWords: FORMS SBV SCALE GRAPHICS Comments: This version adds image scaling to the original version which generates scalable forms SBL from source code written by the forms designer for SB version 2.0. This program is placed here for use by superbase developers and was written based on an article in the Tech Journal. We hope you find this program handy. SLIDE.ZIP/Binary Bytes: 2999988, 01-Mar-95 Uploaded by: [100036,1354] Title : Slide Database KeyWords: FIF SLIDE Comments: Slide Database written with SB 2.0 - uses FIF images (40 samples included). Includes runtime SB. Resolution independant. Originally uploaded for Dan Greenberg. Take a look and give me your comments! SORTOR.ZIP/Binary Bytes: 2508, 09-Feb-96 Uploaded by: [100330,15] Title : prog sortorder detailblock KeyWords: SORTORDER DETAILBLOCK BUGFIX Comments: Sample prog that shows how to fix the *unable to build sortorder in detblock by program* -bug and also demonstrates how to change sortorder in an existing det-block. SPRDDE.ZIP/Binary Bytes: 52796, 24-Aug-93 Uploaded by: [72262,2701] Title : SuperDDE - DDE Client Utility. KeyWords: SUPERDDE DDE SOFTBLOX Comments: SuperDDE - Distributed as EnjoyWare by SoftBlox. This is the DDE Client utility for initiating, performing, and terminating DDE conversations. Very nice utility, similar to DDESPY available with the Win 3.1 SDK. Enjoy! SRCHPG.SBP/Binary Bytes: 9697, 06-May-94 Uploaded by: [100273,237] Title : Superbase Search facility. KeyWords: SEARCH Comments: This routine provides the facility to search SB programs, data file definitions etc for a specific text string ie. Field names, procedures and SB program commands. TABFORM5.SBP/Binary Bytes: 6202, 21-Jan-98 Uploaded by: [75512,3005] Title : TabForm KeyWords: Form Program Comments: TEMPLA.BMP/Binary Bytes: 1086, 19-Nov-93 Uploaded by: [76702,1761] Title : A Template SB Icon Bar BMP KeyWords: SUPERBASE ICON ICONBAR BMP BITMAP Comments: This is a template of an Icon for the SB v2 Icon bar. Use to create your own custom icons. It contains the three panels required for a Icon bar BMP. Each if the panels contain a box defining the design area for each panel, note using solid area out side of this box will result in a non-3D button. The first panel is for the design, the second should be solid black for the entire area of the first, or you will loose some of the first's design. The third should duplicate the first, but using black. TYPETIME.ZIP/Binary Bytes: 963, 28-Feb-97 Uploaded by: [75512,3005] Title : KQADTT KeyWords: TYPING TIMER Comments: Here is an older version of little applet that will test ones typing speed. You may also note from review of code that an array is filled with the typed words (word meaning that which is between spaces). An industrious developer could then check contents against a dictionary file to look for spelling and typo errors. I am neither industrious nor a true developer. JDKromkowski UPLOAD.ZIP/Binary Bytes: 2755, 07-Nov-93 Uploaded by: [76702,1761] Title : A TapCIS Upload Script Generator Program KeyWords: SBP PROGRAM TAPCIS UTILITY SCRIPT Comments: This is a Superbase Program that generates TapCIS a Upload.SCR. This allows TapCIS to automatically upload multiple files. . After running the Upload.SBP program and TapCIS, Go on line in [I]nteractive mode press the Page Up key for the script prompt. Now enter Upload.SCR and press the enter key. That's all there is to it! . WINCLI.ZIP/Binary Bytes: 65565, 10-Jan-94 Uploaded by: [70152,2131] Title : Windows Command Line Intrepreter KeyWords: WINCLI DISK LABEL Comments: Windows program that gives functionality of the DOS command line without the overhead of a DOS shell in windows. Also includes Functions in the DLL to retrieve and set a disk volume label from within SB WORM.SBP/Binary Bytes: 8315, 05-Oct-94 Uploaded by: [100121,1001] Title : Now for something completely silly KeyWords: EVENTS GAMES VERY SILLY Comments: Another silly game, written in Superbase by someone who should have better things to do with his time - !! WARNING !! It can get addictive!!! WSTIFC.SBP/Binary Bytes: 6123, 17-Jan-95 Uploaded by: [100563,700] Title : TimeFunctions V1.1 KeyWords: SOURCECODE DATE TIME FUNCTIONS Comments: FUNCTIONS FOR WeekOfYear$,TodayOfYear$,LastDayOfYear$,RestDayOfYear$,WeekOfMonth$, TodayOfMonth$,LastDayOfMonth$,RestDayOfMonth$,RewDayOfMonth$, WdayOfMonth$,RewWDayOfMonth$,TodayOfWeek$,HourSystime$, HourSystimeAM$,MinSystime$ WSTIFC.ZIP/Binary Bytes: 1759, 17-Jan-95 Uploaded by: [100563,700] Title : Time/Date functions (SBL-Code) KeyWords: TIME DATE SOURCECODE Comments: Functions for Time/Date Information (based on SBL-Programm-Code). For Detail information see the file, for questions call us... WWSBME.DOT/Binary Bytes: 5783, 17-Nov-94 Uploaded by: [74774,561] Title : Controlling WWord from Superbase. KeyWords: WORD WINDOWS DOT WINWORD Comments: .DOT file for controlling WWord from SB. ZIPCOU.SBP/Binary Bytes: 1806, 26-Mar-92 Uploaded by: [76004,2300] Title : ZIPCOUNT.SBP - Sorts zip codes for bulk mail KeyWords: ZIPCOUNT BULK MAIL MAILING ZIP CODE CODES SUPERBASE DML Comments: Sorts zip codes according to postal bulk mail regulations. ZTCODE.ZIP/Binary Bytes: 632925, 02-Dec-92 Uploaded by: [72656,3102] Title : ZTCODE.ZIP telephone areacode and zipcode databas KeyWords: AREACODE ZIPCODE Comments: ZTCODE.ZIP contains the zip and telephone area code databases for superbase along with sample query forms to retrieve info from the databases.