not exlisive use

[MdVries]

I have made an program in VFP

But my report locks the partij table
When i start my report an sql query runs an shows the report
That works fine.

but when i close my report my tables are locked witch i use in my sql query that i use for my report.

How can i use select * from partij without locking my table
i only want to read my table partij, not lock it.

i get the error message "file is in use".

the partij table is an detail table of an header/detail table.
So i can't close the partij table

 

[EzLogic]

Do you have Set Exclusive off?

Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan

 

[Steve Bowman]

this actually sounds like you are trying to open a table that is already open
you could do something like this

if !used("myTable")
use myTable in 0 shared
endif
select myTable


Steve Bowman
Independent Technology, Inc.
CA, USA

 

[MdVries]

what does "in 0 shared" do?

 

[Mike Lewis]

MdVries,

IN 0 means that the table will be opened in the next available work area.

SHARED means that more than one user -- or more than one process -- can open the table at the same time.

In your case, the problem might have been caused by the fact that both the query and the report were opening the table. If it wasn't SHARED, that wouldn't have been possible.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk