PIQInfo.rsc!:\system\OPL\PIQInfo.rscPIQInfo.opo!:\system\OPL\PIQInfo.opoPIQInfo.mbm!:\system\OPL\PIQInfo.mbmPocket IQ Library!
Copyright
Version:Visit us at www.PocketIQ.comPocket IQ information noticeThis file is an essential shared elementof Pocket IQ applications. Please do notdelete or alter in way, as doing so mayaffect applications in the Pocket IQ range.ContinuePutting the IQ back in shareware
export.dbf select formatset, file,format,field,lastfield,prefile,postfile,prerecord,postrecord,startrecord,prefield,postfield,Note_NoOfLines,Note_LineWidth from format
FORMATSET$
FILE$
FORMAT%
FIELD$
LASTFIELD%
PREFILE$
POSTFILE$
PRERECORD$
POSTRECORD$
STARTRECORD%
PREFIELD$
POSTFIELD$
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
FORMATSET$#
Import/Export parametersO
+ <No Sets>
FORMATSET$#
,...K
FORMATSET$#
SetOs+
FormatOf+
LabelOl+
CabinetOc+
NotesOn+
ExportOx+
ImportOm+
CancelO
FORMATSET$#
FILE$#
FORMAT%
STARTRECORD%
FIELD$#
LASTFIELD%
PREFILE$#
+ POSTFILE$#
PRERECORD$#
POSTRECORD$#
STARTRECORD%
+ PREFIELD$#
POSTFIELD$#
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
Export
Import
Import/Export canceled
ExportC[
Enter file to exportO
ExportO
Export canceled
Exporting
+Iexport.dbf select name, prompt from export where seq<>'9999' order by seq
NAME$
PROMPT$
Exporting :+
NAME$#
PROMPT$#
NAME$#
PROMPT$#
ImportC[(
Enter file to importO
ImportO
Import canceled
Importing
Opening
+Iexport.dbf select name, prompt from export where seq<>'9999' order by seq
NAME$
PROMPT$
<EOF>C
<EOF>Cd[
<EOF>C
<EOF>C[
PROMPT$#
NotesC[+
PROMPT$#
PROMPT$#
PROMPT$#
NotesC[+
PROMPT$#
<EOF>C[
PROMPT$#
PROMPT$#
NotesC[+
PROMPT$#
<EOF>C[
PROMPT$#
Importing O
ElemSequenceO
F10$'
F11%$
F14$'
F15&%
F16$'
F17$'
F18$'
F19&%
F20$'
ETYPE$'
NOTESO
.dbfKO
<EOF>C[
Could not import this file. W
- KW
R {IO
NOOFACTIVESCREENS%
PROMPT$
IMPORTDATA$
SHOWERROR
Expected:
(length: K
) - Found: K
(length: K
SETUPMULTILINE
GETMULTILINE$
export.dbf select file,format,field,lastfield,prefile,postfile,prerecord,postrecord,startrecord,prefield,postfield,Note_NoOfLines,Note_LineWidth from format where formatset='
FILE$
FORMAT%
FIELD$
LASTFIELD%
PREFILE$
POSTFILE$
PRERECORD$
POSTRECORD$
STARTRECORD%
PREFIELD$
POSTFIELD$
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
PREFILE$#
+ POSTFILE$#
PRERECORD$#
POSTRECORD$#
+ PREFIELD$#
POSTFIELD$#
FORMAT%
STARTRECORD%
FIELD$#
LASTFIELD%
Export formatO
Format+ List,Form
+ File HeadO
+ File FootO
Before RecordO
After RecordO
End with 'After Record'
Field separator
End with field separator
Before FieldO
After FieldO
SaveOs+
CancelO
W7Os@[
FORMAT%$
PREFILE$'
+ POSTFILE$'
PRERECORD$'
POSTRECORD$'
+ PREFIELD$'
POSTFIELD$'
STARTRECORD%$
FIELD$'
LASTFIELD%$
DATESTR$
EXPORTNOTE
WRITETOKEN
PROMPT$
F10$#
F11%
F14$#
F15&!
F16$#
F17$#
F18$#
F19&!
F20$#
NotesC[0
+<export.dbf select name,prompt, seq from export where ftype='
' order by seqK
NAME$
PROMPT$
+)Field sequence (empty fields are skipped)O
SEQ$#
9999C[
SEQ$#
NAME$#
PROMPT$#
CancelO
SEQ$'
SEQ$'
+Kexport.dbf select name,prompt, seq from export where ftype='N' order by seq
NAME$
PROMPT$
+Nexport.dbf select note_NoOfLines, Note_LineWidth from format where formatset='
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
SEQ$#
9999C[
SEQ$#
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
Settings for export of notesO
Sequence No
Number Of LinesO
Line WidthO
CancelO
SEQ$'
SEQ$'
NOTE_NOOFLINES%$
NOTE_LINEWIDTH%$
WRITETOKEN
FETCHTEXT&
MAXNOTESIZE%
APPSHORT$
+Nexport.dbf select note_NoOfLines, Note_LineWidth from format where formatset='
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
NOTESO
.dbfKO
NOTE_NOOFLINES%
NOTE_NOOFLINES%
@`\[V
NOTE_LINEWIDTH%
NOTE_LINEWIDTH%
0\d[!
NOTE_NOOFLINES%
READLINE$
SHOWERROR
+Nexport.dbf select note_NoOfLines, Note_LineWidth from format where formatset='
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
NOTE_NOOFLINES%
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
O$h@[
NOTE_LINEWIDTH%
CHOICEDIALOG$
+2Export.dbf select formatset, formatset from formatO
New Name
+*Enter name of new export/import format set
export.dbf select formatset, file,format,field,lastfield,prefile,postfile,prerecord,postrecord,startrecord,prefield,postfield,Note_NoOfLines,Note_LineWidth from format
FORMATSET$
FILE$
FORMAT%
FIELD$
LASTFIELD%
PREFILE$
POSTFILE$
PRERECORD$
POSTRECORD$
STARTRECORD%
PREFIELD$
POSTFIELD$
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
FORMATSET$'
+9export.dbf select formatset from format where formatset='
FORMATSET$
+"Edit export/import format set name
FORMATSET$'
export.dbf select formatset, file,format,field,lastfield,prefile,postfile,prerecord,postrecord,startrecord,prefield,postfield,Note_NoOfLines,Note_LineWidth from format where formatset='
FORMATSET$
FILE$
FORMAT%
FIELD$
LASTFIELD%
PREFILE$
POSTFILE$
PRERECORD$
POSTRECORD$
STARTRECORD%
PREFIELD$
POSTFIELD$
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
EXPORT
IMPORTFIELD
IMPORTERROR
EXPORTFORMAT
WRITEFIELD
EXPORTFIELDSl
EXPORTNOTES
EXPORTNOTE>
IMPORTNOTEP
CHANGESET$
SYSRAM1
SYSTEM\
D:\programs\Cabinet\cabinet.opl
File: CABINET.OPO
Version: 2.1.2
+0 This file cannot be executed by itself
+; Copyright
1998-2000 Marc de Oliveira & PocketIQ
EVENT
PROCESS
ERROR_HANDLER
SHIFT%
CONTROL%
APPTITLE$
APPVER$
EMAIL$
TBAROFFER%
POINTER_EVENT
FINDLAST
FINDFIRST
ACTIVEWINDOWS
FINDNEXT
FINDPREVIOUS
NEXTELEM
PREVIOUSELEM
DISPLAY_MENU
ACTION_KEY
SHIFT%
CONTROL%
{A`[n
'{A`[
TOOLSWITCH
ABOUT
REREGISTER
FINDNEXT
FINDPREVIOUS
FINDLAST
FINDFIRST
DOPERSONALINFO
DOBOTTLEINFO
DOLISTVIEW
BOTTLENOTES
DELETEELEM
NEWBOTTLE
ACTIVEWINDOWS
DOSELECTELEMTYPE
FINDELEM
FINDNOTE
SFINDELEM
DOEXPORT
SHOWPRICES
FINDSPACE
EDITRATINGS
DOEDITTAPE
EDITTAPES
PREFERENCES
REG_KEY$
APPSHORT$
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
0123456789
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
O`L{A[
VideoC[
O`L{A[:
WineC[
VideoC[
O`L{A[)
VideoC[
F17$#
O`L{A[
O {A[
RESETPRINTING
PAGESETUPDIALOG
PRINT
PRINTPREVIEWDIALOG
O`L{A[
O`L{A[
Printer not connected
REREGISTER
PATH$
APPSHORT$
REG_NAME$
REG_KEY$
PREF_RATING%
.iniKW
.iniK
PATH$
APPSHORT$
REG_NAME$
REG_KEY$
PREF_RATING%
.iniK
.iniK
REGISTER$
SETUP_SCREEN
APPTITLE$
REG_NAME$
REG_KEY$
NAGWIN%
Unregistered
0123456789
FIELDNAME$
WRAPLINE$
SETUP_TOOLBAR
DEVICE
FINDOPO$
CREATEINDEX
NEXTID$
LOAD_INI_FILE
OPENELEMS
OPENELEMTYPES
TBARBUTT
FALSE
FIELDLIST1$
FIELDLIST2$
FIELDLIST3$
NOOFACTIVESCREENS%
INUSE%
PROMPT$
APPSHORT$
PATH$
ICON$
GELEM1&
GELEM2&
GELEM3&
GELEM4&
MAINTOOL&
DELTOOL&
NEWTOOL&
HELPID&
MAINTABLE$
MAINELEMS$
MAINELEM$
REG_NAME$
CU_POS&
CU_COUNT&
Fields:
c:\system\apps\
.appKW
c:\system\apps\
\system\apps\
d:\system\apps\
.appKW
d:\system\apps\
\system\apps\
.mbmK
Graphics not found:
.dbfKW
+'First time installation, please wait...
.dbf fields ID(10)K
(250)K
(10)K
(250)K
(250)K
(250)K
(250)K
(250)K
(250)K
(30)K
(30)K
(30)K
(250)K
to K
IDIndK
.dbfK
F1IndK
.dbfK
F2IndK
.dbfK
F3IndK
.dbfK
F4IndK
.dbfK
F5IndK
.dbfK
F6IndK
.dbfK
F7IndK
.dbfK
F8IndK
.dbfK
F11IndK
.dbfK
F12IndK
.dbfK
F13IndK
.dbfK
F14IndK
.dbfK
F15IndK
.dbfK
F16IndK
.dbfK
F17IndK
.dbfK
F18IndK
.dbfK
F19IndK
.dbfK
F20IndK
.dbfK
VideoC[]
+ upg21.opoO
+ upg22.opoO
MusicC[S
BandO
YearO
MainIndK
.dbfK
+*.dbf fields ID(10), EType(30) to ElemTypesK
ETYPE$
+ TypeIdInd
.dbfK+ ElemTypes
EtypeO
TypeEtypeInd
.dbfK+ ElemTypes
+4.dbf fields ID(10), L, TType(10), Text(250) to TextsK
TTYPE$
TEXT$
TTypeO
+ TextIdInd
.dbfK+
Texts
+#.dbf fields NextVal TO ElemSequenceK
SEQ&%
+#.dbf fields NextVal TO TextSequenceK
SEQ&%
+".dbf fields name(30) TO RegisteredK
NAME$
NAME$'
Unregistered
+4.dbf fields id(10), Name(30), clause(255) TO ClausesK
NAME$
CLAUSE$
+ ClauseIndK
.dbfK+
Clauses
NameO
ClauseNameIndK
.dbfK+
Clauses
+).dbf select id, name, clause from clausesK
NAME$
CLAUSE$
ElemSequenceO
BookC[\
NAME$'
Lent Out
CLAUSE$'
+'amount>0 and LentTo<>'' order by LentTo
VideoC[
NAME$'
Lent out
CLAUSE$'
+1amount>0 and LentTo<>'' order by TapeNo, StartPos
ElemSequenceO
NAME$'
Motion Pictures
CLAUSE$'
+Iamount>0 and Categories like '*Motion Picture*' order by TapeNo, StartPos
MusicC[h
NAME$'
Lent out
CLAUSE$'
amount>0 and LentTo<>''
ElemSequenceO
ArtC[
NAME$'
Lent out
CLAUSE$'
Elements>0 and LentTo<>''
ElemSequenceO
NAME$'
No Location
CLAUSE$'
Elements>0 and Location=''
WineC[
NAME$'
Ready To Drink
CLAUSE$'
+0amount>0 and ReadyYear<'2000' order by ReadyYear
ElemSequenceO
NAME$'
French Wines
CLAUSE$'
+.amount>0 and area like '*France' order by area
ElemSequenceO
NAME$'
Californian Wines
CLAUSE$'
+3amount>0 and area like '*California*' order by area
ElemSequenceO
NAME$'
Portuguese Wines
CLAUSE$'
+0amount>0 and area like '*Portugal' order by area
export.dbfW
+Bexport.dbf Fields name(20), prompt(20), seq(5), ftype(1) to export
NAME$
PROMPT$
FTYPE$
NAME$'
PROMPT$'
SEQ$'
SEQ$'
FTYPE$'
FTYPE$'
NAME$'
Notes
PROMPT$'
Notes
SEQ$'
FTYPE$'
+ ExpSeqInd
Export.dbf+
Export
export.dbf fields formatset(20), file(255), format, field(20), lastfield, prefile(255), postfile(255), prerecord(255), postrecord(255), startrecord, prefield(255), postfield(255), Note_NoOfLines, Note_LineWidth to format
FORMATSET$
FILE$
FORMAT%
FIELD$
LASTFIELD%
PREFILE$
POSTFILE$
PRERECORD$
POSTRECORD$
STARTRECORD%
PREFIELD$
POSTFIELD$
NOTE_NOOFLINES%
NOTE_LINEWIDTH%
FORMATSET$'
HTML Export
FILE$'
.expK
FORMAT%$
PREFILE$'
<html><head><title>
K+& List</title></head><body><center><h1>K
K+n List</h1><h2>Send queries and coments to <a href="mailto:My@Email.address">My@Email.address</a></h2></center>K
+ POSTFILE$'
<hr><i>Last updated on W
by K
</i></body></html>K
FIELD$'
<li><b>
+ PREFIELD$'
+ </b>: <i>
POSTFIELD$'
LASTFIELD%$
PRERECORD$'
<hr><ul>
POSTRECORD$'
</ul>
STARTRECORD%$
NOTE_NOOFLINES%$
NOTE_LINEWIDTH%$
FORMATSET$'
Sheet Export
FILE$'
.expK
FORMAT%$
PREFILE$'
+ POSTFILE$'
FIELD$'
+ PREFIELD$'
POSTFIELD$'
LASTFIELD%$
PRERECORD$'
POSTRECORD$'
STARTRECORD%$
NOTE_NOOFLINES%$
NOTE_LINEWIDTH%$
NoteO
HelpO
area='K
and(
area='K
and(
and area is null
ADDWHERE$
ALERT_INFO
SFIND$
MAINTABLE$
APPSHORT$
MAINELEMS$
where
.dbf select * from K
The Where-Clause is
characters too longKO
SETUP_SCREEN
PREF_RATING%
Preferences
Rating Style+SAsterix Scale (0-5),10 Point Scale,20 Point Scale,100 Point Scale, Description, Off
CancelO
REGISTER$
APPSHORT$
APPTITLE$
+ .dbf select name from RegisteredK
NAME$
NAME$#
UnregisteredC[
NAME$'
TBARINIT
TBARHIDE
TBARSHOW
APPSHORT$
TOOLBAR%
SCREENWIDTH%
W.OFL
DOBOTTLEINFO
NEWBOTTLE
BOTTLENOTES
DOBOTTLEINFO
DOSELECTELEMTYPE
DOPERSONALINFO
BOTTLENOTES
MAINSCN%
SCREEN%
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
{A` O
TBARHIDE
TBARSHOW
SETUP_SCREEN
TOOLBAR%
SCREENWIDTH%
DATESTR$
FETCHRATING$
WRAPLINE$
SCREEN%
SCREENW%
SCREENX%
SCREENWIDTH%
SCREENY%
SCREENH%
INUSE%
FONT&
ALIGNMENT%
PROMPT$
APPSHORT$
CU_POS&
CU_COUNT&
REG_NAME$
GELEM1&
GELEM2&
GELEM3&
GELEM4&
ETYPE$#
No Id
<No O
WineC+
WineC[*
% alc.K
StampC[!
WineC[(
ArtC[5
O @[j
ArtC[
StampC["
F10$#
F11%
F14$#
F15&!
F16$#
F17$#
F18$#
HomeC
StampC`[
F19&!
F19&!
{U}WB
F19&!
QMO<{U}WB
F19&!
QMO<{
QM}WB
F20$#
WineC[
+&.dbf select text from texts where ID='K+
K+"' and TType='NOTES' order by id, lK
TEXT$
TEXT$#
Find:
O$@[)
WineC[
Area Rating:
TBARSETTITLE
DEVICE
PATH$
APPSHORT$
HELPTHREAD&
.hlpKO
.hlpK
Help file (
.hlp) not foundK
EXIT$
SAVE_INI_FILE
FINDOPO$
HELPTHREAD&
Closing, please wait...
cabinet.opoO
pythia.opoO
SETUP_SCREEN
NOOFACTIVESCREENS%
NOOFSCREENS%
INUSE%
SETUP_SCREEN
NOOFACTIVESCREENS%
INUSE%
FALSE
BOTTLEINFO
SETUP_SCREEN
INUSE%
PERSONALINFO
SETUP_SCREEN
INUSE%
SETUPMULTILINE
GETMULTILINE$
DOPERSONALINFO
BOTTLENOTES
DOSELECTELEMTYPE
INUSE%
MAINELEM$
PROMPT$
CU_LIST%
CU_LIST$
to maintainK
F10$#
+ Maintain
InformationKO
<No O
ETYPE$#
,...K
ETYPE$#
SaveOsO
Collection InfoOa+
NotesOn
F10$'
Os@[^
SETUPMULTILINE
GETMULTILINE$
MAINELEM$
INUSE%
PROMPT$
APPSHORT$
to maintainK
O"{WK
O"{WK
O"{WK
F14$#
F16$#
F17$#
F18$#
F20$#
F11%
F15&!
F19&!
Maintain Collection InformationO
HomeC
StampC`[
SaveOs+
CancelO
F14$'
F16$'
F17$'
F18$'
F20$'
F11%$
F15&%
F19&%
Os@[J
MAINTAINBOTTLENOTES
SETUP_SCREEN
FETCHTEXT&
STORETEXT
MAINELEM$
APPSHORT$
to maintainK
Notes for +
- K+
NOTESO
.dbfKO
SaveOs
Os@[-
NOTESO
.dbfKO
OPENELEMS
OPENELEMTYPES
ACTIVEWINDOWS
CU_POS&
Jumping to first
Jumping to first
ACTIVEWINDOWS
CU_POS&
CU_COUNT&
Jumping to last
NEXTID$
ALERT_YESNOCANCEL$
OPENELEMS
BOTTLEINFO
ACTIVEWINDOWS
APPSHORT$
MAINELEM$
SFIND$
CU_COUNT&
CU_POS&
ElemSequenceO
Copy fields from +
into new K
+E(To avoid a bug in OPL your current where clause will now be cleared)O
F10$#
F11%
F14$#
F15&!
F16$#
F17$#
F18$#
F19&!
F20$#
WineC[#
F10$'
F11%$
F15&%
F14$'
F16$'
F17$'
F18$'
F19&%
F20$'
ALERT_OK$
ACTIVEWINDOWS
MAINELEM$
CU_COUNT&
CU_POS&
DeletingO
to deleteK
+ deleted.K
SELECTELEMTYPE$
SETUP_SCREEN
MAINELEM$
to updateK
NEWELEMTYPE$
EDITELEMTYPE$
DELETEELEMTYPE%
PROMPT$
MAINELEM$
CU_LIST%
CU_LIST$
Selection for current K
type not found (K
<No O
ETYPE$#
),...K
ETYPE$#
SelectO
EditOe+
NewOn+
DeleteOd+
CancelO
MAINELEM$
PROMPT$
NEW ID
TypeK
Create new O
CreateO
CancelO
ETYPE$'
REOPENELEMTYPES
CHANGEELEMTYPE
PROMPT$
not foundK
ETYPE$#
Edit O
SaveO
CancelO
ETYPE$'
CHANGEELEMTYPE
MAINELEM$
type not foundK
Another
type exists with this id (K
FIELDNAME$
REOPENELEMS
APPSHORT$
PROMPT$
MAINELEMS$
MAINELEM$
.dbf select id, KO
from K
where KO
cleared of this K
typeK
FINDFIRST
SCREEN%
FIND$
ACTIVEWINDOWS
CU_POS&
FIND$
MAINELEMS$
Jumping to first
Jumping to first
No more
ACTIVEWINDOWS
CU_POS&
CU_COUNT&
FIND$
MAINELEMS$
Jumping to last
No more
ACTIVEWINDOWS
FIND$
CU_POS&
+ Not found
ACTIVEWINDOWS
FIND$
CU_POS&
+ Not found
File,Folder,DiskK
CancelO
OPENELEMS
FIELDNAME$
PROMPT$
FIND$
APPSHORT$
MAINELEM$
Calculating...
> 0KO
MusicC
ArtC`[$
F11%
F11%
F11%
MusicC
ArtC`[#
Item Count:
Count:K
Title Count:
Total Spending:
Total Value:
Total Surplus:
Average Spending:
Average Value:
Total Surplus %:Od|
SETUPMULTILINE
FIELDNAME$
CHOICEDIALOG$
ALERT_INFO
NEXTID$
EDITCLAUSE
GETMULTILINE$
OPENELEMS
ACTIVEWINDOWS
ERROR_HANDLER
SFIND$
PROMPT$
APPSHORT$
FIELDLIST1$
FIELDLIST2$
FIELDLIST3$
TESTING%
CU_POS&
CU_COUNT&
MAINELEMS$
APPTITLE$
APPVER$
EMAIL$
+5Type in an SQL where clause (without the WHERE token)O
+6Abbreviations: (must be first character in the string)
a: O
o: order by
VideoC[)
ot: order by TapeNo, StartPos
ListOl+
SaveOs+
CancelO
Ol@[B
QueryO
+/.dbf select id, name from Clauses order by nameKO
+*.dbf select clause from Clauses where id='K
CLAUSE$
CLAUSE$#
ErrorO
Could not find selected clauseO
+).dbf select id, name, clause from ClausesK
NAME$
CLAUSE$
ElemSequenceO
NAME$'
New Clause
+*.dbf select clause from Clauses where id='K
CLAUSE$
ErrorO
Could not find selected clauseO
Os@[<
@`\['
o C["
order by
otC[!
order by TapeNo,StartPos
found, please retypeK
Bad query - please, retype W
SETUPMULTILINE
GETMULTILINE$
APPSHORT$
+4.dbf select id, name, clause from Clauses where id='K
NAME$
CLAUSE$
NAME$#
CLAUSE$#
Edit Clause:
ClauseO
SaveOs+
CancelO
W7Os@[1
NAME$'
CLAUSE$'
FINDOPO$
EXPORT
export.opoO
APPSHORT$
+3.dbf select ID, EType from ElemTypes order by etypeK
ETYPE$
ALERT_INFO
REOPENELEMS
ACTIVEWINDOWS
MAINELEMS$
SFIND$
APPSHORT$
CU_POS&
CU_COUNT&
+ Find Note
Set+$Find Note can only fetch sets of 12
+%Specify the set that you want to see.
1-12, 2: K
13-24 etc)K
Search for NoteO
CancelO
+<.dbf select id, l, ttype, text from texts where text like '*K
TTYPE$
TEXT$
id='K+
WarningO
could not be fetched. Try using a more precise search string or view the remaining sets separately. You will now be viewing set K
InformationO
No matching notes were foundO
Canceled
ADDWHERE$
FIELDNAME$
CHOICEDIALOG$
DOBOTTLEINFO
NEWBOTTLE
DELETEELEM
ACTIVEWINDOWS
SFIND$
APPSHORT$
PROMPT$
MAINELEMS$
CU_POS&
+%Enter field name to view in list view
+ List ViewO
.dbf select id,KO
from K
+ ORDER BY C[
and K
+ ORDER BY C[
where
DORUN
PROCESSy
ACTION_KEY
PRINTKEY
EVENTM
LOAD_INI_FILE
SAVE_INI_FILEC
REREGISTER
GETLISTORS$
OPENELEMS
PREFERENCES(,
TJEKREGISTRATION
SETUP_TOOLBAR
CMDA%
CMDB%7.
CMDC%Y.
CMDD%}.
POINTER_EVENT
TOOLSWITCH
SETUP_SCREEN
TOOLBARTITLEo;
BACKGROUND
FOREGROUND
STATICWINDOWS
ACTIVEWINDOWS%>
DEVICE
DOBOTTLEINFO
DOPERSONALINFO_?
BOTTLEINFO
PERSONALINFO
BOTTLENOTES8J
MAINTAINBOTTLENOTESzJ
REOPENELEMS
REOPENELEMTYPES
NEXTELEM
PREVIOUSELEMrL
NEWBOTTLE
DELETEELEM
DOSELECTELEMTYPE
SELECTELEMTYPE$OR
NEWELEMTYPE$
EDITELEMTYPE$
DELETEELEMTYPE%
CHANGEELEMTYPE
FINDELEM
FINDNEXT1Y
FINDPREVIOUS
FINDFIRST
FINDLAST:[
GETFILENAME$
SHOWPRICES
SFINDELEM
EDITCLAUSEXe
FIELDNAME$
DOEXPORT
OPENELEMTYPEScg
FINDNOTE
DOLISTVIEW
ADDWHERE$.m
DBASE[
SYSRAM1
SYSTEM\
D:\programs\Pythia\pythia
File: PYTHIA.OPO
Version: 1.8.1
+0 This file cannot be executed by itself
+= Copyright
1999-2000 PocketIQ & PYTHIA Information
ALERT_OK$
Exit programO
Shutting down...
SHOWERROR
APPSHORT$
C:\SYSTEM\OPL\
C:\SYSTEM\OPL\
D:\SYSTEM\OPL\
D:\SYSTEM\OPL\
+ The file
K+- is not found in \system\opl or \system\apps\K
APPSHORT$
APPYEAR$
APPAUTHOR$
SPLASHID&
SPLASHXPOS%
SPLASHYPOS%
APPTITLE$
APPVER$
APPEMAIL$
C:\SYSTEM\OPL\PIQInfo.rscW
C:\SYSTEM\OPL\PIQInfo.rsc
D:\SYSTEM\OPL\PIQInfo.rscW
D:\SYSTEM\OPL\PIQInfo.rsc
E:\SYSTEM\OPL\PIQInfo.rscW
E:\SYSTEM\OPL\PIQInfo.rsc
C:\SYSTEM\OPL\PIQInfo.mbmW
C:\SYSTEM\OPL\PIQInfo.mbm
D:\SYSTEM\OPL\PIQInfo.mbmW
D:\SYSTEM\OPL\PIQInfo.mbm
E:\SYSTEM\OPL\PIQInfo.mbmW
E:\SYSTEM\OPL\PIQInfo.mbm
C:\SYSTEM\APPS\
.aifKW
C:\SYSTEM\APPS\
.mbmK
D:\SYSTEM\APPS\
.aifKW
D:\SYSTEM\APPS\
.mbmK
E:\SYSTEM\APPS\
.aifKW
E:\SYSTEM\APPS\
.mbmK
& Pocket IQK
OxO,O
SHOWSPLASH
SPLASHID&
APPTITLE$
APPVER$
APPYEAR$
APPAUTHOR$
APPEMAIL$
C:\SYSTEM\OPL\PIQInfo.opoW
C:\SYSTEM\OPL\PIQInfo.opo
D:\SYSTEM\OPL\PIQInfo.opoW
D:\SYSTEM\OPL\PIQInfo.opo
E:\SYSTEM\OPL\PIQInfo.opoW
E:\SYSTEM\OPL\PIQInfo.opo
About
+ version K
Copyright (C)
& Pocket IQKO
http://www.pocketIQ.comO
FINDOPO$
ABOUTPALM
pscape.opoO
+'Sorry, an unexpected error has occured.
Please E-mail me at:
andK
++tell me the exact circumstances and the key
presses that led to this error.
++I will also need the following information:
- W
- W
ContinueO
.dbf select nextval from K
SEQ&!
SEQ&%
ALERT_INFO
ErrorO
HTMLC[
<TITLE>
</TITLE>K
HTMLC[
<IMG SRC="
HTMLC[3
HTMLC[
</i>K
HTMLC[
</b>K
HTMLC[
HTMLC[!
<center>
K+ </center>K
CollectionC[
Cabinet Suite
Registering
+:Type in the name that you have registered and the key that
you have received.
C\`[j
Invoice ManagerC[/
+!Company Accounting registered to
registered to K
Registration failed
CU_LIST$
CU_LIST%
NAME$
NAME$#
K+ <NO NAME>K
NAME$#
<NO ITEMS>
+' select ID, TType from Texts where ID='K
' and TType='K
TTYPE$
+% select ID, L, TType, Text from TextsK
TTYPE$
TEXT$
TTYPE$'
SEQ&%
TEXT$'
TTYPE$'
SEQ&%
TEXT$'
SHOWERROR
SHOWERROR
SHOWERROR
O$h@[
<EOF>
SHOWERROR
O$h@[
<EOF>
SHOWERROR
+" select Text from Texts where ID='K
' and TType='K
' order by id,lK
TEXT$
TH{WK
TEXT$#
WRAPLINE$
WRAPLINE$
CancelO
WRAPLINE$
CancelO
CHOICEDIALOGNEW$
REPLACE$
NAME$
Select
NAME$#
<Empty
,...K
NAME$#
<Empty
SelectO
NewOn+
DeleteOd+
EditOe+
CloseO
SelectO
CloseO
SEC["
SelectO
EditOe+
CloseO
EnterC[!
EXIT$
FINDOPO$o
SHOWSPLASHe
ABOUT
ABOUTXs
ERROR_HANDLER
NEXTID$
SETUPMULTILINE
GETMULTILINE$
SHOWERROR4
REPLACE$f
HTF_TITLE$
HTF_IMG$&
HTF_H$^
HTF_I$
HTF_B$
HTF_P$)
HTF_CENTER$f
REGISTER$
MAKELIST$G
STORETEXT$
WRITELINE
WRITETOKENb
READLINE$
READTOKEN$
OPENFILE%
FETCHTEXT&
WRAPLINE$
ALERT_INFO
ALERT_OK$
ALERT_YESNOCANCEL$e
CHOICEDIALOG$-
CHOICEDIALOGNEW$k
DATESTR$
SENDSTRING
SENDTOKEN
RUNAPPLICATION&
SYSTINFO
SYSTEM\
D:\programs\Cabinet\CabUpg23.opl
NEXTID$
+"Upgrading Video.dbf to version 2.3
c:\system\opl\pythia.opoW
c:\system\opl\pythia.opo
d:\system\opl\pythia.opoW
d:\system\opl\pythia.opo
+(Could not find PYTHIA.OPO in \system\opl
c:\system\apps\video\video.dbfW
c:\system\apps\video\
d:\system\apps\video\video.dbfW
d:\system\apps\video\
EtypeO
TypeEtypeInd
+ Video.dbf+ ElemTypes
+9Video.dbf fields id(10), Name(30), clause(255) TO Clauses
NAME$
CLAUSE$
VideoClauseInd
+ Video.dbf+
Clauses
NameO
VideoClauseNameInd
+ Video.dbf+
Clauses
+.video.dbf select id, name, clause from clauses
NAME$
CLAUSE$
VideoO
ElemSequenceO
NAME$'
Lent out
CLAUSE$'
+1amount>0 and LentTo<>'' order by TapeNo, StartPos
NAME$'
Motion Pictures
CLAUSE$'
+Iamount>0 and Categories like '*Motion Picture*' order by TapeNo, StartPos
+!Upgrading Wine.dbf to version 2.3
c:\system\apps\wine\Wine.dbfW
c:\system\apps\Wine\
d:\system\apps\wine\Wine.dbfW
d:\system\apps\Wine\
EtypeO
TypeEtypeInd
Wine.dbf+ ElemTypes
+8Wine.dbf fields id(10), Name(30), clause(255) TO Clauses
NAME$
CLAUSE$
WineClauseInd
Wine.dbf+
Clauses
NameO
WineClauseNameInd
Wine.dbf+
Clauses
+-Wine.dbf select id, name, clause from clauses
NAME$
CLAUSE$
WineO
ElemSequenceO
NAME$'
Ready To Drink
CLAUSE$'
+0amount>0 and ReadyYear<'1999' order by ReadyYear
NAME$'
French Wines
CLAUSE$'
+.amount>0 and area like '*France' order by area
NAME$'
Californian Wines
CLAUSE$'
+3amount>0 and area like '*California*' order by area
NAME$'
Portuguese Wines
CLAUSE$'
+0amount>0 and area like '*Portugal' order by area
+!Upgrading Book.dbf to version 2.3
c:\system\apps\Book\Book.dbfW
c:\system\apps\Book\
d:\system\apps\Book\Book.dbfW
d:\system\apps\Book\
EtypeO
TypeEtypeInd
Book.dbf+ ElemTypes
+8Book.dbf fields id(10), Name(30), clause(255) TO Clauses
NAME$
CLAUSE$
BookClauseInd
Book.dbf+
Clauses
NameO
BookClauseNameInd
Book.dbf+
Clauses
+-Book.dbf select id, name, clause from clauses
NAME$
CLAUSE$
BookO
ElemSequenceO
NAME$'
Lent Out
CLAUSE$'
+'amount>0 and LentTo<>'' order by LentTo
c:\system\opl\pythia.opoW
c:\system\opl\pythia.opo
d:\system\opl\pythia.opoW
d:\system\opl\pythia.opo
+(Could not find PYTHIA.OPO in \system\opl
UPGRADE5
SYSRAM1
DBASE[
?Vm&X
x{%Xn
TU$XU5
SUUUU
"Data.app
0. Book C
1. About
2. Main S
3. The Bo
4. The Co
5. Readin
6. Findin
7. Book T
8. Import
9. Acknow
10. Future
11. How to
12. Licenc
13. Readme
15. Readme
15. Readme
17. Readme
17. Readme
Table1
ColA8
ColB8
ColA9
ColB9
Index1
ColA8
Table1
I would like to thank the following persons for helping me out:
Al Richey, for the very usefull EventDemo
Chris Pope, for his collection of clipart images
Jeff Johnstone, for his long list of good enhancement requests and programming tips.
and of course...
Vibeke and Sasha de Oliveira for putting up with me!
12. Licence agreement7
13. Readme.txt
and of course...
Vibeke and Sasha de Oliveira for putting up with me!
Book types are registered in a separate table containing two fields:
1) Book type sort code
2) Book type name
A book type sort code will be stored with every book cover. The related book type name is looked up and showed on the Book Cover on the main screen.
The sort key can be used to sort the books. This will allow you to specify the book type's real name without having to think about how it will be sorted. Ex:
Book Type Name: Comic Books
Sort key: 050
You can activate the Book Type Selection window from the main screen by pressing Ctrl-Shift-T.
The Book Type Selection window lets you perform the following tasks:
Select
Returns the current book type as a new value for the current book cover (shown on the main screen)
Edit code and name of the current book type.
Note! If you change the book type code all book covers marked with this code will be changed as well.
Create a new book type.
Delete
Delete the current book type.
Note! If no other book type with the same code exists all books with the same book type will be updated with no book type.
If you wish to delete an existing book type you should first change the code to one used by another book type. By doing that all books of the type to be deleted will obtain the other book type instead of having no book type.
You can simply browse around your book collection using the left (previous), right (next), home (first) and end (last) buttons. You can also use the List View (Shift-Ctrl-L) to browse through your titles. More advanced browsing can be done using the Find Field and Define Where Clause. You can also get Summary Information on your book collection.
Find Field
The Find Field is found on the bottom right corner of the screen.
You can activate the Find Field by pressing Ctrl-F.
When activated the Find Field lets you type in a search criteria. Submit the search criteria by pressing Enter and the main screen will show the first occurence of a book containing that criteria in one of its text fields (not including the Reading Notes nor the Book Type description).
You can browse around the books matching the entered search criteria using the up (previous), down (next), pgup (first) and pgdn (last) keys. The left and right keys can still be used to browse through all the books.
Define Where Clause
If you have a little knowledge of SQL you can define the where clause to be used.
You can access the Define Where Clause window by pressing Ctrl-W.
Here you can specify the where clause of the view being used. An empty where clause selects all books.
You should not specify the "where" token here, just what is to follow it.
Here are some examples of strings you could specify:
1) "amount > 0"
2) "amount > 0 and PublishedYear <= 1900"
3) "amount > 0 and category like '*travel*'"
Note, if you enter an "a" as the first character of the where clause it will be interpreted as "amount>0". This means that you can write the following where clause:
"a and Publishedyear < 1998"
The names of the fields are shown at the bottom of the Define Where Clause window.
You can also use the Define Where Clause to specify an order by clause. All fields have indexes allowing them to be used in an order by clause.
From the Define Where Clause window you can access the Where Clause List window by pressing Ctrl-L. Here you can maintain named where clauses for reuse.
Define Where Clause can be used together with the Find Field. Up and down keys will browse through entries matching both settings while left and right keys will browse through entries matching the where clause.
List View
From the main screen you can open the List View window by pressing Shift-Ctrl-L.
This window will show you the list of titles that match your where clause. The list will also be sorted as specified in the where clause.
From the List View window you can:
- create a new entry
- delete an entry
- edit an entry
- select the entry to be viewed in the main window.
Get summary information
From the main screen you can open the Summary Information window by pressing Ctrl-S.
This window will show:
1) The number of books in your collection
2) The number of different books in your collection (number of covers with amount set to at least 1)
3) The price you have paid for the entire collection
4) The value of the entire collection
5) The difference between the value of the collection and what you have paid for it (surplus)
6) The average book price
7) The average book value
8) The surplus as a percentage of your spendings
The summary is based on the current Find Field and Where Clause. If the current Find Field and Where Clause are empty the Summary Information will be based on the entire collection.
Three lines of the Reading Notes can be seen from the main screen (left bottom).
You can activate the Reading Notes page related to the current book by pressing Ctrl-N.
Here you can type in narrative notes on the related book. When did you read it? What have you heard about it? What do you think about the book?
The Collection Card is placed on the right side of the screen.
You can access the Collection Card window by tapping anywhere on the Collection Card or by pressing Ctrl-C og Enter.
There is one Collection Card for each Book Cover. The Collection Card contains information about you private book collection:
Amount (the number of copies of the related book, default value 1 book).
My Price (the price you have paid for the book. If you buy more books at different prices you will have to specify an average price).
Ordinary Price (the current market price of the book).
Purchased From.
Purchase Date (default value current date, so you should register your book right there in the shop when you buy it :-)).
State (specification of the book's physical state: new, torn etc).
Location (this field should contain a shelf specification or some other way of indicating where to find the book).
Lent To (when lending out your books make a note in this field about it).
The Book Cover is the left part of the screen framed like a book cover.
By pressing Ctrl-L, Space or tapping on the cover you open the Book Cover window.
Here you can maintain information that you would usually find on a book cover:
Name.
Author.
Publisher.
Category (crime story, biography etc).
Language (the language of the book you have registered).
ISBN.
Pages (no of pages).
Published year.
Book Type (The book types are stored separately letting you define short codes for each book type to facilitate your searches on book types. Ex: "PBC, Paper Back", this code will let you search for paper backs using the search criteria "PBC").
Read more about Book Types in section 7.
The main screen contains the folowing four objects:
1) A Book Cover on the left containing information that you would find on a book cover (name, author, publisher, etc)
2) A Collection Card on the right containing information about your book collection (amount, purchace information, location etc)
3) A window containing the first three lines of your Notes. You can access the entire text by tapping in the window or by pressing Ctrl-N.
4) A Find Field is placeed in the bottom right corner for performing searches in the Book Collection.
There is also access to:
5) You can open the Summary Information window by pressing Ctrl-S.
6) You can access the Define Where Clause window by pressing Ctrl-W.
Each of these objects are described in detail in the following sections.
Createing and Deleting Books
You can create new entries directly from the main screen by pressing Ctrl-Shift-N.
When creating a new entry you will be asked if you want the information on the current book to be copied to the new entry.
You can delete the current Book directly from the main screen by pressing Ctrl-Shift-D or just pressing the Del key.
You can import and export collection information to/from ascii files using the Import/Export utility.
Activate the Import/Export utility by pressing Ctrl-Shift-E.
1) Import an ascii file by pressing the import button (Ctrl-M) from the Import/Export window.
2) Generate an export file by pressing the Export button (Ctrl-X) from the Import/Export window.
The Import/Export window prompts you for a file name. The Import/Export window also lets you access five other windows:
1) The Set window (Ctrl-S) lets you define format sets for import and/or export. If the file export.dbf does not exist (eg first time you start the program) sets for Sheet and HTML exports are created for you.
2) The Form window (Ctrl-F) lets you specify the format of the current Set:
Format: List or Form. List reads/produces simple import/export files only containing field values and separators. Form produces export files containing both field values and field prompts. Note that you cannot import files in Form format.
File Head: The string to be placed in the beginning of the file. This string is only placed once in each import/export file.
File Foot: The string to be placed in the end of the file. This string is only placed once in each import/export file.
Before Record: The string to be placed before each collection item in import/export files. Strings of more or less than one character are extended with a new line character.
After Record: The string to be placed after each collection item in import/export files. Strings of more or less than one character are ext
ended with a new line character.
End With After Record: If checked, the After Record separator is also placed after the last collection item of the import/export file. If unchecked, the After Record separator is only placed between records.
Field separator: The string to be placed between all fields. An empty field separator is implemented as a new line character.
End with field separator: If checked, a field separator is added to the end of each record (after the last field). If unchecked, the field separators are only placed between fields.
Before Field: A string to be placed before each field. This is used to enclose the fields.
After Field: A string to be placed after each field. This is used to enclose the fields.
3) The Lable fields (Ctrl-L) window lets you specify the order of the Lable Item fields. Low sequence numbers are placed before high numbers. Fields without sequence numbers are not imported/exported at all.
4) The Collection fields (Ctrl-C) window lets you specify the order of the Collection fields. Low sequence numbers are placed before high numbers. Fields without sequence numbers are not imported/exported at all.
5) The Notes (Ctrl-N} window lets you setup the output format of the Notes field.
As for 2) and 3) you can specify the sequence numer of the Notes field. Again an empty field specifies that you do not want the Notes included in the import/export.
The No Of Lines field lets you specify a fix number of lines to be generated for Notes. If the actual notes take less lines that what you have specified blank lines will be added to mach your setting. If the notes cannot fit within the specified number of lines the text will be truncated. If you set the No Of Lines field to "0" all text will be included in the export and no extra lines will be added.
The Line Width field is used to specify a maximum line width to be used for Notes. This will assure that no line will be wider than Line Width characters. If you have <new line> characters in your notes, some lines might get shorter than the specified width.
Sketch
&Paint.app
- The Book Collection by Pythia Information lets you organize your book collection and reading notes.
- You can register the following types of information:
1) book information (name, author, subject, publisher, format etc)
2) information about your collection (prices, purchace information, location etc.)
3) reading notes
- You can import and export data into/from the Book Collection in a completely user defined layout.
- The Book Collection displays counts and sums of your book collection.
- You can perform searches based on combinations of all fields.
Registering the program will give you the following benefits:
1) The register window will not pop up on startup
2) You get free support via e-mail (Pythia@Palmscape.com)
3) Your suggestions to new functionalities will be implemented (as far as resources permits it)
Pricing:
Collection Suite programs are registered either using individual codes for each application or using a Collection Gold Code. This code is valid for all present and future Collection Suite programs.
How to register
Pocket IQ applications can be registered exclusively through Palmscape, the leading online store for the EPOC platform.
To register this product simply visit the Pocket IQ internet site and follow the registration instructions.
Alternatively you can register directly with Palmscape in any of the following ways:
Online Orders:
Purchase online via Palmscape's secure online service. Simply visit www.palmscape.com, and select the "Buy now" link. Palmscape accept most major credit cards (see below).
Telephone \ Fax orders:
Palmscape accept telephone orders via the United Kingdom office which can be reached on +44 (0)1234 353970.
Postal Orders:
Payment can be made by UK Cheque, Cash or Credit Card direct to the Palmscape office, located at:
44 Harpur Street
Bedford
Bedfordshire
MK40 2QT
England.
Please mark clearly that you wish to purchase this application.
Payment types:
Palmscape accept major Credit cards, Switch, Delta as well as UK Cheque, Eurocheque and Cash. If you are paying in any currency other than GB Pounds please add 10% to cover conversion fees.
1. About this application7
3. The Book Cover7
2. Main Screen7
11. How to register5
4. The Collection Card7
10. Future versions7
Future versions of the Book Collection will include the following functionality:
1) Formated output for priting
2) More overview screens with statistics.
Any additional ideas are welcome.
9. Acknowledgment7
6. Finding Information7
5. Reading Notes7
7. Book Type?
Arial
8. Import/Export7
0. Book Collection7
1998-2000 Marc de Oliveira & PocketIQ
Internet: http://www.PocketIQ.com
E-mail: Pythia@PocketIQ.com
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 Agreement, 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 application 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 purpose. In no event shall Pocket IQ, the independent application author or its suppliers be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) 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.
@Book Collection 2.7.2 for EPOC (C) Marc de Oliveira 1998-2000 & PocketIQ
If you are upgrading from version 2.1.1 or lower, please, read the upgrade section.
Installation from SIS file:
1) Execute the book.sis file on your pc or Psion.
2) Choose C or D drive for the installation (make sure that there is enought disk space).
3) The program will install itself.
Installation from ZIP file:
1) Make sure the \System folder is shown on your Series 5 system screen. If it's not, enable it in the 'Preferences' dialogue.
2) Using PsiWin copy the files PYTHIA.OPO, EXPORT.OPO, CABINET.OPO, PSCAPE.OPO and PSCAPE.MBM to the folder \system\opl (you might have to create the folder)
3) Go into \System\Apps on C: or D: and make a new folder called "Book"
4) Using PsiWin, copy the following files to the new \System\Apps\Book folder:
book.app
book.aif
book.mbm
book.hlp
4) Copy the file sysram1.opx in the folder \system\opx
5) A new icon should appear on your Extras bar
Upgrade:
--------
To upgrade to version 2.3 from a previous version:
1) Backup the .DBF and .INI files of all your Cabinet Suite applications.
2) Perform the installation as described above. Do NOT over write or remove the files with the extention .DBF or .INI.
3) Make sure that no Collection Suite application is being run.
4) Copy the CabUpg23.opo to any directory and execute it by double tapping on it's icon. The program will upgrade all your Collection Suite .DBF files.
5) Delete the CabUpg23.opo file.
6) All your Collection Suite applications are now upgraded to version 2.3. Note, you only need to perform this upgrade once. You should not try to upgrade each Collection Suite application individually.
Problems
--------
1. Read only files
Some times files become read only while being installed. None of the files should be read only. If you get any errors like the program is unable to write information to your Psion go through the program files to see if some of them are read only.
In the system-view you can open the file property window by selecting (highlighting) a file and pressing Ctrl-P. In the property window you can see and set/clear the read only checkbox.
2. Copying between C and D
Be very careful when you move or copy applications between the C and D drives. It seems that the Psion is not correctly updated when applicaions are copied from C to D or vice versa.
Always delete the application directory from one drive before reinstalling on the other drive.
3. Low on battery
When starting up this program for the first time a lot of writing is done to the disk. If your machine is low on battery these writes can go wrong and turn the application files bad. This should only be an issue when running the application the first time.
4. Not enough memory
This program needs up to 300 Kb of free memory on the C drive. If you try to run the program with less than 300 Kb of free memory on the C drive it may not behave as expected.
Usage:
------
Press Ctrl+Shift+H to see help file.
Bugs:
-----
Registering the program will give you the following benefits:
1) The register window will not pop up on startup
2) You get free support via e-mail (Pythia@Palmscape.com)
3) Your suggestions to new functionalities will be implemented (as far as resources permits it)
Pricing:
Collection Suite programs are registered using a Collection Gold Code. This code is valid for all present and future Collection Suite programs. The Collection Gold Code costs USD 30.
How to register:
Go to the Palmscape home page at:
http://www.Palmscape.com
Here you can register using credit card or cheque.
After receiving your registering fee I will mail you a Key that you can use to register the program.
Made by:
--------
Marc de Oliveira
for Palmscape & Pythia Information
Web: http://www.Palmscape.com
E-mail: Pythia@Palmscape.com
History:
--------
1998.05.09: Version 2.0
- The Cabinet Suite started on version 2.0 because Personal Wine Cabinet is considered version 1 of The Cabinet Suite.
1998.05.14: Version 2.0.1
- Palmscape splash screen shown during startup.
1998.05.18: Version 2.0.2
- Cabinet Gold Code enabled
- Fixed: When toolbar is hidden fields disappear
1998.05.21: Version 2.0.3
- Export/Import bug fixed
- Summary fails if no amounts have been entered: fixed
- Position marker can now show more than 2 digit positions.
1998.06.08: Version 2.1
- New utility (Find Note) to search through the Cabinet Notes
- Serious increase of size for the Where Clause specification from about 30 charaters to about 220 characters. Now you can really make advanced searches
- Faster
- Some bug fixes
1998.07.03: Version 2.2
- New utility to store sql queries for reuse.
- To make advanced searches easier a list of all field names are now shown on the Where Clause window.
1998.07.06: Version 2.3
- The main screen has been changed to allow for a three line view of your notes. By tapping on the three-line window you open the Notes Editor.
- The time used to move from one element to another has been reduced significantly.
- Find Previous/Next keys are moved from Ctrl-O/Ctrl-P to Ctrl-I/Ctrl-J to follow Psion standard.
- The program no longer crashes when old version of ps.opo is used.
- Database files are now only compacted if they have been changed. This makes the shutdown of the application faster when you have not updated it.
- Book formats are now sorted alphabetically.
- Import/Export bug fixed.
1998.10.01: Version 2.4
- A new Element List (Shift-Ctrl-L) lets you browse through your collection items quickly. The Element List is based on your current query criteria and sort command.
1999.02.25: Version 2.5
- The Import/Export uility has been extended with enough parameters to make it possible to export cabinet information in HTML format for direct upload on the world wide web.
- Multible import/export settings can be named and stored for different types of import/export.
- The actual screen size is now exploited (horizontally) giving more room for fields when using the EPOC emulator.
- The date format used in the program can be defined in the system control panel.
- Book Cabinet has been renamed to Book Collection.
- No Palmscape logo during startup.
- New Palmscape logo in the About box.
1999.03.28: Version 2.5.1
- Geofox enabled: Screen no longer reacts when the mouse passes over a field.
1999.06.09
: Version 2.5.2
- To avoid a OPL bug the where clause is now cleared when you create a new record.
1999.06.29:
Version 2.6
- The application has been updated to work on both the Psion 5 and 5mx.
2000.06.01: Version 2.7.2
- Released as a PocketIQ product.
Courier
Courier
Courier
D:\programs\Book\book.opl
TBARLINK
Z:\SYSTEM\OPL\TOOLBAR.OPO
MainO
APPSHORT$
MAINELEM$
MAINELEMS$
TESTING%
MAXLISTLEN%
NOOFSCREENS%
NOOFACTIVESCREENS%
MAXNOTESIZE%
APPTITLE$
APPVER$
APPAUTHOR$
APPYEAR$
EMAIL$
APPEMAIL$
YSLIDE
CPRIGHT$
REG_KEY$
REG_NAME$
PREF_RATING%
NAGWIN%
FIND$
SFIND$
TOOLBAR%
CONTROL%
SHIFT%
SCREENWIDTH%
FALSE
THREE&
FOUR&
MINIT%
MAINSCN%
PROMPT$
INUSE%
ALIGNMENT%
FONT&
SCREEN%
SCREENX%
SCREENY%
SCREENW%
SCREENH%
ICON$
PATH$
DATA$
LASTUSED$
HELPTHREAD&
UPID&
DOWNID&
SLIDERID&
FINDID&
HELPID&
MAINTOOL&
GELEM1&
GELEM2&
GELEM3&
GELEM4&
GELEM5&
GELEM6&
NEWTOOL&
DELTOOL&
CU_LIST$
CU_LIST%
CU_INV$
CU_POS&
|' CU_COUNT&
MAINTABLE$
IP_NEWELEM$
FIELDLIST1$
FIELDLIST2$
FIELDLIST3$
IMPORTDATA$
) SPLASHID&
SPLASHXPOS%
SPLASHYPOS%
SHOWSPLASH
FINDOPO$
INITLOCAL
EVENT
DORUN
(F7)F
Books
Book+
CollectionK
2.7.2
Marc de Oliveira
+ 1998-2000
Copyright
Pythia@PocketIQ.com
Starting up
c:\system\opl\pythia.opoW
c:\system\opl\pythia.opo
d:\system\opl\pythia.opoW
d:\system\opl\pythia.opo
+(Could not find PYTHIA.OPO in \system\opl
@W.(^
cabinet.opoO
PROMPT$
TOOLBAR%
MINIT%
CONTROL%
File+
Import/Export...OEh+
CloseOe
Edit+
FindOf+
Where ClauseOw+ Find NoteOFh+
New +
BookKON+
Delete +
BookKOD
Windows+
Book+
Information...KOl+
Collection Information...Oc+
Note Book...On+
Select O
...KOTh+
Summary InformationOs
View+ List ViewOL+
Find Previous +
BookKOi+
Find Next +
BookKOj+
Find First +
BookKOI+
Find Last +
BookKOJh+
Show toolbarOt(
Tools+
RegisterOr+
AboutOA+
HelpOH
W:O`L{
STATICWINDOWS
ACTIVEWINDOWS
PROMPT$
INUSE%
FONT&
ALIGNMENT%
SCREENX%
SCREENY%
SCREENW%
SCREENH%
CU_COUNT&
Format
Language
Author
Unused
+ Publisher
Category
Pages
Published Year
Amount
My Price
Current Price
Purch From
Purch Date
State
Location
Lent To
0
Memnoch the Devil
English
+ Anne Rice
Chatto & Windus
Vampyrism, Suspense, Religion
F10$'
0 7011 6320 8
F11%$
F14$'
F15&%
F16$'
Used but not torn
F17$'
Shelf 1
F18$'
Louis
ETYPE$'
Hard Cover
START.
MAINs
DISPLAY_MENU
INITLOCAL
SYSTEM\
SYSRAM1
Thank you for trying this program.
This application, including all related program files
may not be altered in any way. Reverse Translation
is expressly forbidden without written permission of
the author.
Registered users may install the software on an
unlimited number of machines so long as they are
for their own use exclusively.
Although this application is shareware, you are
encouraged to pass the distribution file to your
friends and colleague, registered copies may not
be lent, sold or rented without the express written
permission of the author.
PocketIQ and Pythia Information cannot and does
not accept any liability for loss caused by error,
defect or failure of the software including any loss
of any kind.
No guarantee is either offered or implied by
PocketIQ or Pythia Information. Use of this software
is entirely at your own risk.
If you cannot accept these conditions, please, press