>> I've been experimenting today and I've found that for hand coding, I
>> get a major improvement in speed if I use prop:filter instead of SET.
>>  For example:

>> SET(KEY)
>> LOOP
>>  NEXT(FILE)   !first occurence generates a query that gets the ENTIRE
>>  FILE
> !
>>  IF ERRORCODE() THEN BREAK.
>> END

>> gets changed to:

>> FILE{PROP:SQL}='SELECT * FROM FILE WHERE .......whatever I want for a
> query'
>> LOOP
>>  NEXT(FILE)
>>  IF ERRORCODE() THEN BREAK.
>> END

>> I'm not sure where the data is going with Prop:sql but it seems to
>> work well.  Any problems with the above code?

> That's a way I do. The only thing you have to take care with this code
> is that the fields in your database must be declared exatly in the
> same order than in your dictionary :
> With the "select * from file", the back end return you all the fields
> of your table, in the order they are declared. Then Clarion try to
> read them in the order they are declared in the dictionary.
> I personaly prefer to declare a view in Clarion, in which I just
> declare the fields that I need, then use the Prop:Sql on the view.

> Example :

> ViewSql  VIEW(FILE)
>                    PROJECT(FIL:Number)
>                    PROJECT(FIL:Desciption)
>                END

>   CODE
>   OPEN(ViewSql)
>   ViewSql{Prop:Sql} = 'select Number,Description from File where ...'
>   LOOP
>       NEXT(ViewSql)
>       IF ERRORCODE() = 33
>            BREAK
>       ELSIF ERRORCODE()
>            MESSAGE('Error is ' & ERROR())
>            BREAK
>       END
>       ! Your stuff
>   END

> Now, Michael Gould send me a message that I copy here (I don't know
> why he don't post it to the group) about a problem that I personaly
> never had, but maybe you can ask him some precision

>> There are some inherent problems with the Clarion chain which hasn't
>> had
> any
>> overhauls since CW2 days.  We were doing SQL back then when I worked
>> for TopSpeed and the biggest problem we saw is that for every Do
>> RefreshWindow it would loop through that 3 times.

>> This causes extra work on the backedn.

> HTH,

> Guy