Data Environment Refresh

[RichardL]

I have a Hierarchical flex grid bound to a data environment (pause for hysterical
laughter). The DE is bound to an Access database (pause for additional hysterical
laughter).

When I delete from the table which is bound to the DE, how do I refresh the
data in the grid?

I am deleting using an unrelated ADO Connection connected to the same database,
since depending on where I am in the grid, I would delete from different
tables.

[Duane Snelling]

Richard,
That is your problem. If you make changes you need to do it with recordset
that is part of the dataevironment, not a different connection. The data
environment loads the data at startup from the database. If you make a change
to the database its self through another ADO connection, you will not see
the changes in the dataenvironment until you reload it.

Here is some sample code connect to the recordset in the dataenvironment.


dim dbe as dataenvironment
dim rsC as recordset
set dbe = new dataenvironment1
Set rsC = dbe.rsCommand1
dbe.rsCommand1.Open "select * from TableName", dbe.Connection1, adOpenStatic,
adLockOptimistic


hope this helps
Duane...

"RichardL" <richardl@astralc.com> wrote:
>
>I have a Hierarchical flex grid bound to a data environment (pause for hysterical
>laughter). The DE is bound to an Access database (pause for additional
hysterical
>laughter).
>
>When I delete from the table which is bound to the DE, how do I refresh
the
>data in the grid?
>
>I am deleting using an unrelated ADO Connection connected to the same database,
>since depending on where I am in the grid, I would delete from different
>tables.
>
>