Question on scripting language

[Don2555]

I have never used Delphi database. I have experience with Sybase, Oracle, Informix, MSSQL, MySQL, etc. I have scripted SQL with all of the other DBMSs, but not with Delphi. Is it possible to use a WSH or Perl, to script a series of commands for Delphi?

I have a client that has put a huge amount of commands/aggregations in a crystal report. When this report is run by 14 retail stores, the server is slowed significantly by the multiple instances of this report.

I would like to transfer the aggregations from the report to the database, and have all the output produced during the offpeak times, and be available for the users to just display the results.

Thanks

 

[unclejimbob]

I guess the short answer is 'Yes' you can create aggregates using the InterBase stored procedure and trigger language extensions and the option you suggest would be to call an InterBase stored procedure that creates the aggregates from whatever app you want to use (Perl script -via Win32:ODBC, Delphi program or whatever) and then let it do all the hard work.