Re: Query based on the results of another query?

You cannot perform a select on an open TADODataSet. Running the query
again should not cause a performance problem unless the query returns a
large number of records and, since the user is working with the
records, I assume that the number of records is small.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: performance problem getting WMI "HostName" propertie
    ... you can use MSBTS_HOST class to query the host name... ... I need to recover "HostName" from ... Dim m_mpGroupSettings1.Count) As ... Due to it I have a performance problem in this pipeline. ...
    (microsoft.public.biztalk.general)
  • Re: Date/time range in query
    ... > With using a query on the table layout I have a performance problem: ... > table and when the timeframe is between the minimum and maximum timestamp. ... > Does anybody have some ideas how to improve the table layout / query to ...
    (microsoft.public.sqlserver.programming)
  • Re: performance-problem with views
    ... I've a strange performance problem. ... Because of this similarity I have somtimes to query the data in one of the two tables, somtimes I have to query the data in both tables. ...
    (comp.databases.oracle.misc)
  • Re: performance problem getting WMI "HostName" propertie
    ... New ManagementObjectSearcher(New WqlObjectQuery("SELECT HostName FROM ... you can use MSBTS_HOST class to query the host name... ... Dim m_mpGroupSettings1.Count) As ... Due to it I have a performance problem in this pipeline. ...
    (microsoft.public.biztalk.general)
  • Re: performance problem getting WMI "HostName" propertie
    ... You can also identify the fields you want in the Select query. ... New ManagementObjectSearcher(New WqlObjectQuery("SELECT HostName FROM ... Dim m_mpGroupSettings1.Count) As ... Due to it I have a performance problem in this pipeline. ...
    (microsoft.public.biztalk.general)