Re: Bug with ADORecordSet.Update

> -----Original Message-----
> From: Keith Gray
>
> The "bug" is when I update the table
> (described below) all fields with a common "OwnerID" get updated
> simultaneously. OwnerID is used to cascade Ledger sub accounts.
>
> CREATE TABLE GeneralLedger (
>         AccountSequence integer,
>         AccountLevel integer,
>         AccountFunction integer,
>         Movement varchar(1),
>         Postings varchar(1),
>         AccountCode varchar(10),
>         OwnerID integer,
>         Description varchar(255),
>         OBalPer0 float,
>         PBalPer0 float,
>         CBalPer0 float,
>         OBalPer1 float,
>         PBalPer1 float,
>         CBalPer1 float,
>         OBalPer2 float,
>         PBalPer2 float,
>         CBalPer2 float,
>         OBalPer3 float,
>         PBalPer3 float,
>         CBalPer3 float
> )
>
> ...in VB
>
>
> Do While mLevel <> 2
>     SQL = "SELECT CBalPer0, PBalPer0, OwnerID FROM GeneralLedger " & _
>           "WHERE AccountSequence=" & Cstr(mLevel)
>     Set Rec = OpenDynamic(SQL)
>     mLevel = Rec!OwnerID
>     Rec!PBalPer0 = Rec!PBalPer0 + Amount
>     Rec!cBalPer0 = Rec!cBalPer0 + Amount
>     Rec.Update
>   Loop
> End Sub
>
> ...for now I fixed this by
>
> "SELECT * FROM GeneralLedger WHERE AccountSequence=" & Cstr(mLevel)
>
> Is this a known bug?
> Is it caused by no cursor control?

Maybe.
You seem to have to specify items so that they distiguish individual rows.

regards,
Hiroshi Inoue