Richard I used the NOFILTER clause and a physical file was NOT created ...
Paul -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 05 January 2016 16:28 To: profoxt...@leafe.com Subject: RE: Odd/inconsistent behaviour of DBF() IIRC correctly, anything that needs to be treated like a DBF, such as an in-memory cursor reference in an xBase function call, will create a temporary file. Using NOFILTER or READWRITE will force a file to be created as well. The file extension does not make it a DBF. (See forms, class libraries, report and label layouts, etc.) -- rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Tuesday, January 05, 2016 11:17 AM To: profoxt...@leafe.com Subject: Odd/inconsistent behaviour of DBF() Hi all I hadn't noticed this before but ... USE CNAME SELECT * FROM CNAME INTO CURSOR TMPCNAME NOFILTER ? ALIAS() -> tmpcname ? RECCOUNT() -> 96 ? DBF() -> C:\TEMP\0000TIQ10065.TMP ? FILE(DBF()) -> .F. COPY TO TEMP STRUCTURE USE TEMP IN 0 SELECT TEMP APPEND FROM DBF('tmpcname') ? RECC() -> 96 IOW APPEND FROM DBF('tmpcname') manages to add 96 records from a non-existent DBF (C:\TEMP\0000TIQ10065.TMP) I know that the cursor is in memory and does not have a presence on disk so why does DBF('tempcname') tell me that the name of the table is C:\TEMP\0000TIQ10065.TMP ? Anybody have any thoughts on this behaviour? Paul Newton [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/9a8106afb0ef9b44b69045c4448935a20123349...@nlbawexmbx3.infor.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.