Re: ADODataset and recordCount

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 08/14/04

  • Next message: George Kvasha: "ALTER COLUMN" 
    Date: Fri, 13 Aug 2004 18:04:58 -0500

    >So I am wondering if this is a bug, or just some behaviour that I am not
    >fully understanding - which is why I am writing the performance test app
    >in the first place.
    Not a bug. That is how it works with most dataset components.
    >
    >I kinda made the assumption that the code behind recordCount is doing
    >some sort of select count(*) from ... to get the answer, but I haven't
    >actually checked this yet.
    >
    >Which raises another question... With dbExpress i can use the SQLMonitor
    >to see what SQL is being passed to the backend (very handy, thank you
    >Borland). How can I achieve the same with ADO?
    There is no generic ADO tool for getting the SQL that ADO assembles.
    With DbExpress the SQL used is generated at the Borland component level.
    With ADO components the SQL gets generated in the ADO layer not the borland
    component level 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: George Kvasha: "ALTER COLUMN"

    Relevant Pages

    • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
      ... MS ADO passes SQL directly to OLEDB provider. ...
      (borland.public.delphi.database.ado)
    • Re: Programmatically changing a SQL view in a ADP
      ... One of the differences between DAO and ADO is that DAO combines data ... there isn't a way to do this successfully with ADOX. ... But T-SQL, SQL Server's ... Dim cn As ADODB.Connection ...
      (microsoft.public.access.modulesdaovba)
    • Re: Smartest way toa add records manually
      ... class modules to represent tables, collections, etc., and started isolating ... we've transitioned from Access as a back end to SQL Server as ... Then I discovered why I transitioned to ADO. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Prevent Commands in SQL Update
      ... I am not familiar with PHP, but ADO is ADO ... ... sinple way to clean an SQL statement. ... Server-side validation of ALL user input MUST be done, ...
      (microsoft.public.data.ado)
    • Re: dumb previous question - repost
      ... dataaccess technology not a datatransfer technology although it can be used ... Here is what I do right now with com ado from ... > With my com ado loop above I can transfer 5000 records ... > from sql server to Access in a few seconds. ...
      (microsoft.public.dotnet.framework.adonet)