Archive Reader

rbuser

Hi

Can you please advise what I am doing wrong with a simple archive reader
linked to my Invoice Table.

I have a table of invoices one of the fields contains a RAF archive - the
table is displayed in a simple grid.

I have a dataPipeline (plCopyInvoice) linked to the same datasource as the
grid.

I have a dbArchive (dbArchiveReader) reader, in databaseSettings I have

BLOBField=INVOICE_RAF
DataPipeline = plCopyInvoice
NameField = INVOICE_NO

I have a TppViewer in Report property is Report=dbArchiveReader

On the grid I have set the onClickCell event to

if (InvoiceTable.FieldByName('INVOICE_RAF').AsString <> '') then
begin
DBArchiveReader.DatabaseSettings.Name :=
InvoiceTable.FieldByName('INVOICE_NO').value;
ppViewer1.RegenerateReport;
end;

I can see the invoice in the ppViewer exactly as required

However when I click on the grid, the pointer moves to the first record in
the table and then back to the record I selected, this is very disturbing
when there are hundreds of records and the grid is jumping to the first
record and then back to the current.

I have tried, in plInvoice setting moveBy=0 and
rangeBegin=rangeEnd=rbCurrentRecord

If I comment out the lines in the onClickCell the jumping back/forward
ceases. Uncomment the DBArchiveReader.DatabaseSettings.Name and
ppViewer1.RegenerateReport; then the undesirable behaviour returns.

Any advice gratefully appreciated.

Regards

PLJ

nicocizik

Hi Philip,

If you set Viewer.SinglePageOnly to True, does the issue still occur?
If so, please create a simple demo I can run here that demonstrates this
behavior and send it to support@ in .zip format.

rbuser

Hi Nico

Viewer.SinglePage only solved the problem.

Many Thanks

PLJ