da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Cannot specify indexname

Forum List » ThinDAC » General English

GSoares
User

Fresh Boarder

Posts: 4

Karma: 0

Cannot specify indexname

Posted: 2007/04/26 07:06

Hi

I made some tests and get an error on folowing condictions:

server using thindac server components + anydac with connection string for mysql local server

on client using thindac client comp when trying to specify an index the error reported is "[AnyDAC][DatS]-2. Object with name [DM_GUID] is not found.

I am also using an integer (no autoinc) as primary key and when using the client->updateoptions->updatemode=upWhereKeyOnly it does not update the table (i don't know if this 2 problems are related)

versions are:
mySQL = 4.1.20
thindac = 1.3.0
AnyDAC = 1.12.2
RealThinClient_SDK = 2.63
Delphi = 7.0

Thanks on advance

Diman

Admin

Posts: 1482

Karma: 19

Re:Cannot specify indexname

Posted: 2007/04/26 07:15

Hello

on client using thindac client comp when trying to specify an index the error reported is "[AnyDAC][DatS]-2. Object with name [DM_GUID] is not found.
Most probably, you specified DM_GUID as one of index fields and it does not exists in dataset. Please, check that.

I am also using an integer (no autoinc) as primary key and when using the client->updateoptions->updatemode=upWhereKeyOnly it does not update the table (i don't know if this 2 problems are related)
And what happens ? Any error message or what else ? And how you check, that table is or is not updated ?

Regards,
Dmitry

GSoares
User

Fresh Boarder

Posts: 4

Karma: 0

Re:Cannot specify indexname

Posted: 2007/04/26 08:09

The table has 2 indexes

PRIMARY - field DM_GUID
DM_GUID - field DM_GUID

the DM_GUID field is VarChar 36

------

When made a post changing only one field and using client->updateoptions->updatemode=upWhereKeyOnly then error given is the following:

"Update command changed 0 records, but must update only single record"

Regards

Guilherme

Forum List » ThinDAC » General English