Re: Problems with acces to dbf used in DE



SELECT * simply points another alias to the same table. It does not make a cursor in memory, which is what you want. Try SELECT * FROM DosTable INTO CURSOR mvcursor NOFILTER

--
----
Craig Berntson
MCSD, Visual FoxPro MVP
Salt Lake City Fox User Group
"Stoyan Malchev" <stoyan.malchev@xxxxxxxxxxx> wrote in message news:uG8az1gPHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
I have in DE in a a report:

set exclu off
sele * from DosTable into cursor mycursor
use in DosTable

This is the only place where i am using the table "DosTable"
If Private Data Session is off exclusive access to DosTable is impossible until I exit the exe
If Private Data Session is on exclusive access to DosTable is impossible until the report is closed.

What can I do to release DosTable?

Thanks in advance for any help.

Relevant Pages

  • Re: reports based on cursor?
    ... A cursor is a temporary table, ... a SQL Select statement. ... or they will close and be destroyed automatically when the VFP ... draw the report controls on the report ...
    (microsoft.public.fox.vfp.reports.printing)
  • Re: reports based on cursor?
    ... > a SQL Select statement. ... or they will close and be destroyed automatically when the VFP ... Cursor is also used loosely to refer to any temporary table, ... draw the report controls on the report ...
    (microsoft.public.fox.vfp.reports.printing)
  • Re: Where to enter code to sort
    ... don't have anything in the report's data environment. ... at whatever cursor is in the current work area, no matter what it is named. ... I usually create reports this way by individually drawing the report ... VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx ...
    (microsoft.public.fox.vfp.reports.printing)
  • Re: Printing labels?
    ... SET PRINTER TO NAME Gen_Label ... REPORT FORM labels\address.lbx TO PRINTER NODIALOG ... Report command. ... Often one single SQL result cursor is enough to display parent table ...
    (microsoft.public.fox.programmer.exchange)
  • Re: how to make report with three tables
    ... > report from the cursor. ... > inner join b; ... >> a_id charforeign key ...
    (microsoft.public.fox.programmer.exchange)