Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread 12345.idx and 12345.dat files created at runtime
Tue, Dec 12 2006 6:14 PMPermanent Link

"Luis Concepcion"
Hi!

Using ReportBuilder with DBISAM 4, some "123456.dat" and "idx" files are
created automatically at runtime after printing some reports. I suppouse it
occurrs when printing/designing sql reports. Maybe because RequestLive of
those SQL reports is 'False'.

Is it possible to set RequestLive to 'True' for RBuilder sql report
templates?
What are the possible disadvantages of those DAT/IDX files?
Is it possible to avoid them or ensure that they are deleted after printing
the report?

Thanks!

Wed, Dec 13 2006 1:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Luis,

<< Using ReportBuilder with DBISAM 4, some "123456.dat" and "idx" files are
created automatically at runtime after printing some reports. I suppouse it
occurrs when printing/designing sql reports. Maybe because RequestLive of
those SQL reports is 'False'. >>

Either RequestLive:=False or the queries cannot generate live result sets:

http://www.elevatesoft.com/dbisam4d5_live_queries_and_canned_querie.htm

<< Is it possible to set RequestLive to 'True' for RBuilder sql report
templates? >>

You'll have to ask Digital Metaphors about you would do that.

<< What are the possible disadvantages of those DAT/IDX files? >>

None.

<< Is it possible to avoid them or ensure that they are deleted after
printing the report? >>

They should always be deleted by DBISAM after the TDBISAMQuery component
using them is closed and unprepared.  The only time they would be left
around is if the application was improperly terminated before this occurred.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Dec 13 2006 3:26 PMPermanent Link

"Robert"

"Luis Concepcion" <direccion@simplygest.es> wrote in message
news:43D31978-9A36-4CE8-B96D-FBE503605E50@news.elevatesoft.com...
>
> Is it possible to set RequestLive to 'True' for RBuilder sql report
> templates?

Regardless of the setting of RequestLive, any query containing a JOIN, or an
ORDER BY that does not correspond exactly to an existing table index, will
be canned. In real life, and especially when you're dealing with reports,
very few queries would qualify for live results.

Robert


Image