#1 2014-06-03 11:27:49

ubaltino
Member
From: Brasil
Registered: 2014-05-23
Posts: 24
Website

Refresh the TSQLTableToGrid not updated External BD

Making testing programs, I noticed that the TSQLTableToGrid.Refresh procedure updates only using SQLite3. With External BD does not work. I did tests with PostgreSQL and Firebird.

Am I mistaken in which case I have to call refresh before algomo as CreateAndFillPrepare?

That would be the best way?


Ubaltino Faleiro
www.sistemainteligente.com
Brasil - Goiás - Goiânia

Offline

#2 2014-06-04 07:47:26

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,167
Website

Re: Refresh the TSQLTableToGrid not updated External BD

Are the modifications made from mORMot ORM?
Modifications made directly in SQL at PostgreSQL or Firebird level won't be tracked.

Offline

#3 2014-06-04 10:40:05

ubaltino
Member
From: Brasil
Registered: 2014-05-23
Posts: 24
Website

Re: Refresh the TSQLTableToGrid not updated External BD

I think I could not explain.

     GridPerson: TDrawGrid;     
     Grid: TSQLTableToGrid;

    Grid: = TSQLTableToGrid.Create (GridPerson, Person.FillTable, BaseDados);

BaseDados.Add (Person, true)
Grid.Refresh;
- Using SQLite3 is the acts GridPerson
- And using PostgreSQL or Firebird (Bd via external FireDAC) do not reflect changes in GridPessoas.

Am I doing anything?
Will have to call
     Person: = TSQLPerson.CreateAndFillPrepare (BaseDados, 'id> 0');
Refresh before?

thank you


Ubaltino Faleiro
www.sistemainteligente.com
Brasil - Goiás - Goiânia

Offline

#4 2014-06-04 12:46:27

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,167
Website

Re: Refresh the TSQLTableToGrid not updated External BD

I will check what's up here.

Offline

Board footer

Powered by FluxBB