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

TextPipeline and SQL

edited October 2008 in Datapipelines
I would like to create a report based on a large text file, grouping and
summing some of the data. Is it possible to use a TextPipeline and an SQL
statement together, without a database involved? (Sorry if this is a very
basic/obvious question, I'm still coming to grips with ReportBuilder).

Many thanks in advance - Andrew.

Comments

  • edited October 2008

    The TextPipeline supports simple data traversal, there is no SQL engine
    support.

    You might be able use a Delphi add-on component that has an in memory
    dataset that can do something like that. I googled and found this...

    http://www.aidaim.com/in-memory_sql_database_delphi.htm

    Another option would be to write code to traverse the TextPipeline and
    produce a second textfile that contains the summarized data. Then use a
    second TextPipeline for the report.




    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.