Mostrar todos los registros de un select * from con un FDQuery

[[AgustinOrtu]]

Revisando la documentacion:

FireDAC is fetching rowsets according to the FetchOptions.Mode property:
fmOnDemand--the rowset is automatically fetched when the dataset is trying to move the current position beyond the last fetched record.
fmAll--all the rowsets are automatically fetched right after executing the SQL command. This is similar to calling the FetchAll method.
fmManual--the programmer manually fetches the rowsets using the FetchNext or FetchAll methods.
fmExactRecsMax--all rowsets are automatically fetched right after executing the SQL command. If the number of rows is different from FetchOptions.RecsMax, an exception is raised.

Otra opcion es llamar al metodo FetchAll