RE: "USE" commands in Visual Foxpro by MichelRoy
MichelRoy
Thu Nov 24 05:58:08 CST 2005
are you trying to open the table a second time? you say you use SELECT 1 many
times. normally, you would open the table and give it an alias name then use
this alias name in subsequent SELECT. Using numbers for work area can be
confusing
Ex:
USE "MyTable" IN 0 SHARED ALIAS myTable
SELECT MyTable
...
If you need to have the same table opened more than once in the same
datasession
you would use:
USE "MyTable" AGAIN IN 0 SHARED ALIAS SecondTime
SELECT SecondTime.
"Sam Hung" wrote:
> The OS in computer "A" is XP and have VFP installed, but no in 'B' and
> others. For the other computers are only run-time part are installed. You may
> say "A" is acted as a Server.
> Are those things correctly installed will help solve my problem?
> Or something else I should do to solve my problem?
> Please help,
> Many thanks,
>
> Sam.
>
> "Michel Roy" wrote:
>
> > so your computer "A" is acting as a server. Is it a Windows Server, Windows
> > XP or Windows 98?. Windows 98 can be problematic. Do you have VFP installed
> > on each machine? The run-time part at least?
> >
> > "Sam Hung" wrote:
> >
> > > Hi All,
> > >
> > > This is Sam. I'm new to Visual Foxpro.
> > > I'm now having troubles about sharing .exe file and seeking for any
> > > professional help from all of you.
> > > I have developed a system and now expecting to share my compiled .exe
> > > file(inventory.exe) to other computers.
> > > My system are placed in computer "A" and logon to it, and using B computer
> > > to try access into same system in "A" computer.
> > > It generated an error message "Invalid operation of reading files". The
> > > system was closed after hit "cancel".
> > > I debugged and found an error message was from using the word "USE".
> > > I often use "select 1" (workarea) and "use sysid"(open table "sysid").
> > > I already placed the command "SET EXCLUSIVE OFF" in Main Program and the
> > > first command of each form designer "init()".
> > > I had also tried "use sysid shared" it still doesn't work.
> > > So what's wrong with my program?
> > >
> > > Please help,
> > > Many thanks,
> > > Sam.
> > >