Pipeline with query

rbuser

I am using a data pipline with an ApolloQuery.

I am new to SQL therefore the problem might be in SQL

The problem: The SQL selects data correctly. It all shows in a dbGrid AOK.

When I create a report it keeps processing over and over the first 2 records
and never gets to the rest.

What am I doing wrong?


SQL :
Select CUSTOMERS.LASTFIRST AS [LASTFIRST],

CUSTOMERS.ACCTNBR AS [ACCTNBR],

CUSTOMERS.CUR_BAL AS [CUR_BAL],

TRAN.GL AS [GL],

TRAN.OWNER_CODE AS [OWNER_CODE],

TRAN.TRDATE AS [TRDATE],

TRAN.DEBIT AS [DEBIT],

TRAN.CREDIT AS [CREDIT],

TRAN.PAYMENT AS [PAYMENT],

TRAN.COMMENT AS [COMMENT],

TRAN.NOTES AS [NOTES] From TRAN Inner Join CUSTOMERS

ON (TRAN.ACCTNBR = CUSTOMERS.ACCTNBR)

Where (CUR_BAL > 0)

Order By CUSTOMERS.LASTFIRST ASC

digitalmetaphors

ReportBuilder's datapipeline architecture relies on TDataset functionality.
If a TDataset descendent that you connect to, such as Apollo, doesn't
support all of the functionality of theTDataset ancestor interface properly,
then we can't work with it using our datapipeline architecture. This is
most likely the problem. Since Apollo has a different implementation of
their dataset, than proper TDataset descendents, we can't work with it
generically with our pipelines. What can do is create an Apollo data
pipeline that can traverse the dataset correctly using the Apollo
architecture for data traversal. You can also create JITPipeline to ruturn
the data instead of creating a custom data pipeline.


Cheers,

Jim Bennett
Digital Metaphors