Navegation in script

rogerruiz

Hi

I need in script have access to records in a table (DBISAM), for example:

My proyect (builder) have a Table with name tblPartidas (tblPartidas have a Calculed y Lookup fields), i use one TfrxDBDataSet for link to tblPartidas with name "Partidas"

Script

{
Partidas.First; // Error.
<Partidas.First>; //Error
...



}

I need any process in the report, i dont want use component's table in the report,
in the report can??t calculed and lookup fields.

Any solution? thank??s and excuseme my bad english.

Best regards
Roger

thenicespider

FR can access field from Delphi dataset but use FR Dataset, look at this sample:
var
ACCOUNT_CODE : String;

procedure MasterData1OnBeforePrint(Sender: TfrxComponent);
begin
//Akses from Dataset use FR Dataset!!!
ACCOUNT_CODE := <frxDBDataset1."ACCOUNT_CODE">;
end;

No matter ACCOUNT_CODE is data, lookup or calculated field.

Do you mean like this?

rogerruiz

Hi

Thanks for your responce Thenicespider and it does not work to me.

I need navigate in the table by code, I need print data in the title band.

My solution are two:

1: Use DoblePass and process in the MasterData band in the first pass.

2: Use define "userfunction" with implemetation navigation table.

I think existed another form better.

Best regards
Roger