Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link SQL Related Articles: Creating views to retrieve data from tables 2003-04-30 -- Geoff Bomford Newsgroups: softvelocity.products.c55ee
Create a view of the file and don't nominate any fields, that way the
structure always matches the file definition in both dictionaries.
MyView VIEW(MyFile)
END
OPEN(MyView)
MyView{Prop:SQL} = 'SELECT * FROM MyFile WHERE...'
CLOSE(MyView)
Geoff Bomford
www.comformark.com.au
Computer services For Marketing
"Arnor Baldvinsson"
Possible Speed Increases 2003-09-02 � Karl Greenwood Using Select field1, field2 ... fieldn should be faster then Select * as the server has to query its system tables for a field list. In tests using clarion and asp with ms sql the speed increase was measurable with mulitple transactions. Having said that a seperate test on a cold fusion app with ms sql showed no increase. And as a side note only use Select * if you really need all fields to be returned Today is November 21, 2024, 7:00 am This article has been viewed 35221 times. Google search has resulted in 45 hits on this article since January 25, 2004.
|
|