Re: row could not be located for updating

[Angelin Lalev]

I did RTFM and found that this is well known problem:
ADO (and probably BDE) do not support
BIGINT and probably other non-standard data types.
I've changed all non-standard data types in my table with
SQL92/99 datatypes and my table now looks like this:

CREATE TABLE POTREBITELI (
ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
PSEVDONIM CHAR(12) NOT NULL,
IME CHAR(30) NOT NULL,
PRIVILEGII INTEGER UNSIGNED NOT NULL,
DOBAVEN_OT INTEGER UNSIGNED NULL,
DOBAVEN_DATA DATETIME NOT NULL,
AKTIVEN BIT(1) NOT NULL,
DE_TIMESTAMP TIMESTAMP NULL,
DE_OPERATOR INT UNSIGNED NOT NULL,
DE_VERSIJA NUMERIC(5,2) NOT NULL,
DE_HASH CHAR(25) NULL,
PRIMARY KEY(ID)
);

Altough no error appears this time, the CHAR fields are stil filled up
with spaces to their full length, 'Pad char to full length' option of the
ODBC connection is not checked.