>>Hi,
>>
>>I need to make a cursor from my tables inclusive all records in buffer, so constructed:
>>
>>

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

>>Resulting in error "Command contains unrecognized phrase/keyword."
>>The line
>>

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

>>or
>>

>>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
>

Thank you,

works fine.

Koen