@database @node main AppendixB "SBase Personal - B. ERROR MESSAGES" @{" APPENDIX B: ERROR MESSAGES " link 0} @{" Error Message Numbers " link 1} @endnode @node 0 APPENDIX B: ERROR MESSAGES - Error message numbers are shown at the end of this appendix. A file must have at least one index If you need to remove and rebuild the only index to a file you must first build a temporary one on another field. To change from a unique to a duplicate index, you must remove and rebuild it. Access to file not allowed The file requires a password. Alternatively, you do not have the correct access privileges for the operation required. Ambiguous reference The OPEN FIELDS command includes a field which may not belong to the specified file. Array already dimensioned Program error. You have used the DIM statement twice for the same array. Array variable not dimensioned Program error. You have referred to an array variable without dimensioning it first using the DIM statement. Cannot AND - illegal values The `AND' operator cannot handle values greater than 2,147,483,647 or less than -2,147,483,648. Cannot OR - illegal values The OR operator cannot handle values greater than 2,147,483,647 or less than -2,147,483,648. Cannot access directory System error or the directory doesn't exist. Check that the correct disk is inserted. Cannot access disk information System error. AmigaDOS cannot return directory information. Cannot divide by zero Divisor in an expression or equation is equal to zero. Cannot find this field Usually caused by mis-spelling a field name. SBase Persoanl 4 treats any text item that is not a string variable or a reserved word as a field name. This message will be generated if the field referred to does not exist. Cannot find this file Usually caused by mis-spelling a file name in a command line. SBase 4 treats a text item following a field name and a period (full stop) as file name. This message will be generated if the file does not exist. Cannot open COM port Either your system does not provide a COM (serial) port, or the COM port may be in use by another application. Cannot open the clipboard The clipboard is in use by another application. Cannot open the printer Physical system error. Check that the printer is correctly connected and switched on. Cannot re-open Usually occurs when you click Cancel after modifying the file definition for a dependent file (a file which is referenced by another open file). The solution is to close the other file first. Cannot total non-numeric fields This error would occur if you attempted to generate a total using a text field; for example, if you used the keyword SUM with a text field in the Query Report command line. CASE required after SELECT CASE Program error. SELECT CASE must be accompanied by CASE. Closing parenthesis missing Error in formula, program or command line. There must be an equal number of opening and closing parentheses. Command must be at the end of line Program error. Certain commands, such as SET, must not be followed by other commands on the same line. Data too long for field Occurs when the data you are trying to store in a field is longer than the length of the field as set in the file definition. Edit field length if necessary. Data types don't match Caused by combining different field types or literal data types in one expression; for example, assigning a text string to a numeric field. DOS can't open file System error while trying to open a SBase .SBF or index file. DOS can't open input file System error while trying to open a SBase .SBD or other sequential file for input. DOS can't open output file System error while trying to open a SBase .SBD or other sequential file for output. DOS error deleting file Disk error while attempting to delete a file. DOS error reading data Disk read error while reading a SBase .SBF, an index file, or other sequential files. DOS error reading file Disk read error while reading a SBase .SBD or index file. DOS error writing data Disk error while writing a SBase .SBF or index file. DOS error writing file Disk error while writing a SBase .SBD or other sequential file. Duplicate entry for this index Index in use allows unique entries only. Can occur when saving a record or importing records leaving blank index fields. ELSE without END IF Program error. ELSE must be accompanied by END IF. End of external file The end of the file has been encountered unexpectedly. The file may be corrupt. End of file Information message. END SELECT missing from SELECT CASE Program error. SELECT CASE must be accompanied by END SELECT. Error during file transfer Hardware problem or disk error. If errors occurs in transmitting a block during file transfer, SBase retries for a specified number of times. This error message is generated when the number of retries exceeds the maximum retry count. Error unlocking file SBase system error. Quit and then reload SBase. Error while renaming file Disk error. The most likely explanation is that the disk you are using has been corrupted. Try renaming the file to another disk, or saving it first in another directory. External file not compatible External picture files must be compatible with .GIF, .PCX or certain types of .IFF files for SBase to be able to display them. External file not found Occurs when the file named in an External File field is not found where it should be. Check directory and/or path name and/or disk volume name. Field already exists Each field name in a File Definition must be unique. Field already has an index Occurs when you attempt to create an index on a field which already has an index; for example, with the New Index option or with the CREATE INDEX command. Field does not match validation If a field has a validation formula you must enter data within the formula's limits. Errors can occur during Import or when editing records. Use Utilities Status File to read Validation formulas. Field not defined Program error. You have referred to field which does not exist - if you type a variable name incorrectly, SBase will assume you are trying to access a field and will issue this errror message. Field requires numeric data You cannot assign text data to a numeric field. Field requires text data You cannot assign numeric data to a text field. File already exists SBase will not allow you to overwrite an existing file. File contains non-text characters Illegal control character detected in SBase .SBD or other sequential file. File data in wrong format Illegal field and/or record separator detected during Import. Also occurs with other sequential files when the format is incompatible with the function you are trying to execute. File open in another directory A file cannot be opened if another file with the same name is open in another directory. Floating point math error May occur during calculation of floating point values, for example due to values being out of range. Formula too complex Evaluation capabilities have been exceeded. Function not allowed with number Mismatch of function and arguments. See Appendix B. Function not allowed with text Mismatch of function and arguments. See Appendix B. Function syntax - comma missing See Appendix B. Function syntax - invalid parameter See Appendix B. GOSUB or GOTO required in statement Program error. If a statement refers to a label on another line, the label must be preceded by GOSUB or GOTO. Group not defined Program error. You have referred to a group which has not been defined in a GROUP statement. In use by another file You have attempted to close a file which is referenced by another open file. Close the other file first. 1.2 System software required To load forms, SBase requires Amiga Workbench version 1.2 or later. Incomplete field or value missing SBase has detected an error in a formula or a command line. Check that expressions are complete and do not end with an operator. Input file not open Program error. You have used the INPUT command without first opening a file for input with the OPEN FOR INPUT command. Insufficient memory SBase cannot find sufficient memory for an operation such as viewing an external file or sorting using Query Order. Invalid date The full date range is January 1, 0001 to December 31, 9999. You have probably entered a date in the wrong day, month, year sequence giving a month number greater than 12, or tried to enter illegal text or date separators. Invalid date format Program error, or SBD file invalid. Invalid field name Reserved words are not allowed: see Appendix D. Field names may not begin with numbers, and should include only alphanumeric, space and underscore characters. Invalid field type Program error, or SBD file invalid. Invalid form file Either the form file has been corrupted on disk, or you are attempting to load a form that has not been created in the Form Painter. Invalid margins selected The values you have entered in the Margins requester exceed the limits for the margin parameters. Alternatively, you may have entered a value for the left margin which is greater than the right margin, or you may have entered a negative value. Invalid numeric format Program error, or SBD file invalid. Invalid numeric parameter Illegal value for a function. Invalid parameter Program error. Check the syntax for the command or commands in the line which caused the error. Invalid statement beginning Statements must begin with keywords, variables or labels. This message will be issued if you start a statement with anything else, e.g. an arithmetic operator. Invalid statement ending Usually means that you have entered an operator at the end of the statement but have not followed it with a value of some kind, e.g. ending a statement with `+' would cause this error message. After executing a statement, SBase expects to find either a colon (followed by another command) or an end of line. It will generate this message if it finds an extraneous keyword, variable, or label. Invalid subscript for array Program error. Array subscript exceeds the number of elements specified for the array in a DIM statement. Invalid text parameter Illegal value for a function. Invalid time The time range is from 0:00 to 23:59 (or 11:59 pm). You have entered a time which falls outside this range, e.g. 25:06. Key not found Appears for your information whenever a key lookup doesn't find an exact key match, even if you used a partial key entry to retrieve the record. Logical field must contain Y, N, T or F The contents of a logical field are restricted as indicated. Misplaced command Operand missing in command line, or a keyword has been used in a command where it is inappropriate. Name too long Field or variable exceeds limit of 15 characters. Nesting depth exceeded SBase supports up to 50 nesting levels with GOSUB, FOR NEXT, and WHILE WEND statments. You may have exceeded this limit. But a more likely explanation is that you have set up a Report Group in the wrong place in a Report program, e.g in a Report subroutine. NEXT without FOR Program error. If the program contains a number of nested FOR NEXT loops, check that each FOR has a corresponding NEXT. No carrier detected (DCD) DCD must be high during file transfer. No external file field defined You have clicked on the External File (camera) button when the current file has no External File fields in its definition. No file name given Program error. You have used a statement which requires a file name. No file selected Program error. You have used a statement which requires a file to be open. No more images for this record Next External or Previous External cannot work when you are already looking at the last or first image respectively for the current record. No record selected Program error. You have referred to a record without having opened the file it belongs to. Not an external field Program error. The SHOW command must refer to an external field. Not an index Your attempt to open or remove an index failed because the index file does not exist. Not an open file File named in command line is not an open database file. Not enough memory to run application Too many Workbench applications are open to run SBase. Close down other applications. Number too large SBase handles numbers up to 1.797693134862e308. Opening parenthesis missing Error in formula, prograam or command line. There must be equal number of opening and closing parentheses. Operator not allowed with text Only certain operators may be used with text items; e.g. you cannot multiply text items. Out of data Program error. This message is issued when there is no more data for a READ statement. It usually means that the data items in the programs DATA statements have already been read. Print command failed Failure occurred during a printing operation. Problem positioning in data file SBase system error. Occurs when SBase tries to read a record which does not exist. The cause may be that you have swapped disks without first closing files or changing the directory. You should always close any open files before changing disks. The first step you should take is to make a backup copy of the file, then reorganize it. Problem reading external file Error within external file. Remove index before changing field type SBase does not allow you to change the type of an indexed field. Use the Remove Index command on the Project menu to remove the index from the field. Remove index before deleting field You cannot remove an indexed field from the File Definition until you have made it a non-indexed field by removing the index. Required in statement Program error. A command which is required by the syntax of the statement has been omitted, e.g. this message would be issued if you left out the equal sign in a statement which assigned a value to a variable. RESUME without error The RESUME command cannot be issued if an error has not occurred. RETURN without GOSUB Program error. Subroutines must be called using the GOSUB or ON GOSUB statements. This error message indicates that the program control has passed to a subroutine by other some route. Possibly you have used GOTO instead of GOSUB or, more commonly, program control has simply `dropped through' to the subroutine because you have failed to direct it elsewhere. Search string not found The text string you are searching for does not exist in the current file. Statement does not give TRUE or FALSE You have defined a validation formula which cannot be evaluated. This error would occur, for example, if the formula did not contain an operator. Statement has an unrelated section An expression in a command or program line is not joined to another by AND or OR. String too long SBase application program error. Maximum length of a text string stored in a field or a variable is 4000 characters. Some strings, such as command lines, are limited to 255 characters. Subscript not numeric You have entered a string value as an array subscript. Error deleting key: 100/101/102/103 SBase system error in index. Backup the file, then reorganize it. Error reading block: 200/201 SBase system error in data file. Backup the file, then reorganize it. THEN or GOTO required in statement Program error. The keyword IF must be followed by THEN or GOTO. This field must have some data This field is a required field. If a file contains required fields, you must enter data in these fields when you are creating a new record. This WHERE statement must be a single file Some SBase functions, such as Labels, do not support multi-file application. This message occurs when you use the WHERE statement in a single file function to refer to multiple files. Undefined error Internal SBase system error. Please notify software supplier. Undefined program label Program error. The label following a GOSUB, ON GOSUB, GOTO, or ON GOTO statement does not exist elsewhere in the program. Variable not defined Program error. Occurs when you use a variable in a statement without having assigned it a value beforehand. Variable required in statement Certain commands such as INPUT and GET must be followed by a variable. WEND without WHILE Program error. WEND must be accompanied by WHILE. Write failed - Disk is full Your data file may be unstable. Use Process Reorganize to transfer data to another volume and/or file. @endnode @node 1 Error Message Numbers Number Message Text 1 Not an index 2 No more images for this record 3 Print command failed 4 Cannot open the printer 5 Not an open file 6 Access to file not allowed 7 A file must have at least one index 8 Key not found: Next in sequence selected 9 No external file field defined 10 End of file 11 (No message) 12 Cannot access directory 13 Cannot access disk information 14 Name too long 15 Cannot find this file 16 Cannot find this field 17 Invalid statement 18 Out of data 19 Invalid date 20 Data types don't match 21 Operator not allowed with text 22 Function not allowed with text 23 Function not allowed with number 24 Cannot divide by zero 25 Cannot `AND' -- illegal values 26 Cannot `OR' -- illegal values 27 Invalid numeric parameter 28 Invalid text parameter 29 Closing parenthesis missing 30 Opening parenthesis missing 31 Function syntax -- comma missing 32 Function syntax -- invalid parameter 33 String too long 34 Misplaced command 35 Formula too complex 36 Variable not defined 37 Field not defined 38 Number too large 39 Invalid numeric format 40 No file name given 41 Invalid parameter 42 Field already exists 43 File already exists 44 No file selected 45 Invalid field type 46 Invalid field name 47 Data too long for field 48 Field requires numeric data 49 Field requires text data 50 This field must have some data 51 Field does not match validation 52 DOS cannot open file: 53 DOS error deleting file: 54 DOS error writing file: 55 RETURN without GOSUB 56 NEXT without FOR 57 Duplicate entry for this index 58 No record selected 59 SBase 4 error deleting key: 100 60 SBase 4 error deleting key: 101 61 SBase 4 error deleting key: 102 62 SBase 4 error deleting key: 103 63 Memory allocation error 64 DOS error reading file: 65 DOS error writing file: 66 File contains non-text characters 67 File data in wrong format 68 DOS cannot open input file: 69 DOS cannot open output file: 70 Undefined program label 71 SBase 4 error reading block: 200 72 SBase 4 error reading block: 201 73 Invalid date format 74 Invalid numeric format 75 DOS error reading data: 76 DOS error writing data: 77 Problem positioning in data file 78 End of external file 79 External file not found 80 External file not compatible 81 Problem reading external file 82 Remove index before deleting field 83 Incomplete -- field or value missing 84 Statement has unrelated section 85 Statement does not give TRUE or FALSE 86 Remove index before changing field type 87 Cannot total Non-Numeric fields 88 Insufficient memory 89 Dongle missing from games port 2 90 Insufficient stack space 91 Error while renaming file 92 This WHERE statement must be single file 93 Command must be at end of line 94 Invalid time 95 Input file not open 96 Not an external field 97 RESUME without error 98 Problem with narrator device 99 Problem with console device 100 Field already has an index 101 Array variable not dimensioned 102 Invalid subscript for array 103 Subscript not numeric 104 Array already dimensioned 105 WEND without WHILE 106 Nesting depth exceeded 107 Problem loading overlay 108 Invalid statement beginning 109 Invalid statement ending 110 Required in statement 111 Variable required in statement 112 THEN or GOTO required in statement 113 GOSUB or GOTO required in statement 114 Invalid form file 115 Group not defined 116 Problem opening font library 117 File open in another directory 118 Problem opening window 119 1.2 System software required 120 Ambiguous reference 121 ELSE without END IF 122 In use by another file 123 Cannot re-open 124 Cannot open COM port 125 Error during file transfer 126 No carrier detected (DCD) 127 File is busy 128 Error unlocking file 129 Record in use 130 Record being modified 131 File is open for exclusive access 132 File is open for shared access 133 Too many users for this version 134 Network or file sharing inactive 135 File has changed: Select record by key 136 Exclusive lock required 137 File in use by: 138 Access denied: Sharing violation 139 File is open for exclusive write 140 File is open for shared write 141 File has been modified 142 File is open for read only 143 ERR 144 ERR 145 ERR 146 ERR 147 ERR 148 Search string not found 149 ERR 150 Invalid margins selected 151 CASE required after SELECT CASE 152 END SELECT missing from SELECT CASE 153 Write failed - Disk is full 154 ERR 155 Logical field must contain Y,N,T or F 156 ERR 157 ERR 158 Cannot open the Clipboard 159 Floating point math error 160 ERR 161 Precision error in math function 162 Form requires new version of software 163 Reorganize failed to complete 164 Insufficient disk space 165 ERR 166 ERR 167 ERR 168 ERR 169 Invalid SBase library 170 Network control file not present 171 Invalid network control file directory 172 Cannot access network control file 173 Invalid lock file 174 Cannot lock database file 175 Cannot lock file 176 Cannot lock record 177 Record is not locked @endnode