master detail using frxado

maeve_zahramaeve_zahra
edited 6:22PM in FastReport 3.0
dear all, i create master detail report using frxado. and i have query like this on detail query: select * from employeedetail where employeeno=:a

and i put parameter like this on query detail: a;string;<q1.employeeno>

q1.employeeno is field employeeno from master table.
i think that is correct because i use string as employeeno but i got this error message: argument are the wrong type.

i try change the parameter type to int also but still i got the same error.

please, anyone can help?

tia,
ryan

Comments

  • AlexTZAlexTZ
    edited 6:22PM
    To set master-detail relation, use the following sql:
    select * from employeedetail where employeeno=:employeeno
    and connect detail query to the master table via Master property. Master table should contain the field named "employeeno". Just like in Delphi...
  • maeve_zahramaeve_zahra
    edited 6:22PM
    AlexTZ wrote:
    To set master-detail relation, use the following sql:
    select * from employeedetail where employeeno=:employeeno
    and connect detail query to the master table via Master property. Master table should contain the field named "employeeno". Just like in Delphi...
    i try like you said and it work like a charm. thanks alot.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 3.0Comment As ...

© Vanilla Keystone Theme 2024