Re: Delete record in batch mode

and if i write something like this :

'SELECT OrdPro_Art.* FROM OrdPro_Art WHERE Progressivo IN (SELECT
Progressivo FROM OrdPro WHERE OrdPro.Concluso >= 0)';


i think go fine ? because i think the problem is the JOIN .... but the qry
became slow ?

BYE

--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it
"Cavalera Guido" <cavaleraguido@xxxxxxxxxxxx> ha scritto nel messaggio
news:465b25e9$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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
    ... but in ms-access all go fine! ... Soluzioni Software di Gestione Aziendale ... 'row cannot be located for updating ...' ...
    (borland.public.delphi.database.ado)
  • Re: Delete record in batch mode
    ... cannot be located for updating ...' ... the adodataset are recovered by a joined qry like this: ... Soluzioni Software di Gestione Aziendale ...
    (borland.public.delphi.database.ado)