John Barrs: Superbase Tips and Codelets
Below is a selection
of Superbase Tips and code examples.
Links to main website areas Links to other Software pages |
The items are
grouped: The groups concerned are FIELD, FILE,
FORM, PROGRAM and SYSTEM. Of course there are somewhat arbitrary divisions
as anything to do with forms might well involve fields and most of them
are programs; but the groupings do involve items which deal with similar
areas of programming. Within a group the items are sorted alphabetically by
the name I gave them when they were created. If you wish to learn more about any item, then click on
its name and you will be taken to a fuller description of the item. In this
second list which is in the same order, group by name, some items appear with
program names and some without - the distinction I am making here is
between seeing a name 'abc.sbp' or a
name 'abc'. If it is a named program - 'abc.sbp'
then that is also a link to enable you to download the program concerned.
(All programs are saved as text). To the right of the program name is a
fuller description. Most programs are coding for an idea and if they have a
SUB main() that is present merely to demonstrate the way things work and may
refer to files local to my system - in other words it is a demonstration of
the usage of the code. However, some programs are complete processes and will
have a SUB main() to run the code. If it is a name - 'abc' then all the details are in the box to the right of the name and there is nothing more to download. |
Warning: This code and the ideas involved and demonstrated are offered on an 'as-is' basis. You use them entirely at your own risk. I am not responsible for any loss of programs, data, or damage to any software or hardware that might be involved. Formally: Neither I, my family, any servants or agents bear any responsibility for anything that might happen of any of these ideas are used by anyone else. These ideas are provided to give you ideas as to how to do things and not as finished or completed applications. (These I can produce for you if you wish - email me for a quotation) If you would like to discuss any ideas or ask for a solution for a particular problem then again email me, discuss - I am quite happy to help out but am limited in both health and time.
|
Here is the Table of
contents sorted alphabetically by and within group :
click on name for more
details
|
|
|
Various Date bits and pieces - note they often call each other
so should be |
||
|
Generalised = remove leading spaces
of all text field in a file |
|
|
Need to clear a date field? - send it 0 |
|
|
|
|
FILE: |
Checks file integrity by running up and down the file using
its indexes |
|
|
This function will copy longfilenames
|
|
|
2 functions to deal with multilined
fields |
|
|
To find out how big TXT and EXT (VTX VEX) fields in a used
file actually are |
|
|
Checks through a file and resizes fields |
|
|
Test for commas in all fields |
|
|
Reorganizes the fields in a file to remove forward referenced
calculations |
|
|
Various index functions |
|
|
Two procs to a) list Sbd files to windows,b) allow edit
of sbd files |
|
|
Copy Unique resords from 1 file to
another using a IXU |
|
|
Reorganize all files in a directory |
|
|
Modified Key Select to allow Change of File and Index |
|
|
Modified Key Select to allow Change of File and Index |
|
|
Demo to play outerjoin game |
|
|
How to stop report issuing a blank line |
|
|
Function to return size in bytes of a given sbf file |
|
|
A filter counter or two |
|
|
|
|
FORM: |
A 'transparent' field simulation by using labels (so that data
can appear over |
|
|
Cascade delete code for 1 and 2 detblocks
|
|
|
to add an OnGotFocus Procedure to
all fields in a detailblock |
|
|
to demo changing sortfield on detail
blocks |
|
|
Set a filter on all files in a form |
|
|
TabForms - demo of form to look like
a multipage TABbed Form |
|
|
Analyse forms or reports for details
- Written John Barrs Superbase Developers |
|
|
Analyse forms or reports for details
- Written John Barrs Superbase Developers |
|
|
sets Enabled to value toggle%% in detail block dbname$ for command buttons |
|
|
|
|
To Close all Open Programs |
||
|
Two Programs DDEDEMA as Server,DDEDEMB
to launch |
|
|
To DDE to hidden copySB to load and
save programs as text programs |
|
|
Set output -- window,printer,diskfile
|
|
|
Check what state (text, tokenised,
or protected) all programs in a directory |
|
|
SUPERBASE 3.6i TIP: PRINT CURRENT USING ... ASK |
|
|
Function to simulate WCASE$ |
|
|
|
|
This is v3 version of filer (file finder) and has an internal
directory changer |
||
|
Display File Properties |
|
|
to size a directory structure |
|
|
Duplicate a directory structure in TEMP |
|
|
returns Drivetype for input drive
letter |
|
|
Gets Lock type (LAN Dist, Singele)
of current SB (v3) |
|
|
read Sb30 ini file and returns value
associated with p$ |
|
|
Find a string in a directory |
|
|
Get WinDir |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Need to clear a date field? -
send it 0 |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
How to stop report issuing a
blank line |
Program can be loaded by clicking
on its name |
A filter counter or two |
Program can be loaded by clicking
on its name |
Cascade delete code for 1 and
2 detblocks |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program
can be loaded by clicking on its name |
To Close all Open Programs |
Two Programs DDEDEMA as Server,DDEDEMB to launch |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
SUPERBASE 3.6i TIP: PRINT
CURRENT USING ... ASK |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Program can be loaded by clicking
on its name |
Get WinDir |