× General discussions, feature requests for CodeTyphon Project and discussions that don't fit in any of the other specific CodeTyphon forum categories.

Question Power PDF database Question

  • Peter Pohlmann
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 years 1 week ago #10067 by Peter Pohlmann
Power PDF database Question was created by Peter Pohlmann
Hello Gurus,

I am on a MAC and try to generate a PDF of some database records,
Putting the PRPage1 component and PRGridPanel Components on the form.
As I understand it, the PRText component should now display all rows of the table.
The Query result has 8 records, but only the last one is displayed. I assume the loop
works ok, but somehow the PRText1 component does not show all records.
I have tried the label component too, but that does not work either.
What am i doing wrong ?


Form7.SQLQuery1.First;
PRtext1.Printable:=true;

while not Form7.SQLQuery1.EOF do

begin
{
PRtext1.lines.add(Form7.SQLQuery1.FieldByName('itemno').AsString);
}
PRtext1.text:=Form7.SQLQuery1.FieldByName('itemno').AsString;

Form7.SQLQuery1.Next;

end;

Thanks
Peter

Please Log in or Create an account to join the conversation.