How to add values in MS SQL Database

Hello everybody,


Is it possible to insert values from variables from fastreport in an MS SQL database?


Actually I can see and print the values of the variables in the report but I would like also to send them in a SQL Database.


THanks in advance for helping and best regards

Comments

  • Use INSERT statement in the TfrxADOQuery. Use frxADOQuery1.ExecSQL to execute this query

  • edited July 2020

    Hi...😎

    In my opinion...it is not the task of the report to write in the database...even if it is possible. πŸ™„ The report has no knowledge of the database. Only DataSets. He only shows the data...thats is his task. Everything else is business logic. πŸ˜‰

  • Hi and thanks for answering. meanwhile i found the solution.

Leave a Comment