>I have a VFP 6 app. running behind Foxisapi. My object opens tables on it's INIT method and keeps the tables open for it's live duration. Everything works great. When a second instance of my object is fired by Foxisapi (Foxisapi is setup to use up to 5 instances) the INIT method fires again and I get a 'File already open' error.
>
>Question: All this multiple instances of my object, fired by Foxisapi, share the same data sessions ?. If so, is there a way to force a private data session for each of the instances of my app. ?
No, but each session needs to set up VFP as if it were a fully new instance running. So you need to SET EXCLUSIVE, SET REPROCESS etc. properly to avoid multi-user conflicts. Think of each instance as a new copy of VFP running with a different user accessing the same data...
>(Note : This is a migrated wireless barcoding system (from foxpro DOS 2.6-serial comm. to IIS-HTML-Foxisapi-VPF6) were we need to have the tables open all the time to achieve under one second response time to the wireless barcode scanners otherwise they time-out. Opening and closing tables on demand slows down the app.)
You don't have to close tables. Just make sure they're not used EXCLUSIVE by the environment.
+++ Rick ---