>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."
>WITH (BUFFERING = .T.) >>or
>WITH ('BUFFERING' = .T.) >>
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