Refresh the TSQLTableToGrid not updated External BD

ubaltino · 2014-06-03 11:27:49

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?

ab · 2014-06-04 07:47:26

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

ubaltino · 2014-06-04 10:40:05

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

ab · 2014-06-04 12:46:27

I will check what's up here.

mORMot Open Source

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

Refresh the TSQLTableToGrid not updated External BD

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

Re: Refresh the TSQLTableToGrid not updated External BD

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

Re: Refresh the TSQLTableToGrid not updated External BD

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

Re: Refresh the TSQLTableToGrid not updated External BD

Board footer