Re: Local dataset show parts in two grids

How about using clone of original ADODataSet with properly assined filter
for each grid. Please note that changes made from ADODataSet became visible
for clones only upon posting.
"Dave Blake" <barnswood@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:42e12043$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> I have a batch optimistic locked ADOdataset being edited locally (client
> cursor), and I want to display some of the records in one DBGrid and the
> other in a second DBGrid depending on the value in one of the fields. The
> field values are edited in separate DBEdit controls, not the grids which
are
> just for display purposes, but these values change the way the grid cells
> are drawn.
>
> I'm sure I am being thick, but how do I do that?
>
> All my attempts so far either fail to see the locally edited values or
> requery the dataset loosing the batch optimistic edits.
>
> Dave
>
>


.

Relevant Pages

  • Re: VB6 - Delete From DataGrid - Deletes the Wrong Record
    ... I have a datagrid that is bound to a recordset in a SQL 2000 database. ... If you want to do it yourself anyway, you'll need to keep or create a clone ... the clone to the bookmark property of the grid, and then act on the clone. ... Set rsClone = ADODC1.recordset.Clone ...
    (microsoft.public.vb.database.ado)
  • Ado and Client Datasets
    ... Everything is linked and seems to work great with a standard SQL Statement ... I know its not the stored procedure, ... returned to the AdoDataset, but never seem to make it the rest of the way ... grid is filled perfectly. ...
    (borland.public.delphi.database.ado)
  • Re: View updated data in recordset
    ... I have a grid that has the datasource bind to a recordset. ... When I use the goRs add a new record, I can see the record immediated ... The best way I know of is to use a clone of the recordset that's bound to ... You can then use the grid's bookmark property to position the ...
    (microsoft.public.vb.controls)
  • How to resolve Could not convert variant of type (Null) to type (String)?
    ... I am using ADODataset and DBGrid in my application. ... At first filling ... the data in Grid with ADODataset. ... some records using loop statement. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Local dataset show parts in two grids
    ... > How about using clone of original ADODataSet with properly assined filter ... > for each grid. ... And can I get it so that cursor movement within the ...
    (borland.public.delphi.database.ado)