Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
With Buffering = .T
Message
From
06/02/2019 12:11:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Title:
With Buffering = .T
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01665963
Message ID:
01665963
Views:
162
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
Next
Reply
Map
View

Click here to load this message in the networking platform