>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