I've enhanced my subclassed components with TnlhTemporary. This creates a temporary table from sql, and will cope with parameters. Essentially its a way of providing an editable canned result set with minimal effort.

You can also give it a list of fields to be indexed and it will create the indices for you, with the top one on the list being used for IndexName for the table.

There's also a flag which will auto create the table name for you.

All parameters must be supplied via ParamByName().Asxxx and if you choose the wrong As it may have interesting results - each of the parameters is actually converted to a string and the SQL used to create the table altered using StringReplace calls on the parameters in there.

Also all parameters must be specified as ramname in the SQL

If a parameter is not supplied the string used is IS NULL

Finally there's a flag which says the temporary table should be dropped when its closed - I know it will be deleted when the app's closed but I like to keep things tidy.


Roy Lambert

As the title says

Roy Lambert