>>

>>WITH ('BUFFERING' = .T.)
>>

>>
>>no difference
>>
>>How am I supposed to compose this correctly?
>>
>>Regards,
>>
>>Koen
>
>From what I gather what is stated in the help, the WITH clause goes with the tables being referenced in the FROM and JOIN -- so relocating the WITH clause is probably what you need to do::
>

>SELECT ;
>[Nr.: ]+DTOC(T1.datumvan) +[ ] + DTOC(T1.datumtot) +[ ] +ALLTRIM(T2.voornaam)+ [ ] + T2.famnaam  as declaratie, ;
>T1.id , ;
>T2.ID as nawID FROM declaraties T1 WITH (BUFFERING = .T.) ;
>JOIN naw T2 WITH (BUFFERING = .T.) on T1.inaw=T2.ID ;
>WHERE !EMPTY(T1.datumvan) ;
>INTO CURSOR curcboDeclaraties NOFILTER READWRITE
>BROWSE NORMAL
>

Confirming this eactly 1 year later (-10 minutes): the WITH clause goes immediately after the FROM name.