Re: Delete record in batch mode





Which is the detail table?

In the beforeDelete event set the Unique table property

ADODataSet.Properties['Unique Table'].Value:='Name of a table';


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

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.



Relevant Pages

  • Re: strange behaviour using arrays to update records
    ... I dont get any errors now but the ... records are not updating. ... follow its suggestion for not displaying it as I dont think I can alter any ... You need to iterate through your arrays and call addslashes on each ...
    (comp.lang.php)
  • Re: stock brocking web application
    ... notify the presentation layer when a change occurs and update the ... dont know JavaSpace probably now is the time to have a look. ... row in a table rather than updating whole table... ...
    (comp.lang.java.programmer)
  • Re: [Full-Disclosure] EEYE: Microsoft ASN.1 Library Length Overflow Heap Corruption
    ... there is a problem with that because most Microsoft patches are ... updating a dll. ... So if your are not looking for both you dont have an ...
    (Full-Disclosure)
  • Re: Shopping Cart not updating until refresh
    ... i dont think i have explained my problem.. ... or updating the quantity field of an existing ... When i press refresh, it ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Serial
    ... > tks for the reply. ... > I am trying talking to HP but they dont make a lot of sense. ... > adapter cards are properly seated in their slots. ... try updating the driver for that device from the Device Manager ...
    (microsoft.public.windowsxp.general)