How to refresh unidbgrid data?

[Guest]

Message from: "goodeboy"

 

Add data, how to refresh the data displayed unidbgrid? Thanks.

 

 

.

 

[Guest]

Message from: "Farshad Mohajeri"

 

"goodeboy" wrote in message

news:wUmbOJq7LHA.1984@anaxagvs227...

> Add data, how to refresh the data displayed unidbgrid? Thanks.

 

You can call DataSet.Refresh()

 

 

.

 

[Guest]

Message from: "goodeboy"

 

DataSet.Refresh()

 

or

 

DataSet.close;

DateSet.open;

 

unidbgrid not refresh,why?

 

code list:

 

adoquery1.Connection:=con1;

DataSource1.dataset:=adoquery1;

unidbgrid.DataSource:=DataSource1;

adoquery1.close;

adoquery1.sql.clear;

adoquery1.sql.text:='select * from datalist';

adoquery1.open;

 

 

now add new data code list:

 

con2.Execute('insert into datalist (field1,field2) values(''aa'',''bb'')');

adoquery1.close;

adoquery1.open;

adoquery1.Refresh;

 

but unidbgrid data not refresh

 

why? Thanks!

 

 

 

.

 

[Guest]

Message from: "Farshad Mohajeri"

 

"goodeboy" wrote in message

news:KeSE1Xv7LHA.3152@anaxagvs227...

> DataSet.Refresh()

>

> or

>

> DataSet.close;

> DateSet.open;

>

> unidbgrid not refresh,why?

>

> code list:

>

> adoquery1.Connection:=con1;

> DataSource1.dataset:=adoquery1;

> unidbgrid.DataSource:=DataSource1;

> adoquery1.close;

> adoquery1.sql.clear;

> adoquery1.sql.text:='select * from datalist';

> adoquery1.open;

>

>

> now add new data code list:

>

> con2.Execute('insert into datalist (field1,field2)

> values(''aa'',''bb'')');

> adoquery1.close;

> adoquery1.open;

> adoquery1.Refresh;

>

> but unidbgrid data not refresh

 

It is not a uniGUI problem. Actually you don't need to call resfresh.

 

This should be enough:

 

adoquery1.open;

adoquery1.Refresh;

 

Are you sure your dataset is refreshed? Also tested in VCL mode?

It seems you use a secondary AdoConnection to insert data.

 

 

.