Re: Delete record in batch mode



when i try to delete detail records and then updatebacth i've error 'row
cannot be located for updating ...'

i,ve discovered why but i dont have a solution for that ... the records in
the adodataset are recovered by a joined qry like this : SELECT OrdPro_Art.*
FROM OrdPro_Art LEFT JOIN OrdPro ON OrdPro.Progressivo =
OrdPro_Art.Progressivo WHERE %s',['OrdPro.Concluso = 0']);

....But in insert and update all fine, while in DELETE i.ve an error 'row
cannot be located for updating ...'

WHY ? help me please !

tank u very in advance ...

BYE


--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it
"Cavalera Guido" <cavaleraguido@xxxxxxxxxxxx> ha scritto nel messaggio
news:465aa8e2$1@xxxxxxxxxxxxxxxxxxxxxxxxx
D2006+SQLExpress with table relation+ADODataset with updatecriteria =
criteriakey

when i try to delete detail records and then updatebacth i've error 'row
cannot be located for updating ...'

can u help me ?

BYE


--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it



.



Relevant Pages

  • Re: Delete record in batch mode
    ... 'SELECT OrdPro_Art.* FROM OrdPro_Art WHERE Progressivo IN (SELECT ... Soluzioni Software di Gestione Aziendale ... cannot be located for updating ...' ...
    (borland.public.delphi.database.ado)
  • Re: Delete record in batch mode
    ... but in ms-access all go fine! ... Soluzioni Software di Gestione Aziendale ... 'row cannot be located for updating ...' ...
    (borland.public.delphi.database.ado)
  • MSSQL->ADO->DSP->CDS and back
    ... I am getting data from the clientdata sets, updating it ... on the ADODataset. ... Brad White ...
    (borland.public.delphi.database.ado)