Suggestion of new component: Small Query

eduardosic · Post by **eduardosic** » Mon 26 May 2008 20:54

Hi CoreLab.

I have a Suggestion of a new component, the small query.

it would be capable to execute commands SQL and only to show the data.

no lookup, no events for field's, no calculated Field's, only Show data... and Fields Editor..

seemed with TMyMetaData.

ok?

johnkuiper · Post by **johnkuiper** » Tue 27 May 2008 10:13

Isn't that just using the readonly property?

eduardosic · Post by **eduardosic** » Tue 27 May 2008 11:15

johnkuiper wrote:Isn't that just using the readonly property?

I thought internally about a simpler and lesser component that the TMyQuery for being simpler he would execute the Select more fastest.

Dimon · Post by **Dimon** » Thu 29 May 2008 07:36

If you don't determine the lookup and calculated fields in TMyQuery and use only SELECT query, the TMyQuery component work as fast as possible.
To increase perfomance you can use the FetchAll and UniDirectional properties.

eduardosic · Post by **eduardosic** » Thu 29 May 2008 11:19

Dimon wrote:If you don't determine the lookup and calculated fields in TMyQuery and use only SELECT query, the TMyQuery component work as fast as possible.
To increase perfomance you can use the FetchAll and UniDirectional properties.

Thank's Dimon.