Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Extensions » View Thread |
Messages 1 to 2 of 2 total |
TnlhTemporary - alpha version |
Sun, May 1 2011 3:41 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 Attachments: nlhEDBTable.dpk nlhEDBTable.res nlhTable.dcr nlhTable.pas |
Wed, May 4 2011 10:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | As the title says
Roy Lambert Attachments: nlhEDBTable.dpk nlhEDBTable.res nlhTable.pas |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |