FShopCL is based on a procedure with three basic steps when shopping:
Make a shoplist in the shopping order.
Do the shopping.
Learn from it for the next time.
Theoretically the procedure is:
Preparation
Create a list of items to be bought or activities to be performed.
Execution
Do the actual shopping or perform the activities from the list. It is useful to have the items in the working order.
Evaluation
Retain the experience of the shopping or other activities for future use.
In ShopCL you start in pick mode. You select a shop and let the program create a new (shop)list. You adjust this list by picking items from the picklist, sending back not relevant items to it and creating items that are not yet in the picklist.
Now you change to shop mode. During shopping you move bought items from the shoplist to the donelist.
When you have finished shopping you let the program perform a merge. The donelist and shoplist are reconciliated with the picklist and the shoplist and donelist are cleared. ShopCL keeps track of the number of times an item was not bought or was rejected from the shoplist after beeing presented by a new list action and of the intervals in which an item is bought.
This ended the cycle.
During a next new list action, ShopCL uses the data from the merge actions to produce a list as accurate as possible.
With every new cycle more of your regular items will be presented in the new list.
Season influences and other changes in shopping behaviour will be learned by ShopCL in a few shopping cycles.
BThe edit item has add item, edit item and delete item functions.
Add item works in two stages.
During the first stage the essential fields are entered or selected. At the end of the selection list of 'category' and 'unit' you will find <new>.
For every <new> you select, the dialog for creating a new one will be presented, before the 'new item' dialog resumes. Some other dialoge also have the <new> option.
If 'one time' is ticked the item will be removed during merge.
After OK is pressed the second stage is prepared.
The default values of the category and unit are presented. They can be changed before pressing OK.
Whe you finished adding, editing and deleting press 'ready'.
;AThe shelf is used to determine the route through the shop. That is why you can move the shelves in the route order.
The shelf menu contains 'add', 'update', 'move' and 'delete' dialogs.
The 'add' dialog has two stages.
Stage one for creating a new shelf. Stage two for moving the shelf in the route order position.
AThis menu contains 'pick mode', 'shop mode' and 'view picklist'.
The 'pick mode' and 'shop mode' entries correspond to the top toolbar button.
'Pick mode' is used to prepare shopping. 'Shop mode' is used during shopping and to prepare a merge after shopping.
'View picklist' displays a window with most of the fields in the item record. The list is sorted in the order of the picklist. All items can be made visible by zooming out.
AExport Current List.
This menu option exports the item table records of the current list.
You can move the export file to a PC and for instance import the file into an EXCEL spreadsheet as CSV file. The wizard for delimited files will guide you through the process.
QAExport Database
Use this function to export the full content of the database.
Import in a new document creates the database.
Import into a filled document will merge the imported data with the existing data.
All relevant fields of all tables of the database are exported in the right order to recreate the databade in another document.
Introduction?
ShopCL
Shop Check Listf
an EXCEL spreadsheet as CSV file. The wizard for delimited files will guide you through the process.
HWhen you start ShopCL for the first time, a demo file is loaded.
Use this demo to experiment with the program.
At start-up the program is in Pick mode. The left list is the picklist, which contains all items in the database.
Tap the bottom toolbar button "New list" to produce a shoplist on the right with the items that you most likely want to buy in the current shop.
The "Next shop" button lets you make another shop current.
Select an item in the picklist by tapping the item twice or by moving the cursor to the item with the up and down arrows and pressing the spacebar or enter button. The item moves to the shoplist.
Change the amout of an item by pressing a cypher key or tap the toolbar button "Update item". A dialog pops up.
The item dialog shows the quantity, the unit, the description, the catagory, the shop and the shelf.
A shop contains shelves. Shelves can be moved in the shopping order. The shelf order determines the sort order of the shoplist.
Items are connected to a category, which is used to sort the picklist and to provide the default shelf for new items in the category.
Select items in the shoplist that you do not want to buy and double tap or key them back to the pickist. Now you could print the shoplist.
Tap the top toolbar button to move to shop mode. The shoplist is positioned on the left and the donelist on the right.
Now you are ready for shopping.
Tap or key a bought item to move it to the donelist.
Add items that were not yet in the shop and picklist and update items.
Finally tap the bottom toolbar "merge" button.
If not all items are moved from the shoplist to the donelist, you are asked to choose wether you consider the items, that are still in the shoplist, as bought (choose merge shoplist and donelist) or as not bought (choose merge donelist). The data in the item records in the database are updated with information about the items bought or not bought, rejected from the shoplist or selected from the picklist.
These data will be used when a new shoplist will be produced in Pick mode during the preparation of a new shopping session.
When you do not want to use your Psion in the shop, it is of course possible to print the shopllst and do the (done and) merge process afterwards.
lCThis menu contains standard Psion functions, a Preferences menu entry and a Recover Database menu entry.
Preferences
In the preferences dialog you can alter the delimiter character for import and export. Use a character which the receiving application expects and/or which is not used in the exported text. In case of an import action a different delimiter might be used by the sending application. Default is the ; (semi-colon)
A good alternative is the | (vertical bar, ctrl-124).
Recover Database
When a process has been terminated abnormally, the database might be updated partially. During the Open process, ShopCL checks, if the integrity of the database might be lost.
In a dialogbox you get the choice to recover right away or do it another time. Use the Tools-Recover Database menu entry or the ctrl-r shortcut if you are in doubt of the integrity of the database.
GBThe display is the key to the use of ShopCL.
Most of the program functions apply to the current shop, which is displayed in the window heading, and to the current item, identified by the cursor bar.
Make an item current by using the stylus or the arrow keys. Type a letter to find the next item of which the first letter matches to the typed letter.
Type a cypher to make the update item dialog displayed with the cypher filled in the amount field.
Widen the windows by choosing the View-Show Toolbar menu entry. The toolbar is replaced by a button, which releases a popup menu.
Description$
ShopCL
Shop Check Liste
Display4
ShopCL
Shop Check Liste
Getting Started
ShopCL
Shop Check List- Menu File
The File menu contains the regular file and print items.
Printing is performed on the current list.
Before printing, select the list which you want to print and, in case of a shoplist, select the shop.
The picklist is printed in the current order.
Menu Edit NotesXLike the name suggests the Notes function can be used as a simple jotter with one page.
- Menu View
This menu contains standard Psion functions.
When the toolbar is not visible, a toolbar button will release a popup menu with the same functions as the toolbar itself.
Menu Tools
Menu Edit Item
DIn the wide view the toolbar is represented by a toolbar replacement button. The entries in the popup menu of this button have the same functions as the toobar buttons described below.
Top button:
Toggles between pick mode and shop mode (an alternative to menu-list-mode-pick mode and shop mode)
Second button:
Generates an add item dialog (an alternative to menu-edit-item-add item)
Third button:
Generates an update item dialog (an alternative to menu-edit-item-update item)
Bottom button:
In pick mode
This button starts the function to create a new shoplist based on the items in the picklist.
You can choose either a list for the current shop or lists for all shops.
The New List function uses selection criteria like: was the item bought last time and the time before?, must the item be selected according to the frequency set by the not bought vs. bought period? etc.
When the shoplist is not empty, you are prompted with the statement that the content of this shoplist will be overwritten by the newly generated shoplist, unless you cancel the operation.
Bottom button:
In shop mode
The button performs a merge, i.e. the items in the donelist (and optionally in the shoplist) are transferred to the picklist and the statistics in the picklist are updated.
B Ctrl-n New Database
Ctrl-o Open Existing DB
Shift-Ctrl-s Save Database as
Ctrl-b Import
Ctrl-z Export Database
Shift-Ctrl-z Export Current List
Ctrl-y Export Shop Profile
Ctrl-t ToolBar toggle
Shift-Ctrl-i New Item
Ctrl-i Update Item
Ctrl-f View Pick List
Shift-Ctrl-f View Shelf Table
Shift-Ctrl-l New List
Ctrl-l Merge
Ctrl-r Recover Database
Shift-Ctrl-a About
Ctrl-u Text Editor
Ctrl-m Zoom In
Shift-Ctrl-m Zoom Out
Shift-Ctrl-h Help
Ctrl-k Preferences
Shift-Ctrl-u Page Setup
Shift-Ctrl-p Print Setup
Shift-Ctrl-p Print Preview
Ctrl-p Print
vB* Import (in CSV format)
* Export database and current list (CSV)
* Export and import Shop Profile (CSV)
* Database integrity
* Database recovery
* Merge and New List for all shops
* Preference for delimiter character
* Preference for toolbar or wide view
* Zoom status saved in ini file
* Toolbar replacement button
* Messages with busy indication
* Shortcuts added and documented
* Move Shelf bug fixed
* Input validation
In version 2a:
bug fixes:
* update unit
* delete unit
* recovery error when picklist empty
* automatic detection of tab delimited import
* pick list order saved in ini file
* hot keys added to dialogs
JImport:
Use the import function to import data from a field-delimited file in CSV format or a Tab delimited file. The file can be output from an Excel spreadsheet in the CSV or Tab delimited format, or in any other application, which can create simple text files.
The second use of the import function is to import an exported database. This way you can append the contents of one database to those of another or add a shop profile eported by you or another user.
The format must be:
quantity;unit;item;shop;shelf;category
where
quantity: 1 to 6 cyphers, with or without a decimal point
unit: maximum 10 letters
item: maximum 30 letters
shop: maximum 20 letters
shelf: maximum 30 letters
category: maximum 30 letters
Separated by a separator character.
You can change the seperator character with the Tools-Preferences menu entry. The default is ; (semi-colon)
ShopCL automatically detects if the file is Tab delimited and if so ignores the delimiter character of the preferences menu.
Typically you add items with all above fields filled in. It is important to use the exact field contents as they appear in the database, when you select Update Item from the toolbar or an edit entry in the menu for the corresponding field.
One or more fields in the import record can be empty, but the field separators must be present, except non-significant separators to the right e.g.:
;;;shop;shelf;category
quantity;unit;item
For flexibility reasons one blank entry per type may occur as a result of the import process. This way input records with empty fields can be accepted without error messages.
The ShopCL database consists of the following tables and importable fields:
Shop table
Shop name
Shop/Shelf table
Shop name;
Shelf name
Category table
Category name;
Default Shop name;
Default Shelf name
Unit table
Unit name;
Default quantity
Item table
Quantity;
Unit name;
Item name;
Shop name;
Shelf name;
Category name
The import function checks if a field is present in the database. If not, a record is created in the relevant tables. For fields that should be present in the import record to fill the tables, but in fact are not, a blank field is added to the relevant records in the tables.
The records in the import file are processed in the order in which they are stored in the import file.
Only when the item field in the import record is not empty, an item record is updated or created in the database. Otherwise only the tables for Shop, Shop/Shelf, Unit and Category are updated, according to the not empty fields in the import record. The fields are only imported in a table if the primary field is not already present.
A quantity field in an import record is ignored if the unit field and the item field are empty.
1BThe menu contains 'category order', 'shop order' and 'item order'. ShopCL remembers the last used order.
The order is only valid for the picklist. The shoplist and donelist are sorted in shoporder.
Category order means that the items are sorted in alphabetical order within a category and the categories in alphabetical order.
Shop order means that the items are sorted per shop in the order of the shelves and within a shelf on alphabetical order.
List category means that the items are sorted in alphabetical order, regardless of shop, shelf and category.
:8*.NNN<u
Menu Edit Category
The category menu contains op 'Add', 'Update' and 'Delete'
The 'Add' dialog selection list for default shelf includes a <new> entry
Menu Edit Shop
The Edit Shop menu contains dialogs for 'addm
', 'update' and 'delete'
A shop can only be deleted if no items are allocated to the shop. Transfer all items from the shoplist to the picklist before you perform a delete.
Menu Edit Shelf
Menu Edit Unit
The Unit menu contains 'add', 'update' and 'delete' dialogs.
The default amount is used to fill a new item with an initial value.
Menu List Order*
Menu List Mode#
Toolbar.
% ShortcutsE
Menu File Import/Export 1%
Menu File Import/Export 2-
Menu File Import/Export 3>
New in version 2
Menu File Import/Export 4
Export Shop Profile
The Shop Profile consists of all data associated to a shop, except possible item data.
The export file can be used to import into a database. This way the shop order route, categories and units are availabe for items to allocate to.
Input
It is not allowed to input certain characters. The invalid characters are: * (asterisk), " (double quote) and the character codes ctrl 000 through ctrl 031.
An invalid character in imported data is replaced by a ? (question mark).
Version 2b
ShopCL is a freeware program which primarily assists in structuring your shopping.
You can make shoplists. The program keeps track of your shopping behaviour and presents a list in the order of the shopping route. After a few shopping cycles the presented list reflects your shopping behaviour.
During shopping you can use the PSION to keep track of your purchases.
You can exchange Shop Profiles with other users, if you want to shop in an unfamiliar shop and another user already made the shopping route for this shop.
Besides the primary use, ShopCL can be helpful in creating and using other checklists.
You can make general checklists and derive specific lists from the general list. Like in the generation of shoplists the learning ability of ShopCL will present lists with a high probability of usefulness.
Think of making:
A general checklist with all travel attibutes and specific lists for holidays by car or by plane, trips with the caravan or motorhome, short business trips or long business trips.
A general checklist with project activities and specific lists for specific projects or phases. New activities will be updated in the general list by ShopCL.
Sketch
&Paint.app
B* Import (in CSV and Tab Delimited format)
* Export database and current list (CSV)
* Export and import Shop Profile (CSV)
* Database integrity
* Database recovery
* Merge and New List for all shops
* Preference for delimiter character
* Preference for toolbar or wide view
* Zoom status saved in ini file
* Toolbar replacement button
* Messages with busy indication
* Shortcuts added and documented
* Move Shelf bug fixed
* Input validation
In version 2a:
bug fixes:
* update unit
* delete unit
* recovery error when picklist empty
* automatic detection of tab delimited import
* pick list order saved in ini file
* hot keys added to dialogs
:8*.NNN<u
Menu Edit Category
The category menu contains op 'Add', 'Update' and 'Delete'
The 'Add' dialog selection list for default shelf includes a <new> entry
Menu Edit Shop
The Edit Shop menu contains dialogs for 'add', 'update' and 'delete'
A shop can only be deleted if no items are allocated to the shop. Transfer all items from the shoplist to the picklist before you perform a delete.
Menu Edit Shelf
Menu Edit Unit
The Unit menu contains 'add', 'update' and 'delete' dialogs.
The default amount is used to fill a new item with an initial value.
Menu List Order*
Menu List Mode#
Toolbar.
% ShortcutsE
Menu File Import/Export 1%
Menu File Import/Export 2-
Menu File Import/Export 3>
New in version 2=
Menu File Import/Export 4
Export Shop Profile
The Shop Profile consists of all data associated to a shop, except possible item data.
The export file can be used to import into a database. This way the shop order route, categories and units are availabe for items to allocate to.
Input
It is not allowed to input certain characters. The invalid characters are: * (asterisk), " (double quote) and the character codes ctrl 000 through ctrl 031.
An invalid character in imported data is replaced by a ? (question mark).
~B* Import (CSV and Tab Delimited)
* Export database and current list (CSV)
* Export and import Shop Profile (CSV)
* Database integrity
* Database recovery
* Merge and New List for all shops
* Preference for delimiter character
* Preference for toolbar or wide view
* Zoom status saved in ini file
* Toolbar replacement button
* Messages with busy indication
* Shortcuts added and documented
* Move Shelf bug fixed
* Input validation
In version 2a:
bug fixes:
* update unit
* delete unit
* recovery error when picklist empty
* automatic detection of tab delimited import
* pick list order saved in ini file
* hot keys added to dialogs
:8*.NNN<u
Menu Edit Category
The category menu contains op 'Add', 'Update' and 'Delete'
The 'Add' dialog selection list for default shelf includes a <new> entry
Menu Edit Shop
The Edit Shop menu contains dialogs for 'add', 'update' and 'delete'
A shop can only be deleted if no items are allocated to the shop. Transfer all items from the shoplist to the picklist before you perform a delete.
Menu Edit Shelf
Menu Edit Unit
The Unit menu contains 'add', 'update' and 'delete' dialogs.
The default amount is used to fill a new item with an initial value.
Menu List Order*
Menu List Mode#
Toolbar.
% ShortcutsE
Menu File Import/Export 1%
Menu File Import/Export 2-
Menu File Import/Export 3>
New in version 2
Menu File Import/Export 4
Export Shop Profile
The Shop Profile consists of all data associated to a shop, except possible item data.
The export file can be used to import into a database. This way the shop order route, categories and units are availabe for items to allocate to.
Input
It is not allowed to input certain characters. The invalid characters are: * (asterisk), " (double quote) and the character codes ctrl 000 through ctrl 031.
An invalid character in imported data is replaced by a ? (question mark).
c:\System\Apps\ShopCL\ShopCL
VWINLINK
VWin.opoO
OZ4[>
:\System\OPL\VWin.opoK
TBstartO
TBARLINK
Z:\SYSTEM\OPL\TOOLBAR.OPO
mainO
GINFO&
CURRENTDOC$
SAVEASPATH$
DATABASEPATH$
TOOLBAR%
TOOLBARPREF%
CONTROL%
SHIFT%
SCREENWIDTH%
FALSE
THREE&
FOUR&
MINIT%
MAINSCN%
SCREEN2%
BUFFER&
TEXTSTRING$
ICON$
PATH$
DATA$
LASTUSED$
THREAD&
PROGRAM$
VERSION$
PROGTOBEOPENED$
FILE$
MERGEBITM&
MERGEMASKBITM&
NEWITEMBITM&
NEWITEMMASKBITM&
NEWLISTBITM&
NEWLISTMASKBITM&
TOPICKMODEBITM&
TOPICKMODEMASKBITM&
TOSHOPMODEBITM&
TOSHOPMODEMASKBITM&
UPDATEITEMBITM&
UPDATEITEMMASKBITM&
NEWLISTORMERGEBITM&
NEWLISTORMERGEMASKBITM&
MODEBITM&
MODEMASKBITM&
SCROLLSCN%
UPID&
DOWNID&
SLIDERID&
FINDID&
SCROLLPOS%
SCREENHEIGHT%
SCROLLXPOS%
SCROLLYPOS%
SCROLLWIDTH%
SCROLLHEIGHT%
MODE%
MODEBUTTON$
SORT%
NEWLISTORMERGEBUTTON$
CAPTION$
CAPTIONSCN%
LISTWIN%
SHELFN$
CURSHELFN$
SHELFPO&
CATN$
ITEMN
ITEMPO
APPER%
UNITAB$
QUANTP
QUANTS
QUANTD
PSTATUS$
DEFQUANT
LBDAY%
LBMONTH%
LBYEAR%
SHLID$
SHOPCHOICEBM%
SHELFBM%
SHOPBMEXISTS%
SHELFBMEXISTS%
FROMSHELFBMEXISTS%
AFTERSHELFBMEXISTS%
LASTUSEDSEARCHKEY&
SEARCHBM%
RECNR&
SHOPENTERED$
SHOPCHOICE%
SHOPINDEX$
SHOPKEY&
OLDSHOPNAME$
SHOPNAME1$
NOSHOPS%
DIALOGRETURN%
SHOPCOUNT%
SHELFCOUNT%
SHELFENTERED$
SHELFCHOICE%
SHELFINDEX$
T! SHELFKEY&
SHELFNAME1$
SHELFNAME2$
" NOSHELFS%
SHELFSHOP$
CHOSENSHOP$
CHOSENSHELF$
TEMPSHELFKEY&
RECNR%
SHOPBUFFER$
SHELFBUFFER$
SHOP$
SHOPCANCELLED%
SHOPNAMEIA$
SHELF%
VALIDSHELF%
SHELFNR%
NOSHELF%
FROMSHELFN$
AFTERSHELFN$
FROMSHELFPO&
AFTERSHELFPO&
FROMSHELFBM%
AFTERSHELFBM%
LOWPO&
HIGHPO&
UNITCOUNT%
UNITNAME1$
UNITCHOICE%
UNITBM%
UNITENTERED$
UNITNAME1OLD$
DEFQUANTENTERED
UNITAB$
UNITKEY&
CHOSENUNIT$
UNITCANCELLED%
CATEGORYCOUNT%
CATEGORYNAME1$
CATEGORYOLDNAME$
CATEGORYENTERED$
CATEGORYCHOICE%
CATEGORYBM%
CATEGORYKEY&
NOCATEGORYINSERTED%
DEFSHELFN$
DEFSHN$
DEFAPP&
APPENTERED&
ITEMKEY&
ITEMPICKKEY&
NOITEMINSERTED%
ITEMCOUNT%
ITEMNAME1$
ITEMCHOICE%
ITEMBM%
IITEMN$
IQUANTP
IUNITAB$
ICATN$
ISHN$
ISHELFN$
IAPPER%
% ISHELFPO&
UNITABBREV$
ITEMN$
CATN$
SHELFN$
ITEMPO&
PSTATUS$
CATEGORYCANCELLED%
ITEMENTERED$
QUANTENTERED
SHOPSHELFCOUNT%
SHOPSHELFCHOICE%
SHOPSHELF$
ISHOPN$
& APPERIOD&
LSCN%
& LISTNAME$
LISTVW&
LISTSCN%
FONT&
FONT%
Q' FILESIZE&
PICKBM%
PSTATUS%
RECKEY$
CURRENTLIST%
OLDCURRENTLIST%
CURSH$
CURSHBM%
CURRENTITEM&
CURSORPOSITION&
BTNNEXTSHOP&
BTNPREVSHOP&
SHOPBUTTONBAR%
MERGESTATUS%
VIANEWLIST%
ONETIME%
ONETIMEOLD%
DELETEKEY%
UPDATEITEMBUTTON%
NEWITEMBUTTON%
TERMINATEDIALOG%
EDITEDSHOP$
ITEMDIALOGCANCELLED%
VIAINSERTITEM%
TOOLBARBUTTON%
BTNTOOLBAR&
ORDER%
UPDATEITEMNUMBERKEY%
FIRSTQUANTDIGIT%
NUMBEROFWINLINES%
STARTINDEXPICK%
WINLINEBMPICK%
VWINLINEPOSPICK&
STARTINDEXSHOP%
WINLINEBMSHOP%
VWINLINEPOSSHOP&
STARTINDEXDONE%
WINLINEBMDONE%
VWINLINEPOSDONE&
VLBLFIRST&
VLBLLENGTH&
VLISTLENGTHORORDERCHANGED%
+ CBLFIRST&
CBLLENGTH&
CBLCICLESTARTPOS%
CIRCLEVLINENR&
CIRCLEVLINEBM%
CIRCLESTARTPOS%
PRBLENGTH%
PRBQUANTP$
PRBUNITAB$
2 PRBITEMN$
PRBSHN$
PRBPSTATUS%
SWIN%
SPOS%
SRIGHT%
SHOPCLLOGO&
SHOPCLLOGOPATH$
FIRSTTIMEINITWIN%
PLVW&
PLSCN%
SLVW&
SLSCN%
RECOVERED%
TABLETYPE%
OPENCANCELLED%
CREATECANCELLED%
ERRCODE%
.? TEMPFILE$
SHELFTEMPKEY&
SHELFTMPPO&
SHELFNTMP$
SHNTMP$
COMPACTCOUNT%
FIELDDELIMITER$
RECDELIMITER$
TEXTMARKING$
IMPORTWIN%
ADDRESS&
FNAME$
BUFFER$
CHOSENCATEGORY$
HANDLE%
C FILEMODE%
C STARTPOS%
ENDPOS%
C DELIMPOS%
LAST%
C FILENAME$
RESERVEDCHAR$
NUMBERRESERVEDCHARS%
COMPACTPARAMETER%
D TESTMODE%
EVENT
CREATEPRINTPICKLISTWINDOW
OPENTABLE
CREATEPRINTSHELFLISTWINDOW
ERROR_HANDLER
Shop Check List
SHOPCLSPLASH
LOAD_INI_FILE
SETUP_TOOLBAR
DEVICE
CHANGENEWLISTORMERGEBUTTON
INIT_BUTTONBAR
ERROR_HANDLER
TESTMODE%
FALSE
FIRSTTIMEINITWIN%
CURSH$
ORDER%
SCROLLPOS%
COMPACTCOUNT%
FIELDDELIMITER$
RECDELIMITER$
TEXTMARKING$
SCREENHEIGHT%
PATH$
DATA$
DATABASEPATH$
SHOPCHOICE%
VLISTLENGTHORORDERCHANGED%
ICON$
MERGEBITM&
MERGEMASKBITM&
NEWITEMBITM&
NEWITEMMASKBITM&
NEWLISTBITM&
NEWLISTMASKBITM&
TOPICKMODEBITM&
TOPICKMODEMASKBITM&
TOSHOPMODEBITM&
TOSHOPMODEMASKBITM&
UPDATEITEMBITM&
UPDATEITEMMASKBITM&
MODE%
CURRENTLIST%
SORT%
LISTNAME$
MODEBUTTON$
MODEBITM&
MODEMASKBITM&
ITEMDIALOGCANCELLED%
SWIN%
PROGRAM$
\System\Apps\ShopCL\
C:\System\Apps\ShopCL\
ShopCL.mbmK
MBM file not foundW8
ModeK
Freeware
MOVENOTINACTION
MOVEINACTION
OPENTABLE
IMPORTISVALID$
COMPACTCHECK
CONVERTTOWHERE$
PICKMODE
ERROR_HANDLER
TESTMODE%
FALSE
DIALOGRETURN%
COMPACTCOUNT%
FILE$
SHELFTEMPKEY&
SHELFPO&
SHELFN$
UNITAB$
PROGRAM$
Database Recovery
The database might be corruptedO
Start recovery now?O
Database Recovery
+7You can start the recovery process with Ctrl-r anytime.O
+#Do you want ShopCL to reminded you?O
Recover database, Pass 0.1,
SHN$#
SHN$'
SHN$#
SHN$#
SHN$'
Recover database, Pass 0.2,
SHN$#
SHN$'
SHN$#
SHN$#
SHN$'
SHELFN$#
SHELFN$'
SHELFN$#
SHELFN$#
SHELFN$'
Recover database, Pass 0.3,
SHN$#
SHN$'
SHN$#
SHN$#
SHN$'
SHELFN$#
SHELFN$'
SHELFN$#
SHELFN$#
SHELFN$'
CATN$#
CATN$'
CATN$#
CATN$#
CATN$'
Recover database, Pass 0.4,
UNITAB$#
UNITAB$'
UNITAB$#
UNITAB$#
UNITAB$'
Recover database, Pass 0.5,
ITEMN$#
ITEMN$'
ITEMN$#
ITEMN$#
ITEMN$'
SHN$#
SHN$'
SHN$#
SHN$#
SHN$'
SHELFN$#
SHELFN$'
SHELFN$#
SHELFN$#
SHELFN$'
CATN$#
CATN$'
CATN$#
CATN$#
CATN$'
UNITAB$#
UNITAB$'
UNITAB$#
UNITAB$#
UNITAB$'
+ ShelfTemp
K+:" Fields Shopname(30), Shelfname(30), ShelfPO TO ShelfTempK
SHELFN$
SHELFPO&
Shopname_
+ Shelfname_
ShelfTempIndex
+ ShelfTemp
SHN$#
SHN$#
SHN$#
SHELFN$#
SHN$'
SHELFN$'
SHELFPO&%
Recover database, Pass 1,
SHN$#
SHELFN$#
SHELFPO&!
SHN$#
SHN$#
SHELFPO&%
+#Tempshelf not present in shelftableW8
+"Tempshop not present in shelftableW8
Recover database, Pass 2,
SHN$#
SHELFN$#
SHN$#
SHN$#
SHELFPO&!
SHN$#
SHELFN$#
SHN$'
SHELFN$'
SHELFPO&%
SHN$'
SHN$#
SHELFN$'
SHELFN$#
SHELFPO&%
Recover database, Pass 3,
SHN$#
SHELFN$#
SHN$#
SHN$#
SHELFPO&!
SHN$#
SHELFN$#
SHN$'
SHELFN$'
SHELFPO&%
SHN$'
SHN$#
SHELFN$'
SHELFN$#
SHELFPO&%
Recover database, Pass 4,
SHN$#
SHELFN$#
SHN$#
SHN$#
SHELFPO&!
ERROR Shop: +
SHN$#
is present in shelf table,K+
but shelf: +
SHELF$#
is not, Retart ShopCLKW8
SHELFPO&%
Recover database, Pass 5,
SHN$#
SHN$#
SHN$#
SHN$'
Recover database, Pass 6,
UNITAB$#
UNITAB$#
UNITAB$'
+ ShelfTemp
Database recoveredW8
MAKECURRENTSHOPBOOKMARK
CREATEVLISTWINDOW
CREATESHOPBUTTONS
CREATETOOLBARBUTTON
PICKMODE
ERROR_HANDLER
TESTMODE%
FALSE
FILE$
FIRSTTIMEINITWIN%
SWIN%
PROGRAM$
CREATE
OPENFILE
OPENTABLE
MAKECURRENTSHOPBOOKMARK
RESUMEFILE
ERROR_HANDLER
TESTMODE%
FALSE
FILE$
LASTUSED$
CURSH$
PROGRAM$
SHN$#
SHN$#
SHN$#
ERROR_HANDLER
OPENTABLE
RECOVERPO
TESTMODE%
FALSE
FILE$
PROGRAM$
COMPACTCOUNT%
SWIN%
K+," Fields Header(128), MoveInAction TO HeaderK
HEADER$
MOVEINACTION%
O h@[
MOVEINACTION%$
MOVEINACTION%
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
COMPACTCOUNT%
PROGRAM$
MOVEINACTION%$
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
COMPACTCOUNT%
PROGRAM$
MOVEINACTION%$
TBARBUTT
ERROR_HANDLER
TESTMODE%
FALSE
MODEBUTTON$
MODEBITM&
MODEMASKBITM&
NEWITEMBITM&
NEWITEMMASKBITM&
UPDATEITEMBITM&
UPDATEITEMMASKBITM&
NEWLISTORMERGEBUTTON$
NEWLISTORMERGEBITM&
NEWLISTORMERGEMASKBITM&
PROGRAM$
ItemKO
UpdateO
ItemKO
TBARINIT
TBARHIDE
TBARSHOW
ERROR_HANDLER
TESTMODE%
FALSE
TOOLBAR%
SCREENWIDTH%
PROGRAM$
ShopCLO
TBARHIDE
TBARSHOW
VWDESTROY
CREATEVLISTWINDOW
CREATEPRINTPICKLISTWINDOW
CREATEPRINTSHELFLISTWINDOW
PICKMODE
SHOPMODE
ERROR_HANDLER
TESTMODE%
FALSE
TOOLBAR%
SCREENWIDTH%
SHOPBUTTONBAR%
LSCN%
PLSCN%
SLSCN%
MODE%
PROGRAM$
Toggle Toolbar in progressO
TBARSETTITLE
ERROR_HANDLER
TESTMODE%
FALSE
TOOLBAR%
MINIT%
CONTROL%
PROGRAM$
Printing+
Page setup
Print setup
Print preview
Print
Import/Export+
Import
Export database
Export current list
Export Shop Profile
File+
Create new database
Open existing database
Save database as
Import/Export>O
h+ Printing>O
CloseOe
Edit+
NotesOuh+
+ Category
Shelf
Mode+ Pick ModeO
+ Shop ModeO
Order+
Category OrderO
Shop OrderO
Item OrderO
List+
Mode>O
Order>O
View+
Zoom inOm+
Zoom outOMh+
Hide toolbarOt
View+
Zoom inOm+
Zoom outOMh+
Show toolbarOt
Tools+
PreferencesOk+
Recover DatabaseOrh+
AboutOA+
HelpOH
W:O`L{
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
CURSH$
CURSHBM%
SHOPCHOICEBM%
PROGRAM$
SHN$#
SHN$#
OPENTABLE
WINTITLE
WINBORDER
ERROR_HANDLER
TESTMODE%
FALSE
CURSHBM%
CURSH$
ORDER%
LSCN%
CURRENTLIST%
PROGRAM$
SHN$#
Pick List (Category Order)O
Pick List (Shop Order)O
Pick List (Item Order)O
+ Done ListO
DETERMINEFILESIZE
DRAWBORDER
VWCREATE&
WINGETBORDER%
WINGETTOPBORDER%
VWSETFLAGS
VWPENCALLBACK
VWSETEXTENT
ERROR_HANDLER
TESTMODE%
FALSE
LSCN%
CURSH$
SCREENWIDTH%
SCREENHEIGHT%
FONT&
FONT%
GINFO&
FILESIZE&
PROGRAM$
ListCallbackO
PenCallBackO
DETERMINEFILESIZE
WINTITLE
WINBORDER
VWCREATE&
WINGETBORDER%
WINGETTOPBORDER%
VWSETFLAGS
VWSETEXTENT
ERROR_HANDLER
TESTMODE%
FALSE
CURSH$
PLSCN%
SCREENWIDTH%
SCREENHEIGHT%
PLVW&
FONT&
FONT%
GINFO&
FILESIZE&
PROGRAM$
Pick List printO
PrintListCallbackO
DETERMINEFILESIZE
WINTITLE
WINBORDER
VWCREATE&
WINGETBORDER%
WINGETTOPBORDER%
VWSETFLAGS
VWSETEXTENT
ERROR_HANDLER
TESTMODE%
FALSE
CURSH$
SLSCN%
SCREENWIDTH%
SCREENHEIGHT%
SLVW&
FONT&
FONT%
GINFO&
FILESIZE&
PROGRAM$
Shelf List printO
PrintShelfListCallbackO
BTNCREATE&
ERROR_HANDLER
TESTMODE%
FALSE
SHOPBUTTONBAR%
FONT&
BTNNEXTSHOP&
PROGRAM$
+ Next ShopO
NextShopCallBackO
BTNCREATE&
ERROR_HANDLER
TESTMODE%
FALSE
TOOLBARBUTTON%
FONT&
BTNTOOLBAR&
PROGRAM$
ToolBarCallBackO
INPUTISVALID
ALERTINVALIDCHAR
TOOLSWITCH
SAVE_INI_FILE
ERROR_HANDLER
TESTMODE%
FALSE
TOOLBARPREF%
FIELDDELIMITER$
DIALOGRETURN%
TOOLBAR%
PROGRAM$
Preferences
Import/Export Field Delimiter:O
Show Toolbar:
CancelO
ERROR_HANDLER
TESTMODE%
FALSE
DATA$
LASTUSED$
TEXTSTRING$
CURSH$
FONT%
FIELDDELIMITER$
TOOLBAR%
TOOLBARPREF%
ORDER%
PROGRAM$
ShopCL.iniKW
ShopCL.iniK
ERROR_HANDLER
TESTMODE%
FALSE
DATA$
LASTUSED$
TEXTSTRING$
CURSH$
FONT%
FIELDDELIMITER$
TOOLBARPREF%
ORDER%
PROGRAM$
ShopCL.iniK
ShopCL.iniK
EVENT
BACKGROUND
FOREGROUND
PROCESS
ERROR_HANDLER
TESTMODE%
FALSE
SHIFT%
CONTROL%
PROGRAM$
VWINOFFER%
TBAROFFER%
ZOOMIN
ZOOMOUT
PAGEDOWN
PAGEUP
CURSORDOWN
CURSORUP
CURSORRIGHTLEFT
DISPLAY_MENU
ACTION_KEY
ERROR_HANDLER
TESTMODE%
FALSE
SLSCN%
PLSCN%
SHIFT%
CONTROL%
PROGRAM$
@B`[
'{A[(
Cut/Copy/Paste not implemented
'{A["
InfraRed not implemented
'{A`[
PRINTKEY
NEWFILE
OPEN_EXISTING_FILE
SAVE_DOCUMENT_AS
IMPORT
EXPORTDOCUMENT
EXPORTCURRENTLIST
EXPORTSHOPPROFILE
TOOLSWITCH
EDITITEM
VIEWPICKLIST
VIEWSHELFLIST
NEWLIST
MERGE
RECOVERPO
PREFERENCES
ABOUT
TEXTEDITOR
ZOOMIN
ZOOMOUT
EDITCATEGORY
EDITSHOP
EDITSHELF
EDITUNIT
PICKMODE
SHOPMODE
CATEGORYORDER
SHOPORDER
ITEMORDER
SELECTDESELECT
OPENLISTTABLE
MAKEITEMRECCURRENT
VWREDRAWALL
VWMOVETO
CURSORRIGHTLEFT
ERROR_HANDLER
TESTMODE%
FALSE
NEWITEMBUTTON%
UPDATEITEMBUTTON%
CONTROL%
SHIFT%
UPDATEITEMNUMBERKEY%
FIRSTQUANTDIGIT%
CURRENTLIST%
LASTUSEDSEARCHKEY&
VLISTLENGTHORORDERCHANGED%
CURSORPOSITION&
RECNR&
DELETEKEY%
PROGRAM$
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[
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[
Shift+
O/{9
O:{1\[
O0{Mx
O`{9
O{{1\[
not foundK
O {A[
O {A[
O`{9[
PRINT
ERROR_HANDLER
TESTMODE%
FALSE
PROGRAM$
O`L{A[
O`L{A[
O`L{A[
O`L{A[
+&Problem with printer or communication.W8
VWSETEXTENT
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
FONT%
LSCN%
FONT&
GINFO&
FILESIZE&
PLSCN%
PLVW&
SLSCN%
SLVW&
PROGRAM$
Zoom in progressO
VWSETEXTENT
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
FONT%
LSCN%
FONT&
GINFO&
FILESIZE&
PLSCN%
PLVW&
SLSCN%
SLVW&
PROGRAM$
Zoom in progressO
VWSETEXTENT
OPENLISTTABLE
FILLPRINTLINESOFVLBLOCK
DRAWBORDER
ERROR_HANDLER
TESTMODE%
FALSE
GINFO&
LSCN%
FILESIZE&
PRBLENGTH%
PRBPSTATUS%
MODE%
PRBSHN$
CURSH$
CURRENTLIST%
CURSORPOSITION&
VWPX%
VWPY%
VWTOP&
PRBQUANTP$
VWDRAWWIDTH%
PRBUNITAB$
PRBITEMN$
PROGRAM$
@`\[#
{9\ h
VWSETEXTENT
OPENLISTTABLE
DRAWBORDER
ERROR_HANDLER
TESTMODE%
FALSE
GINFO&
FILESIZE&
VWTOP&
VWPX%
VWPY%
VWDRAWWIDTH%
PROGRAM$
QUANTP"
UNITAB$#
UNITAB$#
ITEMN$#
ITEMN$#
CATN$#
CATN$#
SHN$#
SHN$#
SHELFN$#
SHELFN$#
SHELFPO&!
QUANTP"
UNITAB$#
UNITAB$#
ITEMN$#
ITEMN$#
CATN$#
CATN$#
SHN$#
SHN$#
SHELFN$#
SHELFN$#
OPENTABLE
VWSETEXTENT
DRAWBORDER
ERROR_HANDLER
TESTMODE%
FALSE
GINFO&
FILESIZE&
VWTOP&
VWPX%
VWPY%
VWDRAWWIDTH%
PROGRAM$
SHN$#
SHN$#
SHELFN$#
SHELFN$#
SHELFPO&!
SHN$#
SHN$#
SHELFN$#
SHELFN$#
MAKELISTCURRENT
VWREDRAWALL
SELECTDESELECT
DRAWBORDER
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
FILESIZE&
CURSORPOSITION&
MODE%
LSCN%
PROGRAM$
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
SCREENWIDTH%
PROGRAM$
ShopmodeO
New ItemOI+
Update ItemOi+
New ListOl+
Show ToolbarOtWX
PickmodeO
New ItemOI+
Update ItemOi+
MergeOL+
Show ToolbarOtWX
OPENTABLE
DETERMINEFILESIZE
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCOUNT%
SHOPNAME1$
CURSH$
SHOPCHOICE%
DIALOGRETURN%
SHOPCHOICEBM%
CURSHBM%
CURSORPOSITION&
VLISTLENGTHORORDERCHANGED%
MODE%
PROGRAM$
+ Edit Shop
SHN$#
SHN$#
Select Shop:
Select Shop:
,...K
,...K
CancelO
ReadyO
Change shop in progressO
SHN$#
OPENTABLE
DETERMINEFILESIZE
VWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
CURSHBM%
CURSH$
CURSORPOSITION&
VLISTLENGTHORORDERCHANGED%
PROGRAM$
SHN$#
SHN$#
FILLPRINTBUFFER
ERROR_HANDLER
TESTMODE%
FALSE
PRBLENGTH%
CIRCLEVLINEBM%
VLISTLENGTHORORDERCHANGED%
CIRCLESTARTPOS%
CIRCLEVLINENR&
PROGRAM$
{MM1[
HO(<[
{MM9[
ERROR_HANDLER
TESTMODE%
FALSE
PRBLENGTH%
PRBPSTATUS%
PRBQUANTP$
PRBUNITAB$
PRBITEMN$
PRBSHN$
PROGRAM$
PSTATUS%
QUANTP"
UNITAB$#
ITEMN$#
SHN$#
OPENLISTTABLE
MAKEITEMRECCURRENT
OPENTABLE
FINDCHOSENSHELF
UPDATECIRCLE
DUPLICATECURRENTITEM
VWREDRAWALL
VWMOVETO
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
CURRENTLIST%
CURSORPOSITION&
CURSH$
CHOSENSHOP$
SHELFCOUNT%
SHELFNAME1$
SHELFPO&
SHELFCHOICE%
DIALOGRETURN%
SHELFBM%
COMPACTCOUNT%
FILESIZE&
RECKEY$
PROGRAM$
PSTATUS%
SHN$#
Choose Shelf
The item was assigned to shop: +
SHN$#
+#Choose or create a shelf for shop:
SHELFN$#
SHELFPO&!
Select Shelf:
Select Shelf:
,...K
,...K
CancelO
ReadyO
PSTATUS%$
SHN$'
SHELFN$'
SHELFN$#
SHELFPO&%
SHELFPO&!
PSTATUS%$
ITEMN$#
SHN$#
New Item
The item is in use by shop: +
SHN$#
+ Do you want to create duplicate?O
CancelO
PSTATUS%
PSTATUS%$
{M9[,
PSTATUS%
PSTATUS%$
ITEMN$#
PSTATUS%
PSTATUS%$
ERROR_HANDLER
TESTMODE%
FALSE
CIRCLEVLINENR&
CIRCLEVLINEBM%
PROGRAM$
O(0[:
O(0[i
ERROR_HANDLER
TESTMODE%
FALSE
RECNR%
PROGRAM$
+6Database exceeded the maximum number of records (32767W8
SHOPMODE
PICKMODE
MODE%
EDITITEM
NEWITEMBUTTON%
EDITITEM
UPDATEITEMBUTTON%
NEWLIST
MERGE
MODE%
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
NEWLISTORMERGEBUTTON$
NEWLISTORMERGEBITM&
NEWLISTBITM&
NEWLISTORMERGEMASKBITM&
NEWLISTMASKBITM&
MERGEBITM&
MERGEMASKBITM&
PROGRAM$
ListK
Merge
OPENTABLE
NEWLISTOFSHOP
COMPACTCHECK
DETERMINEFILESIZE
PICKMODE
ERROR_HANDLER
TESTMODE%
FALSE
DIALOGRETURN%
CURSH$
VLISTLENGTHORORDERCHANGED%
VIANEWLIST%
PROGRAM$
New List
+8New List for the current shop or New Lists for all shopsO
CurrentO
New List of
in progressKO
SHN$#
New List of
in progressKO
New List of
in progressKO
DETERMINEFILESIZE
MERGESHOP
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
FILESIZE&
VIANEWLIST%
CHOSENSHOP$
COMPACTCOUNT%
PROGRAM$
+!Shop list and Done list of shop:
not emptyK+$Shoplist ignored and Merge performed+
Cancel+
ContinueW8
{A\[n
Done list of shop:
not emptyK+
Merge performed+
Cancel+
ContinueW8
{9\[t
Shop listof shop:
not emptyK+%Current Shop list will be overwritten+
Cancel+
ContinueW8
|NB`[
PSTATUS%$
OPENTABLE
MERGESHOP
DETERMINEFILESIZE
PICKMODE
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
DIALOGRETURN%
CURSH$
VIANEWLIST%
VLISTLENGTHORORDERCHANGED%
PROGRAM$
Merge
+5Merge the current shop list or the lists of all shopsO
CurrentO
+ Merge of
in progressKO
+ Merge of +
SHN$#
in progressKO
SHN$#
+ Merge of
in progressKO
DETERMINEFILESIZE
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
FILESIZE&
MERGESTATUS%
CHOSENSHOP$
COMPACTCOUNT%
PROGRAM$
Shop list:
not emptyK+5Cancel, Merge Donelist or Merge Shoplist and Donelist+
Cancel+
Merge Sl+Dl+
Merge DlW8
APPER%
PSTATUS%
PSTATUS%
PSTATUS%$
VWGETVARS
VWSETVIEW
VWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
VWTOP&
VWVIEWEXTENTY&
FILESIZE&
CURSORPOSITION&
PROGRAM$
VWGETVARS
VWSETVIEW
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
VWTOP&
VWVIEWEXTENTY&
CURSORPOSITION&
PROGRAM$
VWGETVARS
VWSETVIEW
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
CURSORPOSITION&
FILESIZE&
VWVIEWEXTENTY&
PROGRAM$
VWGETVARS
VWSETVIEW
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
CURSORPOSITION&
PROGRAM$
VWREDRAW
VWMOVETO
ERROR_HANDLER
TESTMODE%
FALSE
CURSORPOSITION&
CURRENTLIST%
FILESIZE&
PROGRAM$
{M1[T
VWREDRAW
VWMOVETO
ERROR_HANDLER
TESTMODE%
FALSE
CURSORPOSITION&
CURRENTLIST%
PROGRAM$
MAKELISTCURRENT
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
CURRENTLIST%
PROGRAM$
DRAWBORDER
ERROR_HANDLER
TESTMODE%
FALSE
OLDCURRENTLIST%
CURRENTLIST%
LSCN%
PROGRAM$
CHANGENEWLISTORMERGEBUTTON
INIT_BUTTONBAR
DETERMINEFILESIZE
MAKELISTCURRENT
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
MODEBUTTON$
LISTNAME$
MODEBITM&
TOSHOPMODEBITM&
MODEMASKBITM&
TOSHOPMODEMASKBITM&
SHOPBUTTONBAR%
TOOLBARBUTTON%
LSCN%
VLISTLENGTHORORDERCHANGED%
CURSH$
SCREENWIDTH%
SCREENHEIGHT%
TOOLBAR%
PROGRAM$
Change to pickmode in progressO
ModeK
CHANGENEWLISTORMERGEBUTTON
INIT_BUTTONBAR
DETERMINEFILESIZE
MAKELISTCURRENT
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
MODE%
MODEBUTTON$
LISTNAME$
MODEBITM&
TOPICKMODEBITM&
MODEMASKBITM&
TOPICKMODEMASKBITM&
SHOPBUTTONBAR%
TOOLBARBUTTON%
LSCN%
VLISTLENGTHORORDERCHANGED%
CURSH$
SCREENWIDTH%
SCREENHEIGHT%
TOOLBAR%
PROGRAM$
Change to shopmode in progressO
ModeK
TOFLO
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
PLSCN%
PLVW&
PROGRAM$
VWSETVIEWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
SLSCN%
SLVW&
PROGRAM$
VWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
ORDER%
VLISTLENGTHORORDERCHANGED%
PROGRAM$
VWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
ORDER%
VLISTLENGTHORORDERCHANGED%
PROGRAM$
VWREDRAWALL
ERROR_HANDLER
TESTMODE%
FALSE
ORDER%
VLISTLENGTHORORDERCHANGED%
PROGRAM$
OPENLISTTABLE
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
FILESIZE&
CHOSENSHOP$
PROGRAM$
+6Database exceeded the maximum number of records (32767W8
OPENLISTTABLE
INSERTITEM
UPDATEITEM
DELETEITEM
DETERMINEFILESIZE
VWREDRAWALL
COMPACTCHECK
VWMOVETO
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
NEWITEMBUTTON%
DIALOGRETURN%
TERMINATEDIALOG%
UPDATEITEMBUTTON%
NOITEMINSERTED%
ITEMCHOICE%
CURSORPOSITION&
DELETEKEY%
ITEMDIALOGCANCELLED%
VIAINSERTITEM%
UPDATEITEMNUMBERKEY%
ITEMCOUNT%
ITEMNAME1$
ITEMBM%
VLISTLENGTHORORDERCHANGED%
CURSH$
MODE%
FILE$
PROGRAM$
+ Edit Item
The list is emptyO
+%Add a new Item or select another listO
CancelO
Add ItemOa
Oa@[8
+ Edit Item
ITEMN$#
Select Item:
Select Item:
,...K
,...K
Add ItemOa+
Update ItemOe+
Delete ItemOd+
ReadyO
Oa@[&
New item in progressO
Oe@[)
Update item in progressO
Od@[,
Delete item in progressO
COMPACTCOUNT%
COMPACTPARAMETER%
FILE$
Compact DatabaseO
FALSE
NUMBERRESERVEDCHARS%
RESERVEDCHAR$
+%The field contains invalid characters+ Try againW8
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
INSERTUNIT
INSERTCATEGORY
MOVEINACTION
OPENLISTTABLE
MOVENOTINACTION
UPDATEITEM
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
ITEMDIALOGCANCELLED%
UNITBM%
NOITEMINSERTED%
ITEMENTERED$
UNITCOUNT%
UNITABBREV$
DEFQUANT
UNITCHOICE%
CATEGORYCOUNT%
CATEGORYNAME1$
CATEGORYCHOICE%
ONETIME%
DIALOGRETURN%
IUNITAB$
IQUANTP
CATEGORYBM%
ICATN$
ISHN$
CURSH$
ISHELFN$
CHOSENSHOP$
CHOSENSHELF$
ISHELFPO&
CURRENTLIST%
COMPACTCOUNT%
ITEMBM%
VIAINSERTITEM%
PROGRAM$
+.Error: No Category present when inserting item+
Please Inform the programmerW8
+*Error: No unit present when inserting item+
Please Inform the programmerW8
New Item
Item name:O
UNITAB$#
DEFQUANT"
Default Unit:
,...K
<New Unit>
,...K
<New Unit>
Unit:
,...K
,...K
CATN$#
+ Category:
,...K
<New Category>
,...K
<New Category>
+ Category:
,...K
,...K
One time item
CancelO
UNITAB$#
DEFQUANT"
CATN$#
SHN$#
SHN$#
SHELFN$#
SHELFN$#
SHELFPO&!
ITEMN$'
QUANTP&
UNITAB$'
CATN$'
SHN$'
SHELFN$'
PSTATUS%$
APPER%$
APPER%$
SHELFPO&%
OPENLISTTABLE
OPENTABLE
DELETEITEM
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
UPDATEITEMNUMBERKEY%
ITEMBM%
IITEMN$
IQUANTP
FIRSTQUANTDIGIT%
IUNITAB$
ICATN$
ISHN$
ISHELFN$
IAPPER%
PSTATUS%
UNITCOUNT%
UNITABBREV$
UNITCHOICE%
CATEGORYCOUNT%
CATEGORYNAME1$
CATEGORYCHOICE%
MODE%
CHOSENSHOP$
SHOPSHELFCOUNT%
SHOPSHELF$
SHOPSHELFCHOICE%
ONETIME%
ONETIMEOLD%
DIALOGRETURN%
VIAINSERTITEM%
ITEMDIALOGCANCELLED%
ISHELFPO&
COMPACTCOUNT%
CURSORPOSITION&
PROGRAM$
The list is emptyW8
ITEMN$#
QUANTP"
UNITAB$#
CATN$#
SHN$#
SHELFN$#
APPER%
PSTATUS%
+ Edit Item
+ Quantity:O
UNITAB$#
Unit:
Unit:
,...K
,...K
Item name:O
CATN$#
+ Category:
+ Category:
,...K
,...K
Shelf deletedC[$
SHN$#
: Shelf deletedK
SHN$#
SHELFN$#
SHN$#
SHELFN$#
Shop, shelf:
Shop, Shelf:
,...K
,...K
One time item:
CancelO
UNITAB$#
CATN$#
SHN$#
SHELFN$#
SHELFPO&!
ITEMN$'
QUANTP&
UNITAB$'
CATN$'
SHN$'
SHELFN$'
APPER%$
SHELFPO&%
ITEMN$#
CATN$#
SHN$#
SHELFN$#
SHELFPO&!
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
MOVENOTINACTION
ERROR_HANDLER
TESTMODE%
FALSE
IITEMN$
IQUANTP
IUNITAB$
ICATN$
ISHN$
CURSH$
ISHELFN$
IAPPER%
UNITCOUNT%
UNITABBREV$
UNITCHOICE%
CATEGORYCOUNT%
CATEGORYNAME1$
CATEGORYCHOICE%
CHOSENSHOP$
SHOPSHELFCOUNT%
SHOPSHELF$
SHOPSHELFCHOICE%
ONETIME%
ONETIMEOLD%
DIALOGRETURN%
ISHELFPO&
COMPACTCOUNT%
PROGRAM$
ITEMN$#
QUANTP"
UNITAB$#
CATN$#
APPER%
Duplicate Item
+ Quantity:O
UNITAB$#
Unit:
Unit:
,...K
,...K
Item name:O
CATN$#
+ Category:
+ Category:
,...K
,...K
SHN$#
SHELFN$#
Shop, shelf:
Shop, Shelf:
,...K
,...K
One time item:
CancelO
UNITAB$#
CATN$#
SHN$#
SHELFN$#
SHELFPO&!
ITEMN$'
QUANTP&
UNITAB$'
CATN$'
SHN$'
SHELFN$'
APPER%$
SHELFPO&%
PSTATUS%$
OPENLISTTABLE
MOVEINACTION
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
CURRENTLIST%
ITEMBM%
ITEMDIALOGCANCELLED%
DIALOGRETURN%
CURSORPOSITION&
PROGRAM$
Delete Item
Delete Item: +
ITEMN$#
CancelO
DeleteO
OPENTABLE
INSERTCATEGORY
UPDATECATEGORY
VWREDRAWALL
DELETECATEGORY
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
DIALOGRETURN%
NOCATEGORYINSERTED%
CATEGORYCOUNT%
CATEGORYNAME1$
CATEGORYCHOICE%
CATEGORYBM%
MODE%
VLISTLENGTHORORDERCHANGED%
PROGRAM$
Edit Category
No Category presentO
Add a new CategoryO
Add CategoryOa+
CancelO
Oa@[%
Edit Category
CATN$#
Select Category:
Select Category:
,...K
,...K
Add CategoryOa+
Update CategoryOe+
ReadyO
Add CategoryOa+
Update CategoryOe+
Delete CategoryOd+
ReadyO
Oa@[*
New category in progressO
Oe@[K
Update category in progressO
Od@[*
Delete category in progressO
OPENTABLE
INSERTSHOP
INPUTISVALID
ALERTINVALIDCHAR
INSERTSHELF
MOVEINACTION
MOVENOTINACTION
ERROR_HANDLER
TESTMODE%
FALSE
NOCATEGORYINSERTED%
SHOPCANCELLED%
DIALOGRETURN%
CATEGORYENTERED$
SHELFCOUNT%
SHELFNAME1$
SHELFCHOICE%
SHOPCOUNT%
SHOPNAME1$
CURSH$
SHOPCHOICE%
SHOPCHOICEBM%
EDITEDSHOP$
SHELFBM%
DEFSHELFN$
DEFSHN$
COMPACTCOUNT%
CATEGORYBM%
PROGRAM$
New Category
No Shop presentO
At first add a new shopO
CancelO
Add ShopOa
Oa@[$
New Category
Category name:O
SHN$#
SHELFN$#
Default Shelf:
,...K
<New Shelf>
,...K
<New Shelf>
Default Shelf:
,...K
,...K
CancelO
Choose Default Shop
SHN$#
SHN$#
Select Shop:
Select Shop:
,...K
,...K
CancelO
ReadyO
SHN$#
SHELFN$#
SHN$#
CATN$'
SHN$'
SHELFN$'
APPER%$
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
CATEGORYBM%
CATEGORYNAME1$
CATEGORYOLDNAME$
DEFSHN$
DEFSHELFN$
DEFAPP&
SHELFCHOICE%
SHELFCOUNT%
SHELFNAME1$
DIALOGRETURN%
COMPACTCOUNT%
PROGRAM$
CATN$#
CATN$#
SHN$#
SHELFN$#
APPER%
Update Category
+#Alter Category name and/or defaultsO
Category name:O
SHN$#
SHELFN$#
SHN$#
SHELFN$#
Default Shelf:
Default Shelf:
,...K
,...K
CancelO
SHELFN$#
SHN$#
CATN$'
SHN$'
SHELFN$'
APPER%$
CATN$#
CATN$'
OPENTABLE
CONVERTTOWHERE$
MOVEINACTION
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
CATEGORYBM%
CHOSENCATEGORY$
DIALOGRETURN%
COMPACTCOUNT%
PROGRAM$
CATN$#
Delete Category
Delete Category:
CancelO
DeleteO
CATN$#
CATN$#
is in use by item K+
ITEMN$#
and possibly by more.K+2Assign the items to other categories and try againW8
OPENTABLE
INSERTSHOP
UPDATESHOP
DELETESHOP
DETERMINEFILESIZE
VWSETVIEWREDRAWALL
VWREDRAWALL
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCANCELLED%
DIALOGRETURN%
SHOPCOUNT%
SHOPNAME1$
CURSH$
SHOPCHOICE%
SHOPCHOICEBM%
EDITEDSHOP$
MODE%
PROGRAM$
+ Edit Shop
No Shop presentO
Add a new shopO
Add ShopOa+
CancelO
Oa@[$
+ Edit Shop
SHN$#
SHN$#
Select Shop:
Select Shop:
,...K
,...K
Add ShopOa+
Update ShopOe+
ReadyO
Add ShopOa+
Update ShopOe+
Delete ShopOd+
ReadyO
SHN$#
Oa@[&
New shop in progressO
Oe@[)
Update shop in progressO
Od@[&
Delete shop in progressO
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
OPENTABLE
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCANCELLED%
SHOPENTERED$
DIALOGRETURN%
COMPACTCOUNT%
CHOSENSHOP$
PROGRAM$
New Shop
Shop Name:O
CancelO
SHN$'
SHN$'
SHELFN$'
Shelf 1
SHELFPO&%
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICEBM%
SHOPNAME1$
OLDSHOPNAME$
DIALOGRETURN%
COMPACTCOUNT%
CHOSENSHOP$
CURSH$
PROGRAM$
SHN$#
SHN$#
Update Shop
Alter shop nameO
Shop name:O
CancelO
SHN$'
SHN$#
SHN$'
SHN$#
SHN$'
SHN$#
SHN$'
MOVEINACTION
OPENTABLE
CONVERTTOWHERE$
MOVENOTINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICE%
SHOPCHOICEBM%
CHOSENSHOP$
DIALOGRETURN%
CURSHBM%
CURSH$
EDITEDSHOP$
PROGRAM$
SHN$#
Delete Shop
Delete shop: +
SHN$#
CancelO
DeleteO
The last shop cannot be deletedW8
Delete Shop
is in use as defaultKO
by category: +
CATN$#
and possibly by more.KO
+3Select other shop/shelf defaults for the categoriesO
and try againO
Delete Shop
Item: +
ITEMN$#
K+, and possilby more are allocated to the shopKO
Move the items to the picklist,O
+%assign them to shelves of other shopsO
and try againO
SHN$#
OPENTABLE
FINDCHOSENSHELF
INSERTSHELF
EDITSHOP
UPDATESHELF
MOVESHELF
DELETESHELF
DETERMINEFILESIZE
VWREDRAWALL
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
CHOSENSHOP$
CURSH$
SHOPCHOICEBM%
SHELFCOUNT%
SHELFNAME1$
SHELFCHOICE%
DIALOGRETURN%
VLISTLENGTHORORDERCHANGED%
MODE%
PROGRAM$
SHN$#
+0MOVE ITEM: Current shop not present in shoptableW8
SHN$#
Edit Shelf
Shop:
SHELFN$#
SHELFN$#
SHELFPO&!
Select Shelf:
Select Shelf:
,...K
,...K
+ Add ShelfOa+
Update ShelfOe+
Select ShopOs+
ReadyO
+ Add ShelfOa+
Update ShelfOe+
Move ShelfOm+
Delete ShelfOd+
Select ShopOs+
ReadyO
Oa@['
New shelf in progressO
Oe@[*
Update shelf in progressO
Om@[(
Move shelf in progressO
Od@[*
Delete shelf in progressO
OPENTABLE
ERROR_HANDLER
TESTMODE%
FALSE
SHELFCHOICE%
SHELFBM%
PROGRAM$
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
MOVENOTINACTION
MOVESHELF
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICEBM%
CHOSENSHOP$
SHELFENTERED$
DIALOGRETURN%
COMPACTCOUNT%
SHELFBM%
PROGRAM$
SHN$#
+ New Shelf
Shop:
Shelf Name:O
CancelO
SHELFPO&!
SHN$'
SHELFN$'
SHELFPO&%
OPENTABLE
FINDCHOSENSHELF
MOVEINACTION
COMPACTCHECK
MOVENOTINACTION
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICEBM%
CHOSENSHOP$
SHELFCOUNT%
SHELFBM%
FROMSHELFBM%
SHELFNAME1$
FROMSHELFN$
FROMSHELFPO&
SHELFCHOICE%
DIALOGRETURN%
AFTERSHELFPO&
COMPACTCOUNT%
CHOSENSHELF$
PROGRAM$
SHN$#
SHELFN$#
SHELFN$#
SHELFPO&!
Move Shelf
Shelf:
, of Shop: K
SHELFN$#
SHELFN$#
Insert after:
Insert after:
,...K
,...K
CancelO
Move ShelfOm
SHELFPO&!
SHELFPO&%
SHELFPO&!
Move shelf
SHELFPO&!
Move shelf
SHELFPO&%
SHELFPO&!
SHELFN$#
SHN$#
Move shelf
SHELFPO&%
SHELFPO&!
SHELFPO&%
SHELFPO&!
SHELFN$#
SHN$#
Move shelf
SHELFPO&%
SHELFPO&!
SHELFPO&!
SHELFPO&!
Move shelf
SHELFPO&%
SHELFPO&!
SHELFN$#
SHN$#
Move shelf
SHELFPO&%
SHELFPO&!
SHELFPO&%
SHELFPO&!
SHELFN$#
SHELFN$#
SHN$#
Move shelf
SHELFPO&%
SHELFPO&!
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
MOVEINACTION
COMPACTCHECK
MOVENOTINACTION
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICEBM%
CHOSENSHOP$
SHELFBM%
SHELFNAME1$
SHELFNAME2$
DIALOGRETURN%
COMPACTCOUNT%
PROGRAM$
SHN$#
SHELFN$#
SHELFN$#
Update Shelf
Shop:
Alter Shelf nameO
Shelf name:O
CancelO
SHELFN$'
SHN$#
SHELFN$#
SHN$#
SHELFN$'
OPENTABLE
CONVERTTOWHERE$
MOVEINACTION
COMPACTCHECK
MOVENOTINACTION
ERROR_HANDLER
TESTMODE%
FALSE
SHOPCHOICEBM%
CHOSENSHOP$
SHELFBM%
DIALOGRETURN%
CHOSENSHELF$
COMPACTCOUNT%
PROGRAM$
SHN$#
Delete Shelf
Shop:
Delete Shelf: +
SHELFN$#
CancelO
DeleteO
+ The last shelf cannot be deletedW8
SHN$#
SHELFN$#
SHELFN$#
is in use by item K+
ITEMN$#
and possibly by more.K+/Assign the items to other shelves and try againW8
Recalculate shelf order
SHELFPO&%
SHELFPO&!
SHN$#
SHELFN$#
SHELFPO&%
SHELFPO&!
OPENTABLE
INSERTUNIT
UPDATEUNIT
DELETEUNIT
VWREDRAWALL
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
DIALOGRETURN%
UNITCOUNT%
UNITNAME1$
DEFQUANT
UNITCHOICE%
UNITBM%
MODE%
PROGRAM$
+ Edit Unit
No Unit presentO
Add a new UnitO
CancelO
Add UnitOa
+ Edit Unit
UNITAB$#
UNITAB$'
UNITAB$#
DEFQUANT"
Select Unit:
Select Unit:
,...K
,...K
Add UnitOa+
Update UnitOe+
ReadyO
Add UnitOa+
Update UnitOe+
Delete UnitOd+
ReadyO
Oa@[&
New unit in progressO
Oe@[)
Update unit in progressO
Od@[&
Delete unit in progressO
INPUTISVALID
ALERTINVALIDCHAR
OPENTABLE
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
UNITENTERED$
DEFQUANTENTERED
DIALOGRETURN%
COMPACTCOUNT%
UNITBM%
PROGRAM$
New Unit
Unit abbreviation:
Enter the default quantity:O
CancelO
UNITAB$'
DEFQUANT&
OPENTABLE
INPUTISVALID
ALERTINVALIDCHAR
OPENLISTTABLE
VWREDRAWALL
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
UNITBM%
UNITNAME1$
UNITNAME1OLD$
DEFQUANTENTERED
DIALOGRETURN%
COMPACTCOUNT%
MODE%
CURRENTLIST%
PROGRAM$
UNITAB$#
UNITAB$#
DEFQUANT"
Update Unit
+'Alter Unit name and/or default quantityO
Unit abbreviation:O
Default quantity:O
CancelO
UNITAB$'
DEFQUANT&
UNITAB$#
UNITAB$'
OPENTABLE
CONVERTTOWHERE$
MOVEINACTION
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
UNITBM%
CHOSENUNIT$
DIALOGRETURN%
COMPACTCOUNT%
PROGRAM$
UNITAB$#
Delete Unit
Delete Unit: +
UNITAB$#
CancelO
DeleteO
UNITAB$#
is in use by item: K+
ITEMN$#
and possibly by more.K+-Assign the items to other units and try againW8
select all categories
select one category
select all shops
select one shop
CREATE
ERROR_HANDLER
TESTMODE%
FALSE
CREATECANCELLED%
PROGRAM$
New data file
File,Folder,DiskO
CancelO
Document already exists
TOOLBARTITLE
MAKECURRENTSHOPBOOKMARK
PICKMODE
ERROR_HANDLER
TESTMODE%
FALSE
SAVEASPATH$
DATABASEPATH$
CURRENTDOC$
LASTUSED$
FILE$
PROGRAM$
Save As
+"You used the current name and path
Change the name and/or the path
CloseO
TOOLBARTITLE
OPENTABLE
MAKECURRENTSHOPBOOKMARK
DETERMINEFILESIZE
INITWINDOWS
COMPACTCHECK
ERROR_HANDLER
TESTMODE%
FALSE
COMPACTCOUNT%
FILE$
LASTUSED$
SHOPKEY&
SHELFKEY&
CATEGORYKEY&
UNITKEY&
ITEMKEY&
CURSH$
PROGRAM$
K+," Fields Header(126), MoveInAction TO HeaderK
HEADER$
MOVEINACTION%
MOVEINACTION%$
" Fields Shopname(30) TO ShopK
Shopname_
+ ShopIndex
K+=" Fields ShopName(30), ShelfName(30), ShelfPickOrder TO ShelfK
SHELFN$
SHELFPO&
Shopname_
ShelfPickOrder_
+ Shelfname_
ShelfIndex
Shelf
K+\" Fields CategoryName(30), DefStoreName(30), DefShelfName(30), DefAutoPickPeriod TO CategoryK
(.txt)
