Tema: errores SQL
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 24/04/2003, 10:24
tarlipes
 
Fecha de Ingreso: diciembre-2002
Ubicación: argentina... de ahí seran veinte cuadras
Mensajes: 382
Antigüedad: 21 años, 11 meses
Puntos: 0
errores SQL

Algo que puede ayudar:

The following table shows the types of SQL errors that you may encounter.

Constant---------------- Value -------------Explanation

DB_E_BADBOOKMARK 80040E0E Invalid bookmark.

DB_E_BADCOLUMNID 80040E11 A specified column did not exist. The error string should contain the erroneous field name.

DB_E_CANTCONVERTVALUE 80040E07 A literal value in the command text cannot be converted to the type of the associated column for reasons other than data overflow. The error string should contain the offending constant.

DB_E_CANTFETCHBACKWARDS 80040E24 A forward only cursor cannot read backwards.

DB_E_DATAFIELD_OVERFLOW 80040E21 OLE DB Specific:
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

DB_E_DATAOVERFLOW 80040E57 CEDB Specific:
A literal value in the command text could not be stored in the type specified by the associated column.

DB_E_DELETEDROW 80040E23 Row is deleted.

DB_E_DUPLICATECOLUMNID 80040E3E A field name is identical in two or more elements.

DB_E_DUPLICATEINDEXID 80040E34 The specified index already exists in the current data source object.

DB_E_DUPLICATETABLEID 80040E3F The specified table already exists in the current data source.

DB_E_ERRORSINCOMMAND 80040E14 The command text contained one or more errors— typically a syntax error or unexpected keyword. The error string should contain the unexpected token.

DB_E_FIELDDIFFERENT 80040E41 Two fields of different type were compared.

DB_E_FIELDMAXEXCEED 80040E42 An attempt was made to use more columns than are allowed per table.

DB_E_JOINNEEDINDEX 80040E40 Using an INNER JOIN statement with multiple tables requires that at least one of the tables is indexed on the joined terms.

DB_E_NOCOMMAND 80040E0C No command is set.

DB_E_NOINDEX 80040E35 The specified index does not exist in the current data source or does not apply to the specified table.

DB_E_NOTABLE 80040E37 The specified table does not exist. The error string should contain the table name.
.
E_OUTOFMEMORY 8007000E Out of memory.


esto está en:
http://msdn.microsoft.com/library/de...o30ref_103.asp
__________________
Juan Pablo