Rushmore/Optimization between FoxPro and CF

[Natesac]

Ok... so my company has an 'ITEMS.DBF' table that stores every single line item
we sell. If a line item is returned before we invoice/ship it, the record is
deleted. Now, for those of you who know FoxPro, the record is still visible.
When you use SQL statements in CF, Rushmore (which is the optimization process
that discards things such as 'deleted' records) /OPTIMIZE is defaulted to 'ON'.
The question is this:

SET OPTIMIZE ON|OFF

If this is the FoxPro statement that I need to make in accessing the
information through <cfquery>, how do I send that command from a .cfm?

Any help is greatly appreciated.

-Nathan

[philh]

One thing you can do is create a .prg with that statement, and a parameter to
switch on/off. Compile the program and put the fxp file in the SYSTEM32
directory. The Fox driver will treat it as a function, so you could call it
like this:

<CFQUERY datasource="#FOXDSN#" name="setoptimize">
SELECT MyOptimizerProgram('ON') as result from SomeFoxTable
</CFQUERY>

[Natesac]

Awesome.

Good thinkin'. :)

Cheers!
Nathan

[philh]

Let me know if it works for you. We have a couple of these that work and are, shall I say, rather complex.