Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

AV in report with manual SQL and parameter

edited July 2009 in DADE
RB 11.05 Enterprise, Delphi 2009, DADE: dakbmMW

Hello,

in a report, I use a datapipeline with manual SQL and one parameter.

When loading this report or select tab "Preview" and then "Design", an AV
occurs in
ppParameter.pas, function TppParameterList.GetParameterForName, Line 1228:

while (Result = nil) and (liIndex < ChildCount) do <- ChildCount
returns nil!!!

Any ideas?

Lars Hirthe

Comments

  • edited July 2009
    Hi Lars,

    We are going to need more information about the nature of your SQL statement
    and report design to track something like this down. Please give more
    detail about what you are building or give the steps I can take using one of
    our demos to recreate the issue you are seeing.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2009
    Hi Nico,

    I can reproduce this error with a blank report.
    In this report, I create a parameter and a datapipeline with manual sql,
    something like that:
    SELECT * FROM mytable WHERE id=:myparam

    The error only occurs, when I use manual SQL AND a parameter.

    Perhaps, the problem is the dakbmMW?!


    Lars Hirthe


  • edited July 2009
    Hi Nico,

    some more info.

    The error does not occur with the demo files using daDBBDE.
    So the problem is the dakbmmw.

    I know, this unit is not from DM, but is it possible to give me some advice,
    where
    do I have to search.

    The exception occurs in this method:

    function TppRelative.GetChildCount: Integer;
    begin
    Result := FChildren.Count; <--- EXCEPTION !!!
    end;

    Here is (a part of) the exception log:

    Exception:
    -----------------------------------------------------------------------------------------------------------------------
    2.5 Type : EAccessViolation
    2.6 Message : Zugriffsverletzung bei Adresse 005C668C in Modul
    'ReportBuilder.exe'. Lesen von Adresse 00000088.

    Call Stack Information:
    -------------------------------------------------------------------------------------------------------------------------------------
    |Address |Module |Unit |Class
    |Procedure/Method |Line |
    -------------------------------------------------------------------------------------------------------------------------------------
    |Running Thread: ID=3904; Priority=0; Class=; [Main]
    |
    |-----------------------------------------------------------------------------------------------------------------------------------|
    |005C668C|ReportBuilder.exe|ppRelatv.pas |TppRelative
    |GetChildCount |504[1] |
    |005E9DB6|ReportBuilder.exe|ppParameter.pas
    |TppParameterList |GetParameterForName |1228[5] |
    |005E9BBC|ReportBuilder.exe|ppParameter.pas
    |TppParameterList |GetParameterForName |1223[0] |
    |005E9E51|ReportBuilder.exe|ppParameter.pas
    |TppParameterList |InList |1260[1] |
    |005E9E2C|ReportBuilder.exe|ppParameter.pas
    |TppParameterList |InList |1259[0] |
    |008113DA|ReportBuilder.exe|daSQLText.pas |TdaSQLText
    |GetCommandText |285[6] |
    |0080BC68|ReportBuilder.exe|daSQL.pas |TdaSQL
    |GetSQLCommandText |8376[3] |
    |0080BC48|ReportBuilder.exe|daSQL.pas |TdaSQL
    |GetSQLCommandText |8373[0] |
    |00805827|ReportBuilder.exe|daSQL.pas |TdaSQL
    |GetMagicSQLText |3615[5] |
    |00805810|ReportBuilder.exe|daSQL.pas |TdaSQL
    |GetMagicSQLText |3610[0] |
    |0088DECA|ReportBuilder.exe|dakbmMW.pas
    |TdakbmMWQueryDataView |UpdateQueryObject |556[15] |
    |0088DDB4|ReportBuilder.exe|dakbmMW.pas
    |TdakbmMWQueryDataView |UpdateQueryObject |541[0] |
    |0088DD28|ReportBuilder.exe|dakbmMW.pas
    |TdakbmMWQueryDataView |Loaded |504[2] |
    |77680226|USER32.dll | |
    |DispatchMessageW | |
    |7768021C|USER32.dll | |
    |DispatchMessageW | |
    |008FB4D2|ReportBuilder.exe|DataModuleReports.pas |TdmReports
    |DataModuleCreate |108[5] |
    |7684AE35|ole32.dll | |
    |CoInitializeEx | |
    |0090204F|ReportBuilder.exe|ReportBuilder.dpr |
    | |12[2] |
    |7646D0E7|kernel32.dll | |
    |BaseThreadInitThunk | |
    |-----------------------------------------------------------------------------------------------------------------------------------|
    Assembler Information:
    ----------------------------------------------------------
    ; ppRelatv.TppRelative.GetChildCount (Line=504 - Offset=1)
    ; --------------------------------------------------------
    005C668C mov eax, [eax+$0088] ; <-- EXCEPTION
    005C6692 mov eax, [eax+$08]


    Lars Hirthe

  • edited July 2009
    Hi Lars,

    This still may be an issue with the parameter logic. Try setting your
    library path to \RBuilder\Source\ and trace into
    TppParameter.GetParameterForName routine and see why the AV might be
    occuring.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2009
    Sorry, I re-read your initial post and you mention where the error is
    occuring. Now we need to try to track down why the ChildCount is nil for
    your application and why it functions correctly with the demos.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2009
    Hi Nico,

    my newest investigations.

    The AV occurs, because TdaSQL.GetReportParameters returns nil
    (DataView.Report is nil!!)

    The call stack:

    ppParameter.TppParameterList.GetParameterForName('Test') <- Exception !!!
    ppParameter.TppParameterList.InList('Test')
    daSQLText.TdaSQLText.GetCommandText(nil) <-
    aParameters=nil
    daSQL.TdaSQL.GetSQLCommandText
    daSQL.TdaSQL.GetMagicSQLText
    dakbmMW.TdakbmMWQueryDataView.UpdateQueryObject
    dakbmMW.TdakbmMWQueryDataView.Loaded

    I assume, that the unit dakbmMW is the problem.


    Lars Hirthe

This discussion has been closed.