abcDB 'Desktop Studio'
Welcome
Forward
Welcome to abcDB!
Beginners guide to databases
Introduction to abcDB 'Desktop Studio'
Handy Tips
Tables
Queries
Editing Queries
Forms
Results
Transferring Database to PocketPC
Forms
Introduction to Forms
Creating and Editing Forms
Using Tab Controls
Introduction to Programming
The Basics
Using TAGS in abcDB
Using Variables in abcDB
Using MODULES
Using SUBFORMS in abcDB
Debugging Applications
Programming Tutorials
Our 'Hello World' application
abcDB 'Realtor' Application
abcDB 'Calculator'
Appendix A - abcDB 'Field Types'
FieldTypes
Appendix B - SQL Reference
SELECT Join
SELECT Like
SELECT Order By
SELECT Projection
SELECT Restricted
SELECT Simple
ALTER TABLE
CREATE INDEX
DROP DATABASE
DROP TABLE
DROP INDEX
Appendix C - SCRIPT Commands
Caption
COLOR
DROPREFRESH
ENABLE
EXECUTE
EXIT
EXITAPP
EXPORT
FONT
FORMOPEN
FORMREQUERY
GOTO
GPSCLOSE
GPSINIT
GPSOPEN
GRIDREFRESH
IMAGE
IMPORT
LISTVIEW
MESSAGE
MOVE
MOVEFIRST
MOVELAST
MOVENEXT
MOVEPREV
MOVETO
PREVFORM
PLAYSOUND
POWERPICK
PREVFORM
PRINT
QUIT
RECORDDELETE
RECORDNEW
RECORDSAVE
RETURN
RUNAPP
RUNSQL
RUNSUB
RUNUPDATE
SCRIBCLEAR
SCRIBFSAVE
SCRIBSAVE
SEEK
SETFIELD
SETFOCUS
SETMEM
SETTAB
SETVALUE
SIP
SUBFORMREFRESH
TABLEDELETE
TEST
TIMER
VISIBLE
WHILE ENDWHILE
WINDOWPOS
ZOOM
ZORDER
Appendix D - Form controls, properties and events
Form Properties
Textbox Control
Dropdown Control
Label Control
Command Control
Checkbox Control
Grid Control
DatePicker Control
Scribble Control
Image Control
Tab Control
Appendix E - abcDB Script 'Functions'
ABS
ASC
AUTOID
CHR
CURRENTTAB
DADD
DATE
DATETIME
DAY
DDIFF
EVAL
EXP
FILEPICK
FORMAT
GPSALT
GPSALTUNIT
GPSDATE
GPSLAT
GPSLONG
GPSMAXALT
GPSMAXSPEED
GPSOK
GPSRAW
GPSSPEED
GPSTIME
GRIDCOL
HOUR
INPUT
INSTR
INT
LEFT
LEN
LOG
LOOKUP
MESSAGEBOX
MID
MINUTE
MONTH
MONTHNAME
NEXTID
POSITION
RANDOM
RECCOUNT
RECNO
REPLACE
RIGHT
RNDID
ROUND
SECOND
SIN
SQR
TAN
TAVG
TCOUNT
TID
TIME
TMAX
TMIN
TSUM
WEEKDAY
WEEKDAYNAME
YEAR
Appendix F - Using GPS Receivers
Using abcDB with GPS Devices
PocketSOFT.ca Website
Technical Support