api way

[Jules Jacquot]

Le 23 juil. 05 à 18:18, Ruslan Zasukhin a écrit :

> On 7/23/05 9:48 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>  
> wrote:
>
>
>>> dg=app.mdatabase.SQLSelect("select RecID,* from Article where BArt
>>> like '"+ch+"%' and (JDepArt='C' and Ordart='"+Myord+"') order by  
>>> BArt")
>>>
>
> What about next style?
>
>
> Foo()
>     bitset1 = tblAticle.field("BArt").FindLike( ch + "%" )
>     if bitset1 = nil then return nil
>
>     bitset12 = tblAticle.field("JDepArt").FindValue( "C", bitset1 )
>     if bitset12 = nil then return nil
>
>     bitset123 = tblAticle.field("Ordart").FindValue( "Myord",  
> bitset12 )
>     if bitset123 = nil then return nil
>
>     return tblArticle.Sort( bitset123, "BArt" )
> end
>

maybe it's better

i'll try it

but question :

are you sure that this line is correct ?

return tblArticle.Sort( bitset123, "BArt" )

i'll write ' tblarticle.field("Bart") ' instead "BArt" solely

best

jules

--------------------------------------------------
Il n'y a jamais d'autre difficulté dans le devoir que de le faire.
ALAIN