Author Topic: Kontrol Kesalahan / error  (Read 2713 times)

0 Members and 1 Guest are viewing this topic.

Offline pangeranku

  • Junior Member
  • *
  • Posts: 116
Kontrol Kesalahan / error
« on: February 19, 2013, 05:01:05 PM »
Hanya sekedar berbagi

Prosedur ini bisa mengontrol bila terjadi error, mungkin ada manfaatnya, mohon penyempurnaannya bila masih ditemukan kekurangan.

taruh prosedur  error

LPARAMETERS nError, cMethod, nLine
salah=nerror
tombol=UPPER(this.Name)
xform=UPPER(thisform.Name)
XFILE=JUSTfname(SYS(16))
USE salahku

LOCATE FOR baris=salah
keterangan=pesan
jwb=MESSAGEBOX('Nama File     : '+xfile+chr(13)+;
'Nama Form   : '+xform+CHR(13)+;
'Prosedur      : '+UPPER(cmethod)+' - '+tombol+CHR(13)+;
'Nomor Line   : '+STR(nline,4)+CHR(13)+;
'Pesan Error   : '+ALLTRIM(pesan)+CHR(13)+CHR(13)+;
'Silahkan Hubungi Bagian IT untuk monitoring trouble',2+64,"TroubleShoot")

DO case
   CASE jwb=3
   cancel
   CASE jwb=4
   RETRY
   CASE jwb=5
   return
ENDCASE

copy data dibawah ke dalam tabel salahku, sesuai dgn nama table diatas (salahku), atau bisa diubah sesuai dg keinginan.

Terima kasih


baris    pesan
1   File "name" does not exist.
3   File is in use.
4   End of file encountered.
5   Record is out of range.
6   Too many files open.
7   File already exists.
9   Data type mismatch.
10   Syntax error.
11   Function argument value, type, or count is invalid.
12   Variable "variable" is not found.
13   Alias is not found.
15   Not a table.
16   Unrecognized command verb.
17   Table number is invalid.
18   Line is too long.
19   Index file does not match table.
20   Record is not in index.
21   Length of variable strings exceeds amount of memory.
22   Too many variables.
23   Index expression exceeds maximum length.
24   Alias name is already in use.
26   Table has no index order set.
27   Not a numeric expression.
30   Row or column position is off the screen.
31   Invalid subscript reference.
34   Operation is invalid for a Memo, Blob, General, or Picture field.
36   Command contains unrecognized phrase/keyword.
37   You must use a logical expression with FILTER.
38   Beginning of file encountered.
39   Numeric overflow. Data was lost.
41   Memo file "name" is missing or is invalid.
42   The LOCATE command must be issued before the CONTINUE command.
43   There is not enough memory to complete this operation.
44   Cyclic relation.
45   Not a character expression.
46   Expression evaluated to an illegal value.
47   No fields found to process.
50   Report file "name" is invalid.
52   No table is open in the current work area.
54   Label file is invalid.
55   Memory file is invalid.
56   There is not enough disk space for "name".
58   LOG( ): Zero or negative used as argument.
61   SQRT argument cannot be negative.
62   Cannot access characters beyond string.
67   Expression evaluator failed.
78   ** or ^ domain error.
91   File was not placed in memory using the LOAD command.
94   Must specify additional parameters.
95   Statement is not allowed in interactive mode.
96   Nesting error.
101   Cannot open file "file".
102   Cannot create file "file".
103   Allowed DO nesting level exceeded.
104   Unknown function key.
107   Operator/operand type mismatch.
108   Terjadi gangguan koneksi ke komputer data, chek koneksi jaringan anda atau pastikan posisi komputer data dalam keadaan aktif
109   Record is in use by another user.
110   File must be opened exclusively.
111   Cannot update the cursor "cursor", since it is read-only.
112   Invalid key length.
114   Index does not match the table. Delete the index file and re-create the index.
115   .DIF file header is invalid.
116   .DIF vector is invalid - .DBF field mismatch.
117   .DIF type indicator is invalid.
119   .SYLK file header is invalid.
120   .SYLK file dimension bounds are invalid.
121   .SYLK file format is invalid.
124   Printer redirection is invalid.
125   Printer is not ready.
127   View file is invalid.
130   Record is not locked.
138   No fields were found to copy.
152   Missing expression.
164   Menu title has not been defined with DEFINE PAD.
165   Menu has not been defined with DEFINE POPUP.
166   No menu items have been defined for this menu.
167   Menu item position must be a positive number.
168   Menu has not been defined with DEFINE MENU.
169   Cannot define menu item.
170   Cannot release menu item.
174   Cannot redefine a menu that is in use.
175   Cannot redefine popup that is in use.
176   Cannot clear menu that is in use.
177   Cannot clear popup that is in use.
178   Menu has not been activated with ACTIVATE MENU.
179   Menu has not been activated with ACTIVATE POPUP.
181   Menu specified in ACTIVATE MENU is already in use.
182   Menu specified in ACTIVATE POPUP is already in use.
202   Invalid path or file name.
214   Window has not been defined with DEFINE WINDOW.
215   Window has not been activated with ACTIVATE WINDOW.
216   Display mode is not available.
221   Left margin including indent must be less than the right margin.
222   Line number must be less than page length.
223   Column number must be between 0 and 255.
225   "name" is not a variable.
226   "name" is not a file variable.
227   Box dimensions are invalid.
228   Tab stops must be in ascending order.
230   Array dimensions are invalid.
231   Invalid argument used with the SET function.
232   "name" is not an array.
255   Not a valid RapidFile database.
256   Not a valid Framework II database/spreadsheet.
279   Menu was not pushed.
287   Menu size is too small.
291   Expression used with ASIN( ) is out of range.
292   Cannot use 0 or negative as the argument for LOG10( ).
293   Expression used with ACOS( ) is out of range.
297   Lotus 1-2-3 version 2.0 file format is invalid.
332   Window specified in DEFINE WINDOW has invalid coordinates.
350   Field must be a Memo field.
355   Macro is not defined.
356   Keyboard macro file format is invalid.
392   Maximum record length exceeded in the import file.
1000   Internal consistency error.
1001   Feature is not available.
1002   Input/output operation failure.
1097   User defined functions are not allowed.
1098   API function _UserError( ) was called.
1102   Cannot create file "file".
1103   Invalid seek offset.
1104   Error reading file "file".
1105   Error writing to file "file".
1106   Cannot access file "file"; transaction is in progress.
1108   Picture too big, corrupt, or in wrong format.
1111   Invalid file descriptor.
1112   Error closing the file.
1113   File is not open.
1115   Invalid operation for the cursor.
1116   Too many windows open.
1117   Key field length does not match.
1124   Key exceeds allowed size.
1126   Record is too long.
1127   You must use a logical expression with a FOR or WHILE clause.
1130   'field' phrase is not found.
1131   The file specified in the FROM clause is empty.
1134   Variable must be in the selected table.
1138   Property does not have a default value.
1140   FILTER expression exceeds allowed size.
1141   Unrecognized index file revision. Re-create the index.
1145   Must be a character or numeric key field.
1147   Target table is already engaged in a relation.
1148   Expression has been re-entered while the filter is executing.
1149   Not enough memory for buffer.
1150   Not enough memory for file map.
1151   Not enough memory for filename.
1152   Cannot access the selected table.
1153   Cannot rename the file to different device.
1156   Duplicate field names.
1157   Cannot update the file "file".
1162   Procedure "procedure" is not found.
1163   Browse table is closed.
1164   Browse structure has changed.
1165   "field" is not related to the current work area.
1166   Cursor is corrupt or in wrong format.
1167   Icon is corrupt or in wrong format.
1168   Could not add icon to executable file.
1169   Project file is read-only.
1178   Application file "file" is not closed.
1181   Could not add version resource to executable file.
1183   Relation already exists.
1184   File cannot be closed because outstanding references exist.
1190   File "name" is too large.
1191   Cannot save form: an object has an invalid name
1193   Missing .RTT section.
1194   Link command failed.
1195   Object file "file" was compiled in a previous version of FoxPro.
1196   "file" is not a Visual FoxPro .EXE file.
1201   Too many names used.
1202   Program is too large.
1206   Recursive macro definition.
1211   An IF | ELSE | ENDIF statement is missing.
1212   Structure nesting is too deep.
1213   There is a missing keyword in the FOR ... ENDFOR or DO CASE ... ENDCASE command structure.
1214   ENDTEXT does not have corresponding TEXT statement.
1217   Picture error in GET statement.
1220   Command contains invalid character.
1221   Command is missing required clause.
1223   Invalid variable reference.
1225   Must be a variable or array.
1226   Must be a file variable.
1229   Too few arguments.
1230   Too many arguments.
1231   Missing operand.
1232   DIMENSION contains variable declaration without required subscript arguments.
1234   Subscript is outside defined range.
1235   Structure is invalid.
1236   Suspend program before using RESUME.
1238   No PARAMETER statement is found.
1241   Improper data type in the group expression.
1242   Syntax error in the field expression.
1243   Internal error: Too many characters in the report.
1245   Invalid expression in label definition file.
1246   Total label width exceeds allowed size.
1249   Too many READ commands are in effect.
1250   Too many PROCEDURE commands are in effect.
1252   Compiled code for this line is too long.
1253   Cannot rename the current directory.
1254   Cannot nest key labels.
1255   Key label "label" is invalid.
1256   Mismatched braces in key label.
1257   Key string is too long.
1258   Error in the PICTURE clause.
1294   "name" is not a valid resource file.
1296   Error reading the resource.
1297   Command is allowed only in interactive mode.
1298   "name" band is too large to fit on page.
1300   Function name is missing ).
1304   Function name is missing (.
1306   Missing comma (,).
1307   Cannot divide by 0.
1308   Insufficient stack space.
1309   "file" is not an object file.
1310   Too many characters are specified in the PICTURE clause.
1313   Class creation canceled.
1337   Cannot nest the PRINTJOB command.
1338   File is the wrong version.
1405   RUN|! Command failed. "Details".
1410   Unable to create temporary work files.
1411   RUN|! command string is too long.
1412   Cannot locate the COMSPEC environment variable.
1413   Page frame cannot be sized that small.
1420   OLE object is invalid or corrupted.
1421   Cannot activate the OLE server.
1422   Error saving the OLE object.
1423   Error creating the OLE object.
1424   Error copying the OLE object to Clipboard.
1426   OLE error code 0x"name".
1427   OLE IDispatch exception code "name".
1428   OLE IDispatch exception code "number" from "name": "name".
1429   "OLE error".
1431   Maximum number of OLE arguments is exceeded.
1434   Class "name" has not been registered.
1435   XML Parse Error
1436   Only insertable objects are allowed in General fields.
1437   Unable to register the ActiveX control.
1438   The ActiveX control module failed to register correctly.
1439   Not a ProjectHook class.
1440   OLE exception error "name". OLE object may be corrupt.
1441   Class cannot be instantiated because member "name" does not exist
1442   Class cannot be instantiated because member "name" has wrong # of parameters
1443   Interface "name" not found
1444   Type Library "name" not found
1445   EventHandler object "name" does not IMPLEMENT an interface
1462   "name" internal consistency error.
1463   No result set has been returned by the server.
1465   SQL pass-through internal consistency error.
1466   Connection handle is invalid.
1467   Property is invalid for local cursors.
1468   Property is invalid for table cursors.
1469   Property value is out of bounds.
1470   Incorrect property name.
1471   Incorrect column format.
1472   SQL statement parameter is required for non-prepared SqlExec( ) calls.
1473   Environment-level property is invalid.
1474   Invalid call issued while executing a SQLEXEC( ) sequence.
1475   Invalid call issued while executing a SQLMORERESULTS( ) sequence.
1476   Invalid call issued while executing a SQLTABLES( ) sequence.
1477   Invalid call issued while executing a SQLCOLUMNS( ) sequence.
1478   The ChildOrder property of a relation object in the data environment is no longer valid. The relation is being removed.
1479   Invalid update column name \"name"\.
1480   Warning: The connection sync/async mode cannot be set.
1481   Warning: The connection timeout cannot be set.
1482   Warning: The query timeout cannot be set.
1483   Warning: The connection packet size cannot be set.
1484   Warning: The next "cExpr" modified records have already been updated remote.
1485   Warning: Invalid data conversion(s) starting at record "name".
1486   Warning: Invalid memo field conversions starting at record "name".
1487   Warning: The connection transaction mode cannot be set.
1488   No connection associated with this cursor
1489   General fields cannot be used in the WHERE condition of an update statement. Change the WhereType property of the view.
1490   Saving a converted form as a class is not supported.
1491   No update tables are specified. Use the Tables property of the Cursor object.
1492   No key columns specified for the update table "name". Use the KeyFieldList property of the cursor.
1493   SQL parameter is missing.
1494   View definition has been changed.
1495   Warning: The key defined by the KeyField property for table "alias" is not unique.
1496   Warning: No information is available to check remote update conflicts.
1497   Connection name is invalid.
1498   SQL SELECT statement is invalid.
1499   SQL parameter "name" is invalid.
1501   Type conversion is not supported for output parameters.
1502   Cannot write to the record because it is in use.
1503   File cannot be locked.
1504   Function not supported for SQL pass-through cursors.
1507   Screen code is too large for available memory.
1508   Error initializing OLE.
1509   Conversion canceled. Adjust the memo BLOCKSIZE.
1510   Invalid file format. If this is a dBASE file, it must be converted first. To convert it, type MODIFY LABEL labelfilename.
1520   No database is open or set as the current database.
1521   This operation not supported for class member objects.
1522   Connectivity internal consistency error.
1523   Execution was canceled by the user.
1524   The selected printer driver does not support direct access.
1525   Function is not supported on remote tables.
1526   Connectivity error: "name".
1527   Cannot locate ODBC library, ODBC32.DLL.
1528   ODBC entry point missing, "name".
1529   File "name" already exists as part of a database.
1530   Fetching canceled; remote table is closed.
1531   The table changes cannot be performed as the index or filter expression for index name would be invalid.
1532   Type conversion is not supported.
1533   This property is read-only.
1534   Database "alias" is not open.
1535   Cannot close this database because it is being used by a project.
1536   Function is not supported on native tables.
1537   Cannot add this table: it belongs to database "name".
1538   A stored procedure is executing.
1539   Trigger failed in "cursor".
1540   Session number is invalid.
1541   Connection "name" is busy.
1542   Base table fields have been changed and no longer match view fields. View field properties cannot be set.
1543   Type conversion required by the DataType property for field '"name"' is invalid.
1544   DataType property for field '"name"' is invalid.
1545   Table buffer for alias "name" contains uncommitted changes.
1546   Cannot close table during execution of a table-bound expression.
1547   Cannot insert an empty row from a view into its base table(s).
1548   Table "alias" has one or more non-structural indexes open. Please close them and retry the Begin Transaction.
1549   Data session #number cannot be released with open transaction(s).
1550   .DBC internal consistency error.
1551   File "name" is an invalid database.
1552   File "name" is not a database.
1553   File "name" is a database.
1554   Error instantiating cursor object. Table "alias" cannot be opened. Object will be ignored.
1555   Relational expression is not valid.
1556   Table cannot be browsed because cursor object is no longer valid.
1557   The database must be opened exclusively.
1558   File "name" is not part of a database.
1559   Property is not found.
1560   Property value is invalid.
1561   Database is invalid. Please validate.
1562   Cannot find object "name" in the database.
1563   Cannot find view "name" in the current database.
1564   Table "name" already exists in the database.
1565   File "name" is part of a database.
1566   Cannot issue the PACK command on a database while its objects have open cursors.
1567   Primary key property is invalid; please validate database.
1568   View fields have been changed. The Update and Key field properties have been reset to the default values.
1569   Database "name": File access denied.
1570   Database is read-only.
1571   The name "name" is already used for another object. Please choose a different name.
1572   Cannot delete a database object while it is open in a designer.
1573   Cannot change modality of a visible form.
1574   Error initializing application object.
1575   Object name is invalid.
1576   Class "name" is not found in the class library.
1577   Table "name" is referenced in a relation.
1578   Invalid database table name.
1579   Command cannot be issued on a table with cursors in table buffering mode.
1580   Feature is not supported for non-.DBC tables.
1581   Field "name" does not accept null values.
1582   Field "name" validation rule is violated.
1583   Record validation rule is violated.
1584   Error reading a property from the database. The property is ignored.
1585   Update conflict. Use TABLEUPDATE( ) with the lForce parameter to commit the update or TABLEREVERT( ) to roll back the update.
1586   Function requires row or table buffering mode.
1587   Illegal nested OLDVAL( ) or CURVAL( ).
1588   INSERT cannot be issued when row or table buffering is enabled or when integrity constraints are in effect.
1589   Table or row buffering requires that SET MULTILOCKS is set to ON.
1590   BEGIN TRANSACTION command failed. Nesting level is too deep.
1591   END TRANSACTION command cannot be issued without a corresponding BEGIN TRANSACTION command.
1592   ROLLBACK command cannot be issued without a corresponding BEGIN TRANSACTION command.
1593   Command cannot be issued within a transaction.
1594   Illegal to attempt a file lock in a transaction after taking prior record locks.
1595   Update conflict. Some of your changes in the current row batch were committed. Use TABLEUPDATE( ) with the lForce parameter to commit the update or the manual transaction to roll back the update.
1596   Table buffering is not enabled.
1597   Views require either DB_BUFOPTROW or DB_BUFOPTTABLE.
1598   Rule and trigger code must balance transaction usage.
1599   Data session #number was forced to ROLLBACK all transactions to avoid deadlock.
1600   Not enough memory to open a table with the USE command.
1604   No menu bar is defined.
1605   No menu is defined.
1607   Maximum menu items allowed (128) is exceeded.
1608   Maximum menus allowed (25) is exceeded.
1609   Maximum menu item length (50) is exceeded.
1611   Menu items and titles must be type Character.
1612   No such menu or menu item is defined.
1621   No menu titles have been defined for this menu.
1632   Window file format is invalid.
1637   File must be opened exclusively to convert the Memo file.
1640   Access to system Registry denied
1642   Color set resource is not found.
1643   Printer driver is corrupted.
1644   Printer driver is not found.
1645   Report contains a nesting error.
1646   Total field type must be Date or Numeric.
1647   Field expression contains an invalid data type.
1649   No previous PRINTJOB command to correspond to this command.
1651   CANCEL or SUSPEND is not allowed.
1652   Invalid use of a Visual FoxPro function as an array.
1653   Label nesting error.
1657   Column number must be between 0 and the right margin.
1659   The table has memo fields that cannot be converted while open read-only.
1661   Microsoft Excel file format is invalid.
1662   Lotus 1-2-3 version 1.0 file format is invalid.
1670   Multiplan version 4.0 file format is invalid.
1671   Cannot import from password-protected file.
1672   Cannot append from password protected file.
1673   Symphony version 1.0 file format is invalid.
1674   Symphony version 1.1 file format is invalid.
1678   Lotus 1-2-3 version 3.0 file format is invalid.
1679   Import only Worksheet A for Lotus 1-2-3 version 3.0 files.
1680   Worksheet A for Lotus 1-2-3 version 3.0 file is hidden.
1681   PREVIEW clause is not allowed with OFF/NOCONSOLE or TO PRINT/FILE.
1682   Not a user-defined window.
1683   Index tag is not found.
1684   Index tag or file name must be specified.
1685   Project file is invalid.
1686   Form file "name" is invalid.
1687   Menu file is invalid.
1688   Paradox file format is invalid.
1689   Cannot build without a main program.
1690   Table operation is invalid during indexing.
1691   Library file "name" is invalid.
1693   Cannot find the menu-generation program.
1694   Too many extensions are specified.
1695   COLUMN | FORM | ALIAS | NOOVERWRITE | WIDTH are only allowed with the FROM clause.
1696   NOWAIT | SAVE | NOENVIRONMENT | IN | WINDOW clauses are not allowed with the FROM clause.
1698   COLUMN | ROW | ALIAS | NOOVERWRITE | SIZE | SCREEN are only allowed with the FROM clause.
1699   The IN clause is not supported for this window.
1705   File access is denied.
1706   Cannot sort .IDX files in descending order.
1707   Structural .CDX file is not found.
1708   File is open in another work area.
1709   Database object is being used by someone else.
1710   MULTISELECT or MOVER clause is not supported for PROMPT style menus.
1711   API library revision mismatch. Rebuild library.
1712   Field name is a duplicate or invalid.
1713   Field width or number of decimal places is invalid.
1714   Window "name" has not been defined.
1715   Server "server" is not found.
1716   Queue "queue" is not found.
1717   Unable to generate a printer driver.
1718   File "name" is read-only.
1719   Object file "name" is in use and cannot be removed from memory.
1720   Cannot issue the SET FORMAT command while a READ command is in progress on a format file.
1722   Preprocessor expression is invalid.
1723   Mismatched #IF/#ELSIF/#ELSE/#ENDIF.
1724   Missing #ENDIF.
1725   Constant is already created with #DEFINE.
1726   API library is not found.
1727   A .DBF-style Help file is required.
1728   Color scheme is reserved.
1730   Init event failed.
1731   Cannot modify a base class.
1732   Data type is invalid for this property.
1733   Class definition "name" is not found.
1734   Property "name" is not found.
1735   Error in the class definition. "Details"
1736   Error instantiating the object "object".
1737   "name" is a method, event, or object.
1738   Property "name" is not a method or event.
1739   Property setting will not take effect until data environment reloaded.
1740   "name" is a read-only property.
1741   Cannot add "name". Class definition is cyclical.
1742   The data source for this object must be a variable reference.
1743   Property "name" is read-only.
1744   Object class is invalid for this container.
1745   "name" is not a Visual FoxPro event.
1746   Class file name for "name" is not valid.
1747   Class file "name" is invalid.
1748   This file is incompatible with the current version of Visual FoxPro.
1749   Form (.SCX) file must contain at least one Form.
1750   File was created in a later version of Visual FoxPro than the current version.
1751   Class file version is greater than the current version.
1752   Class "name" is in use by MODIFY CLASS.
1753   Cannot load 32-bit DLL "name".
1754   Cannot find entry point "name" in the DLL.
1755   Cannot add an object to this class.
1756   Member object removed – cannot complete the Save operation.
1757   Property "name" is protected.
1758   Cannot change property "name" in SetAll method.
1759   Expression is invalid. Use a valid expression for "name" property.
1760   Member "name" is a class member.
1761   Class "name" already exists.
1762   Class "name" is not found.
1763   Property "name" already exists.
1764   Array is not a member of the parent object.
1765   Method contains syntax errors. Method is not saved.
1766   Object "name" is not found.
1767   Parent object will not allow this property setting for "name".
1768   Cannot add this object to a Grid.
1769   Cannot add this object to a Column.
1770   Cannot clear class "class" because it is in use.
1771   A member object with this name already exists.
1772   You may not change the RecordSource of a BROWSE object.
1773   Database object type is invalid.
1774   No sheet is found.
1775   Worksheet "name" is not found.
1776   Class "name" is in use.
1777   This command is not supported for views.
1778   The table must be converted before appending.
1779   Error adding "name" to the object. Duplicate member/property name.
1780   This array element has been defined as an object and cannot be redefined in the class definition.
1781   An object's control source cannot be set to its Value property.
1782   This OLE property cannot be an expression.
1783   Invalid class specified for @...Class command.
1784   This object is derived from a base class and does not have a parent class.
1791   Cannot find the text generation program.
1792   Text generation is canceled.
1793   The network request is not supported.
1794   "name" cannot be enumerated.
1795   Cannot arrange an untransported form.
1796   No records are found for the current platform.
1797   Error occurred in conversion.
1798   Cannot find the converter program.
1799   Conversion is canceled.
1800   SQL: Internal error.
1801   SQL: Error correlating fields.
1802   SQL: Cannot locate table.
1803   SQL: HAVING clause is invalid.
1804   SQL: Statement is invalid.
1805   SQL: Too many subqueries.
1806   SQL: Column "field | variable" is not found.
1807   SQL: GROUP BY clause is invalid.
1808   SQL: ORDER BY clause is invalid.
1809   SQL: Out of memory.
1810   SQL: Invalid use of subquery.
1811   SQL: Aggregate on non-numeric expression.
1812   SQL: Statement too long.
1813   SQL: Use of UNION in subquery is invalid.
1814   SQL: Queries of this type are not supported.
1815   "cursor" must be created with SELECT ... INTO TABLE.
1818   SQL: FROM clause is required.
1819   SQL: DISTINCT is invalid.
1820   SQL: SELECT contains invalid *.
1822   SQL: Invalid aggregate field.
1825   SQL: Subquery is invalid.
1826   SQL: SELECT is invalid.
1828   SQL: Illegal GROUP BY in subquery.
1830   SQL: Index is not found.
1831   SQL: Error building temporary index.
1832   "field | variable" is not unique and must be qualified.
1833   SQL: WHERE clause is invalid.
1834   SQL: Too many UNIONs.
1839   SQL: Operation was canceled.
1841   SQL: Too many columns referenced.
1842   SQL: Subquery nesting is too deep.
1844   Cannot nest aggregate functions.
1845   SQL expression is too complex.
1846   Cannot GROUP by aggregate field.
1851   SELECTs are not UNION compatible. "Details"
1860   Subquery returned more than one record.
1864   SQL: Too many fields in UPDATE.
1865   SQL: Invalid SET expression in UPDATE.
1866   SQL: Invalid TOP specification.
1867   SQL: TOP requires an ORDER BY.
1870   ALTER TABLE operation interrupted.
1871   Cannot DROP all existing columns.
1872   Too many columns.
1875   Multiple warnings occurred performing the requested index modifications.
1877   No rule to DROP.
1878   No default value to DROP.
1879   No primary key.
1880   Related table is not found in current database.
1881   Error loading file - record number n. "object" <or one of its members>. "Issue": "error".
1882   Related tag is not found or not primary or candidate.
1883   Primary key already exists.
1884   Uniqueness of index "name" is violated.
1885   Only structural tags can be defined as candidate.
1886   Index does not accept NULL.
1887   Illegal recursion in rule evaluation.
1888   Tag name is too long.
1889   A table in multiple relationships can only have one child order.
1890   SQL: Cannot determine data type of SQL column "column".
1903   String is too long to fit.
1907   Drive specifier is invalid.
1908   Length or decimal place argument is invalid.
1909   Cannot update project from project metafile.
1910   Illegal printer driver recursion.
1911   Localized product is required for this environment.
1912   Operation is invalid for a General field.
1913   Field must be a General field.
1914   Code page number is invalid.
1915   Collating sequence "name" is not found.
1916   To use this feature, set CODEPAGE=AUTO in your CONFIG.FPW file and restart Visual FoxPro.
1917   Script error: "name".
1918   File name is too long.
1919   Objects cannot be programmatically deleted from the Class Designer.
1922   Volume does not exist.
1923   Object "name" is not found.
1924   "name" is not an object.
1925   Unknown member "name".
1926   Cannot nest class definitions.
1927   Statement is not valid in a class definition.
1928   Statement is only valid within a class definition.
1929   "name" can only be used within a method.
1930   Cannot redefine "name".
1931   Statement is not in a procedure.
1932   "name" cannot be closed while suspended.
1933   File "name" is not closed.
1934   Statement only valid within a method.
1935   The current object does not inherit from class "name".
1936   Application object not initialized.
1937   Procedure file "name" is not found.
1938   Object is not contained in a "name".
1939   WITH/ENDWITH mismatch.
1940   Expression is not valid outside of WITH/ENDWITH.
1941   Error code is not valid.
1942   Objects cannot be assigned to arrays.
1943   Member "name" does not evaluate to an object.
1944   Cannot find the builder program.
1945   The current object has been released.
1946   Project file "name" is in the wrong version.
1947   Expression is too complex.
1948   Cannot modify a class that is in use.
1949   Class name is invalid.
1950   Class definition "name" is recursive.
1951   Cannot clear the object "object" because it is in use.
1952   Cannot base a view on itself.
1953   Feature is only available if the object is in design mode.
1954   The builder program is already running.
1955   WIN.INI/registry is corrupted.
1956   Printer access denied.
1957   Error accessing printer spooler.
1958   Error loading printer driver.
1959   Invalid coordinates.
1960   Illegal redefinition of variable "name".
1961   A subdirectory or file "name" already exists.
1962   The directory is not empty.
1963   Directory is not found.
1964   No PageFrame or Page is found in FormSet or Form with WindowType set to READ or READ MODAL.
1965   One of the members of this class is based on a nonvisual class. Cannot write .VCX file.
1966   Data environment is already loaded.
1967   Data environment is already unloaded.
1968   One of the members of this Form or FormSet is based on a nonvisual class. Cannot write .SCX file.
1969   The clipboard contained one or more objects that could not be added to the container. Those objects were not pasted.
1970   Cannot reopen project file "name".
1971   Cannot compile until the current COMPILE command has completed.
1972   Array "name" is in use.
1973   Error creating table: "name".
1974   Arrays cannot be assigned to array elements.
1975   Member object "name" has not been instantiated.
1976   Cannot resolve backlink.
1977   Exclusive open required to update this file. Please reopen.
1978   Cannot visually modify a class of this type.
1979   Cannot visually modify a class based on a nonvisual class.
1981   Compile error in file "name".
1982   The TO clause can only be used with modal Forms and FormSets.
1983   "name" objects cannot return a value.
1984   The fields in table '"name"' did not match the entries in the database.
1985   Object already has a data environment; cannot use another one with the SaveAs method.
1986   GDI memory is low, close one or more windows and try again.
1987   Objects cannot be programmatically added to the Form Designer's FormSet.
1988   Currency value is out of range.
1989   Objects cannot be programmatically deleted from the Form Designer.
1991   Form file "name" is from a previous version of FoxPro. It must be converted to the current format before it can be executed.
1992   "name" is not a function, procedure or program.
1993   Class library file "name" is not found.
1994   Include file "name" is not found.
1995   Error loading the data environment. Table is in use.
1996   The validation rule for field "name" does not evaluate to a logical or NULL type.
1997   The default value for field "name" does not evaluate to the correct type for the field.
1998   The index expression for index "name" contains an invalid reference to a Memo, General, or Picture field.
1999   Function is not implemented.
2000   Memory is low, so streaming output updating has been disabled.
2001   The name of the object file for "file" is already used by another program in the project.
2002   Cannot build a DLL without OLE public classes.
2003   OLE Changed Properties stream is the wrong version. Subclassed properties ignored.
2004   The table file "name" has moved. Please validate database "name" and try again.
2005   Error with "name" - "property": "error".
2006   Cannot locate your Web browser.
2007   Invalid operation for offline view while offline.
2008   Invalid operation for offline view while being used online.
2009   Object is not an offline view.
2010   Offline views must be used exclusively when being used online.
2011   Invalid operation for offline view.
2012   Cannot call SetFocus from within a When, Valid, RangeHigh or RangeLow event.
2013   Cannot open persistent table buffer directly.
2014   Fields marked as update keys will be cleared.
2015   Offline view must be used online for this command
2016   Removing a class member is not allowed.
2017   Cannot reuse offline view in different mode.
2018   Reconnect of offline view failed.
2019   Cannot create offline view on a currently modified view.
2020   The class file associated with this field cannot be found – class association cleared.
2021   The DataObject cannot be modified in the OLEDragOver or OLEDragDrop event.
2022   The specified file or path was not found.
2023   There is no application associated with the given filename extension.
2024   A sharing violation occurred.
2025   The SQL Statement is too complex for the View/Query Designer.
2026   Invalid locale ID.
2027   Declare DLL call caused an exception.
2028   API call caused an exception.
2029   Class "name" is not a Form class.
2030   Cannot delete file "name".
2031   User-interface operation not allowed at this time.
2032   Ambiguous date/datetime constant.
2033   CTOD and CTOT can produce incorrect results.
2034   Date/datetime evaluated to an invalid value.
2035   Date/datetime contains illegal characters.
2036   The current Help file is empty.
2038   Microsoft Visual FoxPro doesn't support and cannot open this format of recordset.
2039   Failed to create recordset.
2040   Field mismatch.
2041   Recordset does not exist.
2042   Foxcode table not found, is not correct version or is incompatible.
2043   Foxcode script "name" failure.
2044   Textmerge is recursive.
2045   Cannot set DBCEventFile property when DBCEvents is off.
2046   Foxtask table is corrupted or not the correct version.
2047   Invalid character entered.
2048   Invalid COMATTRIB value for "name".
2049   Error loading HtmlHelp 2.0 collection.
2050   Help for this topic/context not implemented.
2051   Menu item's conditional statement is too long.
2052   OrderBy clause is too long.
2053   GroupBy clause is too long.
2054   Cannot release object.
2055   Query Parse Error - Try rebuilding in Query Wizard or by using View Designer Join Tab.
2056   The specified member class does not exist or is of wrong type.
2057   The specified class library does not exist or does not contain a valid member class.
2058   TRY/CATCH/FINALLY/ENDTRY mismatch or error.
2059   Unhandled Structured Exception.
2060   RETURN/RETRY statement not allowed in TRY/CATCH.
2061   Index or expression does not match an existing member of the collection.
2062   The specified Key already exists.
2063   A Key must be specified when adding an item to this collection.
2064   A Key cannot be specified when adding an item to this collection.
2065   Table "name" has a file length / record number inconsistency.
2066   Index file "file" is corrupted. Please rebuild it.
2067   Cursor "name" does not have a valid table or view reference.
2068   Data environment "name" does not contain a cursor object.
2069   Forms or Form classes that specify a DEClass and DEClassLibrary cannot be converted to or used with a FormSet.
2070   Cannot assign a class value to this member.
2071   User Thrown Error.
2072   Cursor cannot be modified because it contains an unsaved.
2073   Cannot change MemberClass because existing member objects have outstanding references.
2074   Result is incompatible with cursor schema.
2075   CursorSchema property is not specified.
2076   Operation is not allowed for CursorAdapter.
2077   Operation is not allowed for CursorAdapter at this time.
2078   CursorAdapter "name" cannot be loaded for design.
2079   Cannot close or detach extended cursor because it is currently in design mode.
2080   ADODB.Recordset is already opened.
2081   ADODB.Command is already opened.
2082   Cannot update ADODB.Recordset while cursor, created by CursorAdapter.CursorFill method, is not attached to a CursorAdapter object.
2083   Cannot update ADODB.Recordset because it is read-only.
2084   Cannot update ADODB.Recordset because it does not support a Bookmark property.
2085   Cannot update ADODB.Recordset because FOX cursor does not have an ADOBookmark column.
2086   DEClass cannot be loaded.
2087   Window "name" is not a dockable window. (Error 2087)
2088   Field "name" is read-only.
2089   The "name" event has failed.
2090   CursorAdapter does not have an associated cursor.
2091   Table "name" has become corrupted. The table will need to be repaired before using again.
2092   CursorAdapter cannot locate current record in the buffer. The record may have been reverted.
2093   Syntax error: "name" is not allowed in the view script or is in the wrong place.
2094   XML Schema is too complex.
2095   XMLTable object does not have associated XMLAdapter object.
2096   XML document is not loaded.
2097   XMLTable object does not have associated fields.
2098   Invalid element in XMLTable.Fields collection.
2099   Value of XMLTable.XMLName must be used as key value for collection.
2100   Value of XMLField.XMLName must be used as key value for collection.
2101   Unable to attach object with empty XMLName property.
2102   Unable to change XMLName property while XMLTable object belongs to XMLAdapter object.
2103   Unable to change XMLName property while XMLField object belongs to XMLTable object.
2104   There is a duplicate table "name" in XML schema.
2105   There is a duplicate field "name" in XML schema.
2107   XMLAdapter.ToXML cannot be called while there is a loaded XML document.
2108   XMLTable.Alias is empty.
2109   XMLTable has child table.
2110   XML Error: "error"
2112   Cursor "name" is attached to another CursorAdapter object.
2116   This feature requires MSXML4 SP1 or later.
2118   XMLAdapter: fractionDigits must not be greater than or equal to maxLength.
2120   Unable to infer XML schema.
2121   Unable to open offline view in ADMIN/ONLINE mode inside a transaction.
2122   Unable to close offline view in ADMIN/ONLINE mode inside a transaction.
2123   Unable to set external schema location when inline schema is used.
2124   XML document does not have a root element.
2125   CursorAdapter and XMLTable objects do not belong to the same data session.
2126   XML document is not a DiffGram.
2127   XMLAdapter.XMLName is empty.
2128   XML node does not belong to MSXML4.DOMDocument.
2129   XMLAdapter object doesn't have associated tables.
2130   XMLTable object with XMLName "name" does not have associated fields.
2131   TEXT does not have corresponding ENDTEXT statement
2132   XMLTable object already has parent or is associated with XMLAdapter object.
2133   Unable to emit XML, two or more cursors use different code pages.
2134   Value of XMLName, XMLNamespace or XMLPrefix property should be a Unicode string.
2135   Conversion to Unicode has failed.
2136   Conversion from Unicode has failed.
2137   Vfp.VFPXMLProgId doesn't support cSchemaLocation parameter for XMLUpdateGram().
2138   CursorAdapter is unable to determine DataSourceType for the operation.
2139   SelectCmd is empty.
2140   Both Unicode and IsBinary properties can not be set to .T..
2141   Field size for Unicode value can not be odd number.
2142   Field for Unicode value should not use code page translation.
2143   ADODB.Recordset is not opened.
2144   XMLField object is already associated with XMLTable object.
2145   Property "name" has invalid value.
2146   Invalid key column name "name".
2147   Calling OpenTables or CloseTables is not allowed while either of those methods are in the process of executing.
2148   SQL: The ORDER BY clause is invalid in subqueries, unless TOP is also specified
2149   SQL: Invalid SET expression in UPDATE, "table name" is not a target table
2150   SQL: Table for UPDATE or DELETE cannot be outer joined
2151   SQL: Cannot UPDATE or DELETE from subquery
2152   The Dockable property cannot be enabled possibly due to conflicting properties
2153   Invalid collate sequence
2154   Unknown member object "object name"
2155   Number of affected rows is not available
2156   Invalid index expression for a Binary index
2157   Filter expression is not allowed for a Binary index
2158   Unable to locate target record in ADODB.Recordset
2159   Unable to cast NULL value to a NOT NULL data type
2160   Invalid timestamp column name "column name"
2161   Invalid Insert refresh column name "column name"
2162   Invalid Insert refresh key column name "column name"
2163   Invalid Update refresh column name "column name"
2164   Invalid Update refresh key column name "column name"
2165   The refresh key defined for table "table name" is not unique
2166   The refresh key defined for table "table name" is not found
2167   Source field for refresh is not found
2168   Invalid data source type for RecordRefresh operation
2169   Cannot refresh record from ADODB.Recordset because it does not support a Bookmark property
2170   Cannot refresh record from ADODB.Recordset because FOX cursor does not have an ADOBookmark column
2171   Invalid refresh ignore column name "column name"
2172   Field "field name" is not fetched
2173   Cursor "cursor name" is in use and cannot be closed
2174   Field "field name" is not associated with a base table
2175   CursorAdapter internal error
2176   Connection "connection name" is in manual commit mode
2177   Inner and outer XMLTable objects are not associated with the same XMLAdapter object
2178   There is no relation to the nested table "table name".
2179   Nested XML format is incompatible with 'Changes Only'
2180   XMLAdapter XMLName property is an XPath expression
2181   XMLTable XMLName property is an XPath expression
2182   XMLName property contains illegal symbol(s)
2183   Operation requires that SET MULTILOCKS is set to ON
2184   Code page for the field "field name" doesn't match cursor's code page
2185   Unable to infer cursor's code page from XML document
2186   Error building sort key
2187   Recursive XMLTable nesting is not allowed
2188   Cursor doesn't support ADOBookmark property
2189   SQL: Too many fields in final or intermediate result have the same name
2190   FontCharSet number is invalid
2191   File is in use in another data session
2192   Illegal operation for a table with pending changes
2193   Illegal operation in rule evaluation
2194   Output page "page" is not available
2195   The cursor is already associated with a record set
2196   Only single SQL SELECT statement can be enclosed in parenthesis
2197   Property "property name" value is too long
2198   Index tag is not found for Cursor object "cursor name"
2199   Error building key for index "name".
2200   Index "name" is in use and cannot be closed
2201   Cannot determine data type of the expression

Offline davidmustakim

  • Fox-id M.V.P
  • Hero Member
  • *
  • Posts: 13.597
  • Awas ya...
Re: Kontrol Kesalahan / error
« Reply #1 on: February 19, 2013, 06:46:17 PM »
kekurangannya? : text kesalahan yang ditampilkan dalam messagebox itu SEHARUSNYA JUGA DIREKAM kedalam sebuah file (bisa text atau dbf dengan field memo)

Offline rifox

  • Junior Member
  • *
  • Posts: 139
Re: Kontrol Kesalahan / error
« Reply #2 on: February 19, 2013, 07:25:50 PM »
@ Om David

Setuju... :thumbsup:
« Last Edit: February 20, 2013, 12:08:55 AM by rifox »

Offline davidmustakim

  • Fox-id M.V.P
  • Hero Member
  • *
  • Posts: 13.597
  • Awas ya...
Re: Kontrol Kesalahan / error
« Reply #3 on: February 19, 2013, 10:47:17 PM »
Saya malah baru perhatikan lagi bahwa sampel koding check error tadi tidak menyertakan contoh cara menggunakannya (misalnya dengan command ON ERROR DO WITH parameterNomorErrorYangPenting dan bla bla bla...) dan juga tidak memberikan contoh bagaima mengechecknya terhadap tabel daftar kesalahan berdasarkan nomor errornya.... Wahhhhh, gimana tuh, jadi masih error kekurangan gizi dong tuh ah uh sampelnya... bagusnya sih udah usaha, tapi memang perlu lebih teliti Mas Bro

Offline arietsh

  • Junior Member
  • *
  • Posts: 111
Re: Kontrol Kesalahan / error
« Reply #4 on: February 20, 2013, 09:48:17 AM »
Ikut menyimak...
Kalo berkenan... ajarin newbie dong cara menggunakan / menempelkan prosedure errornya..
Trims.

Offline davidmustakim

  • Fox-id M.V.P
  • Hero Member
  • *
  • Posts: 13.597
  • Awas ya...
Re: Kontrol Kesalahan / error
« Reply #5 on: February 20, 2013, 09:54:52 AM »
Ikut menyimak...
Kalo berkenan... ajarin newbie dong cara menggunakan / menempelkan prosedure errornya..
Trims.
http://www.sweetpotatosoftware.com/spsblog/2008/11/24/ProfessionalErrorHandlingForVFPApplications.aspx